Created attachment 90190 [details] test case with match array function Sorry for version number but 4.3.0 alpha is not in the list... Ttested with Version: 4.3.0.0.alpha0+ Build ID: 56ad826194d0b9b42ed8bde35836b0e59c46baa6 TinderBox: Win-x86@39, Branch:master, Time: 2013-11-30_11:04:29 on Windows Vista. Using MATCH in array context fails when "search_criterion" is string and "match_type" set to 0 =MATCH({"A";"B";"C"};{"A";"B";"C"};0) returns #N/A (3 times) See test attachment.
Eike, Could this be related to fix for https://bugs.freedesktop.org/show_bug.cgi?id=71589 ?
No.
Introduced somewhere along the SharedString implementation.
Created attachment 90197 [details] Screenshot showing the MATCH() Works for me. Win7x64Ultimate Version: 4.3.0.0.alpha0+ Build ID: 86268546a09c3bdd0d5cb6bc047408db779e057c TinderBox: Win-x86@47-TDF, Branch:master, Time: 2013-12-03_15:52:47
Created attachment 90198 [details] Test case with the commented formulas I had not load the attached file, sorry. Seems the issue is with the second parameter as range. =MATCH({"A";"B";"C"};{"A";"B";"C"};0) works. =MATCH(A16:A18;{"A";"B";"C"};0) works. =MATCH({"A";"B";"C"};A16:A18;0) doesn't work. =MATCH(A16:A18;A16:A18;0) doesn't work.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=882665d821a2fc705b7ae03372c2ae7593028210 resolved fdo#72288 made case insensitive matrix string query work again The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=507afd9531a89e5c8ec07514a8f741ce21a0b78d&h=libreoffice-4-2 resolved fdo#72288 made case insensitive matrix string query work again It will be available in LibreOffice 4.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.