https://bugs.documentfoundation.org/show_bug.cgi?id=121696
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #11 from Eike Rathke <er...@redhat.com> ---
So yes, the "<>0" condition matches empty cells now, to comply with ODFF and
interoperability with other spreadsheet implementations, see also comment 3
about Excel that does the same. The previous behaviour that excluded empty
cells was wrong and a bug.
An empty cell is not a number 0 in this context.
See also ODFF 4.11.8 Criterion
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__434502_49873571
"For <>, if the value is not empty it matches any cell content except the
value, including empty cells. "
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs