https://bugs.freedesktop.org/show_bug.cgi?id=68406
Priority: medium
Bug ID: 68406
Assignee: [email protected]
Summary: [Autofilter] "All" checkbox shows also empty cells,
which can lead to various misunderstandings
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.6.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84416
--> https://bugs.freedesktop.org/attachment.cgi?id=84416&action=edit
Example sheet with autofilter and empty cells in row
(Derived from Bug 57431)
Checking "All" checkbox will show also empty cells. This makes it's behavior
inconsistent and can lead to various misunderstandings of Autofilter nature.
Steps to reproduce:
1. Open attached spreadsheet
2. Open Autofilter popup on column B, select "little brother of 1" and "big
brother of 3". Click OK.
3. Open Autofilter popup on column B again, select "pseudonym of 5".
Actual result:
All rows are shows - also these containing empty cells.
Expected result:
Show only rows containing three selected values. Hide rows with empty cells in
column B.
Expected result is derived from assumption that "All" checkbox really means
"check all boxes above", not "show entire column".
Probably there should be one more button in popup that actually does show
entire column. It could be labeled "Show all rows" or "Remove filter rule" to
avoid confusion with "All" checkbox.
This bug is related to 57431 and 45681. Please see
<https://bugs.freedesktop.org/show_bug.cgi?id=57431#c8> for my understanding of
relations between them. Feel free to disagree and provide arguments for other
meaning of Autofilter and "All" checkbox.
Reproduced on LO 4.0.4 on Debian testing, amd64.
--
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
