https://bugs.freedesktop.org/show_bug.cgi?id=65043
Priority: medium
Bug ID: 65043
Assignee: [email protected]
Summary: MATCH for text containing brackets returns #N/A
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79853
--> https://bugs.freedesktop.org/attachment.cgi?id=79853&action=edit
MATCH behavior on Sheet1 is incorrect.
Using the MATCH function when searching for text containing brackets results in
#N/A.
There is an attached spreadsheet demonstrating the issue.
On Sheet1, in A2:A4 there is the text (without quotes) "abc" "b[c]a" and "cab"
respectively. MATCH(A3,A2:A4,0) results in #N/A. The expected result is 2.
However, on Sheet2, A3 was replaced with "bca" and it successfully returns 2.
This was tested only on Ubuntu 12.04 with LibreOffice 4.0.3.3.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
