Re: [libreoffice-users] Problem with standard filter

Ah yes, I didn't mention that bit on my addition to #46062. A workaround 
for that case is:
- Select "Standard Filter..." rather than any tick boxes
- Set the "Field name" to "- none -"
- Click "OK"

I notice you've mentioned on #46062 that Excel includes a "(blanks)" 
option. That's the kind of thing I was thinking, but not sure how to 
avoid confusion with a filter for cells literally containing "(blanks)". 
How does Excel handle that? Do you get two seemingly identical entries - 
one to filter for blank cells and one for cells containing the string 
"(blanks)" - or is the one for blank cells unambiguously different in 
some way?

Mark.


Rob Jasper wrote:
> The same inconsistency also makes that if one filter on the only one value available by filtering 
> on 'Not empty', and subsequently deletes the value fro the visible rows, it is impossible to switch 
> off the selection (since 'All' doesn't work as being really all).
>
> I opened [Bug 81577] for this.

--
To unsubscribe e-mail to: users+unsubscribe@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