[Libreoffice-bugs] [Bug 89158] Autofilter no longer needs Empty and Not Empty options
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Dec 30 13:49:15 UTC 2017
https://bugs.documentfoundation.org/show_bug.cgi?id=89158
--- Comment #9 from Regina Henschel <rb.henschel at t-online.de> ---
Created attachment 138747
--> https://bugs.documentfoundation.org/attachment.cgi?id=138747&action=edit
Test for "empty"
Set a filter on column C and examine the behavior.
An empty cell is
<table:table-cell/>
in file format.
An empty string is
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p/>
</table:table-cell>
in file format.
You can have an empty string as result of a formula, e.g. ="".
You can never have an empty cell as result of a formula, because the cell
content is a formula and therefore the cell is not empty.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171230/e85e6007/attachment.html>
More information about the Libreoffice-bugs
mailing list