[Libreoffice-ux-advise] [Bug 142664] EDITING Calc Auto-Filter does not filter empty cells with a formula when "not empty" is selected

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142664

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #4 from Regina Henschel <rb.henschel at t-online.de> ---
Your expectation is wrong. Cell A3 contains a formula, so it is not empty. The
items 'Empty' and 'Not Empty' use the same logic as the function ISBLANK.



To have more than one auto-filter on a sheet, you need to define a range of the
data (menu Data). The range needs to contain a label cell. Then select the
range (menu Data) and then apply auto-filter. If you do not define a range, an
auto-filter works on an anonymous range and there is only one anonymous range
per sheet.

-- 
You are receiving this mail because:
You are on the CC list for the bug.