[Libreoffice-bugs] [Bug 144770] New: MATCH gives incorrect result

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144770
           Summary: MATCH gives incorrect result
           Product: LibreOffice
           Version: 7.2.1.1 rc
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dlynch1319 at googlemail.com

Description:
See attached spreadsheet. 

The formulas in column K are to find the position of the first empty cell in
the first few cells of the corresponding row. The results in rows 2 and 3 are
wrong, and those in rows 3,4 and 5 are right. Row 6 is the the same as rows 2
and 3, yet the result in column 5 is different.

An explanation of the formula in K2:
1/(A2:G2="") is {~DIV/0!;~DIV/0!;~DIV/0!;~DIV/0!;1;~DIV/0!;~DIV/0!}
Match is looking for 2, and 
"If Type = 1 or the third parameter is missing, the index of the last value
that is smaller or equal to the search criterion is returned. This applies even
when the search array is not sorted. For Type = -1, the first value that is
larger or equal is returned. "
So match should find index 5, which it does not do. (But it does in rows 3 ,4
and 5).

Here is a text copy of my spreadsheet:
[row1 empty]
23      87      q       a               es      1       9       q              
#N/A    =MATCH(2,1/(A2:G2=""))
23      87      q       a               es      1       9       q              
#N/A    =MATCH(2,1/(A3:G3=""))
23      87      q                       es      1       9       q              
5       =MATCH(2,1/(A4:I4=""))
23      87      q       a               es      1       9       q              
5       =MATCH(2,1/(A5:I5=""))
23      87      q                       es      1       9       q              
5       =MATCH(2,1/(A6:G6=""))
Same results after resetting user profile.

Steps to Reproduce:
See attached spreadsheet

Actual Results:
See attached spreadsheet

Expected Results:
in rows 3, 4 and 5


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210928/936a3b9d/attachment.htm>