Summary: | EDITING: MATCH returns #N/A with "match_type" =0 in array formula with strings | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | GerardF <gerard.fargeot> |
Component: | Calc | Assignee: | Eike Rathke <erack> |
Status: | RESOLVED FIXED | ||
Severity: | critical | CC: | erack |
Priority: | medium | Keywords: | regression |
Version: | 4.2.0.0.beta1 | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | target:4.3.0 target:4.2.0.1 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 65675 | ||
Attachments: |
test case with match array function
Screenshot showing the MATCH() Test case with the commented formulas |
Description
GerardF
2013-12-03 21:43:09 UTC
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. |