https://bugs.documentfoundation.org/show_bug.cgi?id=142664
Daniel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Daniel <[email protected]> --- Created attachment 179811 --> https://bugs.documentfoundation.org/attachment.cgi?id=179811&action=edit Standard Filter set to equal blank value >From the auto filter drop-down, I selected "Standard Filter" and set the third cell to equal nothing (the value field was left blank. The first time I do this the UI sets the blank value to "0", so I go back and remove the "0". The attachment shows that there are 3 possible values and the only one that is selected is "(empty)", so something is wrong in that the filter reports an (empty) value but it does not match the Auto Filter "Empty" filter. Although I don't think a filter should be impacted by the presence of a formula, I don't want to break old sheets, so maybe the solution is not to change the "Empty" filter but possibilities I see: 1) Change the wording in the values area of the filter drop-down from "(empty)" to "blank value" 2) Add an auto filter of "Blank Value" or "Empty Value" to emphasize the difference from a completely empty cell At that point, I'm not sure if this changes from a bug to an enhancement. Thanks for looking into this. -- You are receiving this mail because: You are the assignee for the bug.
