Re: [libreoffice-users] Problem with standard filter

Sorry - replied from the wrong account; I've resent from an address 
subscribed to the list. Please don't forward the moderated copy to the list.

Thanks,
Mark.


Mark Bourne wrote:
> 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.

--
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