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
Created attachment 197461 [details] Example with RANK formula
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.