https://bugs.freedesktop.org/show_bug.cgi?id=57431
Mirosław Zalewski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|x86 (IA32) |All OS|Windows (All) |All CC| |[email protected] See Also| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=45681, | |https://bugs.freedesktop.or | |g/show_bug.cgi?id=68113 Summary|Calc: "Empty and Not Empty" |[Autofilter] Unable to show |in the autofilter list |both empty cells and rows |behave inconsistently |with certain value (Excel | |users might expect this | |ability) --- Comment #5 from Mirosław Zalewski <[email protected]> --- This bug report is rather exaggerated. Yes, AutoFilter does not allow to show both empty and somehow-valued rows. This is one of it's limitation. Probably it could be overcome by making "Empty" part of main list and giving it checkbox on it's own. But then, it does work consistently (especially since Bug 45681 is "caused" by misunderstanding of how AutoFilter window works). It is also logical - if you want to see only empty cells, then cells with value should be hidden. If anything, it does not work as Excel user might expect. And since LO aims to be MS Office replacement (hence all interoperability effort), this is probably valid enhancement request. I rephrased bug title to better say what it is really about. As of last step in "demonstration" section: I believe it is totally different issue, filed as Bug 68113. -- 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
