https://bugs.freedesktop.org/show_bug.cgi?id=54255
Bug #: 54255
Summary: MATCH does not find empty cells
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: Other
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
enter "A" in A1
=match("",A1:A2,0) [1]
=match("^$",A1:A2,0) [2]
=match(0,A1:A2,0) [3]
all give the answer #N/A
In regular expression documentation, it says
"^$ Finds an empty paragraph."
which indicates that [2] should return 2
In http://help.libreoffice.org/Calc/Handling_of_Empty_Cells, it indicates that
either [1] or [3] should return 2.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
