Re: [libreoffice-users] Problem with standard filter

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


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