Rob Jasper wrote:
Hi,
I hope someone can help me with this...
I have a spreadsheet with around 4000 rows in it. It has an autofilter in de
co;umn headings.
In column B I have some 10 fields containing aaa, and 3 fields bbb.
Now I filter on bbb
I clear the 3 fields
If I mark all (it is not marked upon opening) in the filter I get indeed the
whole list
If I now repeat this for the aaa fields:
upon opening the all and aaa is ticked
If I unselect ALL, aaa gets unselected too (reasonable, since that the
gebaviour for more the one slection values too)
If I now select aaa, the ALL mark is also automatically selected!!
This looks plain wrong to me since no filtering is different then filtering on
1 value, since there are also empty fields.
It does seem to make setting up the filters somewhat confusing.
Basically, deselecting All and then selecting all specific values (but
not empty) acts the same as selecting All (which includes empty).
With more than one value, plus some empty cells, in the column:
- e.g. some cells with "aaa", some with "bbb", some empty.
- 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.
With only one value, plus some empty cells, in the column:
- e.g. some cells with "aaa", some empty.
- 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 using LO 4.0.4, which is admittedly quite an old
version, on Windows.
OK, the workaround is selecting on 'not empty'
Now the tick on 'aaa' is cleared, which seems wrong too!
This does seem to work as a workaround. I think the tick boxes are
intended as a quick was to set up basic filters, and don't accurately
reflect more complex filters. Although they don't look right after
selecting "Not Empty", clicking "Standard Filter..." does show that the
filter is currently set to show Not Empty values.
Now I clear the values
Now the tick is set at ALL, and I can't clear the filter anymore... (the button
is blue)
Select "Standard Filter...", set the "Field name" to "- none -" and
click "OK".
Workaround:
enter a bogus value in the column
Select all (the select mark goes off)
Now delete the value
Working on Mac OSX 10.7.5, LO 4.2.4.2 (build
63150712c6d317d27ce2db16eb94c2f3d7b699f8)
Am I missing something here?
I couldn't see any open bugs with a quick search. I'd suggest upgrading
to the latest version in the 4.2 branch (i.e. 4.2.5) and see if the
problem still occurs. If it does, search again for any existing bugs
and, assuming none are found, report either using the bug submission
assistant at https://www.libreoffice.org/get-help/bug/ or the full bug
tracker at https://bugs.libreoffice.org/.
Mark.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
