https://bugs.freedesktop.org/show_bug.cgi?id=46062
--- Comment #5 from Mark Bourne <[email protected]> --- Created attachment 103367 --> https://bugs.freedesktop.org/attachment.cgi?id=103367&action=edit Testcase demonstrating the problem This has recently come up on the users mailing list: http://listarchives.libreoffice.org/global/users/msg39810.html For some reason my reply there doesn't show up in the archive, but I've worked up the attached example based on that. Using the filters in column B ("2 values + blanks"), which has more than one unique value in addition to some empty cells: - Filter on "aaa" shows only rows containing "aaa" (not "bbb" or empty) - Filter on "bbb" shows only rows containing "bbb" (not "aaa" or empty) - Filter on Empty shows only rows with empty cell (not "aaa" or "bbb") - Filter on All shows all rows ("aaa", "bbb" and empty) - Attempting to filter for "aaa" or "bbb" automatically selects All, and includes the empty cells. Using the filters in column C ("1 value + blanks"), which has only one unique value in addition to some empty cells: - Filter on Empty shows only rows with empty cell (not "aaa") - Filter on All shows all rows ("aaa" and empty) - Attempting to filter for "aaa" automatically selects All, and includes the empty cells. I've checked this on Windows using LO 4.0.4, which is admittedly quite old, but it looks like others are experiencing similar on more recent versions. The way the tick boxes work is a bit confusing in this regard, but it is possible to work around this by selecting "not empty" from the filters. It is also possible to choose "Standard Filter..." from the dropdown rather than using the tick boxes, and from there explicitly filter e.g. on "aaa" in column C ("1 value + blanks"). It appears that the tick boxes are intended as a quick was to set up basic filters, and don't accurately reflect more complex filters, but that's not particularly clear. Although the tick boxes don't look right after selecting "Not Empty", clicking "Standard Filter..." does show that the filter is currently set to show Not Empty values. Perhaps the tick boxes should all be greyed out if they can't accurately reflect the current filter? Even better, if (Empty) could be made one of the tick box options (without confusion with a possible value of "Empty" in a cell), it would be possible to select e.g. "aaa" and "bbb" without (Empty), or even "aaa" and (Empty) without "bbb". -- 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
