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.