https://bugs.freedesktop.org/show_bug.cgi?id=72288
Priority: medium
Bug ID: 72288
Assignee: [email protected]
Summary: EDITING: MATCH returns #N/A with "match_type" =0 in
array formula with strings
Severity: critical
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.2.0.0.beta1
Component: Spreadsheet
Product: LibreOffice
Created attachment 90190
--> https://bugs.freedesktop.org/attachment.cgi?id=90190&action=edit
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.
--
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
