Bug 163791 - Calc function RANK doesnt work with non-exact matches since LO24.2
Summary: Calc function RANK doesnt work with non-exact matches since LO24.2
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-11-06 21:17 UTC by Werner Tietz
Modified: 2024-11-06 22:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example with RANK formula (19.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-11-06 21:19 UTC, Werner Tietz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Werner Tietz 2024-11-06 21:17:53 UTC
Description:
prior to version 24.2 ( at least 7.4 )
RANK works also with non-exact matches

Steps to Reproduce:
1.open attached file with some LOversion ~7.4
2.open attached file with LO 24.2 or later
3.compare…

Actual Results:
LO24.2 or later shows #N/A instead the rank

Expected Results:
should work the same way as 7.4


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.2.1 (AARCH64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded

see also: https://ask.libreoffice.org/t/rank-formula-error/113534/7
Comment 1 Werner Tietz 2024-11-06 21:19:36 UTC
Created attachment 197461 [details]
Example with RANK formula
Comment 2 m_a_riosv 2024-11-06 22:27:02 UTC
https://wiki.documentfoundation.org/Documentation/Calc_Functions/RANK

Warning:
Since LibreOffice 4.0 and until 7.5.2 (included), the function had an implementation error. For numeric values that are not listed within Data, the function returned numeric values, which was incorrect. Since LibreOffice 7.5.3, the implementation is correct, not only for values listed within Data. The "Examples" section includes results for the correct implementation, with a mark for cases in which an incorrect result would be obtained with the prior incorrect implementation.