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