https://bugs.freedesktop.org/show_bug.cgi?id=78447
Priority: medium
Bug ID: 78447
Assignee: [email protected]
Summary: Other: Wrong results from COUNTIF
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 98698
--> https://bugs.freedesktop.org/attachment.cgi?id=98698&action=edit
Example spreadsheet
Problem description:
Steps to reproduce:
1. In B1:Y1 create a row of 24 integer scores that are not unique
2. In B3:Y3 create a row of 24 random U(1) values as tie-breakers
3. In B4:Y4 sum these rows to create a list of unique values
4. In B5:Y5 rank these with =COUNTIF($B4:$Y4,">"&B4)
Current behavior:
Some rank numbers appear twice and some are missing.
Expected behavior:
Visual inspection confirms that the list is unique and so the rank should be
unique, yet some numbers appear twice and some are missing.
In the attached spreadsheet, 21 appears twice, saying that there are 21 values
in that list that are greater than both 0.890526344 and 1.1193137951, yet one
of those is greater than the other. The row actual rank shows the actual
ranking.
Operating System: Ubuntu
Version: 4.1.3.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
