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: [email protected]
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
