https://bugs.freedesktop.org/show_bug.cgi?id=46062
Joel Madero <jmadero....@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Hardware|Other |All
Status|UNCONFIRMED |NEW
Severity|normal |minor
Priority|medium |low
Summary|FILTER: Autofilter |Autofilter should not tick
|automatically selects All |"all" if each individual
|if only one category and |value is selected (blanks
|empty cells exist |should be omitted)
Ever confirmed|0 |1
--- Comment #9 from Joel Madero <jmadero....@gmail.com> ---
My test system:
Bodhi 2 (built on Ubuntu 12.04) x64
LibreOffice 4.2.6 rc
Confirmed (see notes below)
New - confirmed
Minor - can slow down professional quality work but will not prevent it
Low - the workaround is pretty straight forward (select not empty)
> 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.
Assuming the last is "attempt to filter for "aaa" AND "bbb" not or (or works
fine if you select just one as that's just step 1 and 2 above)
>
> 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".
Not a fan of graying out anything, you do it once or twice and you learn how to
workaround it. It's a pretty small issue but an issue none the less.
Changing title to better reflect the issue as this isn't dependent on only one
category existing, it's if you select all categories available (whether that is
one or ten) then "all" is automatically ticked.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
