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.
OK, the workaround is selecting on 'not empty'
Now the tick on 'aaa' is cleared, which seems wrong too!
Now I clear the values
Now the tick is set at ALL, and I can't clear the filter anymore... (the button is blue)
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 184.108.40.206 (build 63150712c6d317d27ce2db16eb94c2f3d7b699f8)
Am I missing something here?
To unsubscribe e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] Problem with standard filter · Rob Jasper
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy