[Libreoffice-bugs] [Bug 107917] Autofilter is confuse cells with similar numbers

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed May 24 14:15:21 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=107917

Jacques Guilleron <guilleron29 at aol.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |guilleron29 at aol.com

--- Comment #3 from Jacques Guilleron <guilleron29 at aol.com> ---
Hi Tiago,

You try to filter the cell containing 1 by putting 1 into Search items... 
and you are surprised that all cells remain displayed. If it's not that,
correct me.

Search items in Autofilter are made to search text into the cells. So all cells
containing the character 1 will be found.
Enter 0 as item to search, you will get 10 and 100 in the same way.

To filter numeric values, use rather Standard filter with the right criterias.

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170524/8fb15ed5/attachment.html>


More information about the Libreoffice-bugs mailing list