[Libreoffice-bugs] [Bug 138910] New: MATCH works only partially

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138910
           Summary: MATCH works only partially
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: a.skembris at quantdata.gr

Description:
MATCH seems to work properly for some stings but not for others.
In the attached file, in column H there are MATCH commands for the strings in
column C. Only some strings are found. 

This is  not due to improper typing of the strings. MATCH finds the same values
even when the strings are retrieved using an indirect reference, so no typing
is involved. To test this, you can change the value in cell E2 from 1 to 5.
Values 1-3 are matched, values 4 and 5 are not, just like the manual version of
column H. 

By the way, saving the spreadsheet and opening it in Excel 2010 (through Wine)
gives a different set of weird results. In that case, MATCH returns wrong
results for the first cases, correct results for the second two cases, and case
5 also fails. 





Steps to Reproduce:
1. Open example file
2. Change cell E2 from 1 to 5


Actual Results:
For E2 values 1-3, MATCH works correctly, for values 4-5 MATCH fails. 

Expected Results:
Correct results should be returned in all cases.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: en-GB (en_US.UTF-8); UI: en-US
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/20201214/4177834f/attachment-0001.htm>