https://bugs.freedesktop.org/show_bug.cgi?id=81698
Priority: medium
Bug ID: 81698
Assignee: [email protected]
Summary: Other: median function incorrect
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Median should return the number that is middle of the ordered sequence. Please
see the failure with the following data
Steps to reproduce:
enter this 100 integers of data
49
71
76
78
85
37
40
53
87
78
28
29
38
56
83
37
52
85
74
65
6
55
55
91
57
23
25
50
81
78
40
46
65
90
7
11
17
37
56
67
23
33
97
87
97
11
12
12
84
66
4
5
0
79
88
29
31
42
76
64
2
14
19
36
52
4
37
81
98
72
3
13
37
97
60
42
47
21
75
4
4
19
45
73
39
4
23
38
86
35
20
33
97
93
83
24
61
80
69
30
Current behavior:
apply median operator as follows
=MEDIAN(A1:A100) --> 46.5 (INCORRECT!)
Expected behavior:
median should be 47.
Median should return an integer in this case, not a floating point number!
Operating System: Windows 7
Version: 4.2.5.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
