https://bugs.documentfoundation.org/show_bug.cgi?id=163791

            Bug ID: 163791
           Summary: Calc function RANK doesnt work with non-exact matches
                    since LO24.2
           Product: LibreOffice
           Version: 24.2.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to