Mark,
I tested that briefly in Excel. Excel doen't seem to make difference in v
blank cells and cels containing one or more spaces. I had blank cells, cells
with one space, and cells with 2 spaces. Only one selection came up, and it
selected all 3 variations.
I also tested prepending spaces to values, and adding trailing spaces, and they
are ignored to ('aaa' considered the same as ' aaa' ands 'aaa '.
I assume the cell values are left and right trimmed before being considered for
filtering.
Rob.
Op 25 jul. 2014, om 22:28 heeft Mark Bourne het volgende geschreven:
> 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: [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
--
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
