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

            Bug ID: 158258
           Summary: Rank Function not working
           Product: LibreOffice
           Version: 7.5.8.2 release
          Hardware: IA64 (Itanium)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: gmccol...@live.com

Description:
I have the following formula in a spreadsheet:
=RANK(F20,INDIRECT("o"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3&":X"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3))

This resolves to =Rank(f20,O9:x9) this equaled 4. This worked in: Version:
7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Today I downloaded the current older version (7.5.?.?) from the website and
instead of the value 4 it returns #N/A.  The help shows the comma as a
semi-colon, but when I tried that it changes it to a comma.  No matter what I
tried it wouldn't work.  I went back to the 7.4.7.2 version and it resolves
correctly again. 

Steps to Reproduce:
1.I have the following formula in a spreadsheet:
=RANK(F20,INDIRECT("o"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3&":X"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3))

This resolves to =Rank(f20,O9:x9) this equaled 4. This worked in: Version:
7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Today I downloaded the current older version (7.5.?.?) from the website and
instead of the value 4 it returns #N/A.  The help shows the comma as a
semi-colon, but when I tried that it changes it to a comma.  No matter what I
tried it wouldn't work.  I went back to the 7.4.7.2 version and it resolves
correctly again. 
2.
3.

Actual Results:
#N/A

Expected Results:
4


Reproducible: Always


User Profile Reset: No

Additional Info:
I have the following formula in a spreadsheet:
=RANK(F20,INDIRECT("o"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3&":X"&MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3))

This resolves to =Rank(f20,O9:x9) this equaled 4. This worked in: Version:
7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Today I downloaded the current older version (7.5.?.?) from the website and
instead of the value 4 it returns #N/A.  The help shows the comma as a
semi-colon, but when I tried that it changes it to a comma.  No matter what I
tried it wouldn't work.  I went back to the 7.4.7.2 version and it resolves
correctly again.

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

Reply via email to