Bug 107917

Summary: Autofilter is confuse cells with similar numbers
Product: LibreOffice Reporter: Tiago Motta <motta.tiago>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: ilmari.lauhakangas, jalojo, miguelangelrv
Priority: medium    
Version: 5.2.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Autofilter with similar values

Description Tiago Motta 2017-05-17 17:02:31 UTC 
Description:
The command AUTOFILTER does not distinct differences between cells in spreadsheet Calc that contains similar numbers such as -1 and 1 OR 1 and 100.
The spreadsheet does not filter correctly the rows containing the cells corresponding your query.

Steps to Reproduce:
1. enable autofilter command
2. choice a value with contains numbers similars (e.g. 1 and 100)
3. do

Actual Results:  
After I enable autofilter command, I try to filter the rows containing "1" as value. In this moment, I expect that only rows containing "1" in the column filtered were showing. 

Expected Results:
Any lines containing "1" contained in the cells and filtered lines "100" as the value was shown.


Reproducible: Always

User Profile Reset: Yes, I try clear my user profile. About the question above (What should the software have done instead?), the spreadsheet should filter rows and exhibits only rows with cells corresponding to parameter value.

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
Comment 1 m_a_riosv 2017-05-18 00:15:05 UTC 
Please could attach a minimal sample file for test?
Comment 2 Jacques Guilleron 2017-05-24 13:34:01 UTC 
Created attachment 133515 [details]
Autofilter with similar values
Comment 3 Jacques Guilleron 2017-05-24 14:15:21 UTC 
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
Comment 4 Tiago Motta 2017-05-25 03:20:23 UTC 
Jacques, you are right!

I expected that AUTOFILTER was filtering these date.
I will try implement manual filter. I thinked that AUTOFILTER would filter numerical cells too.

Best regards,
Comment 5 Buovjaga 2017-06-04 12:04:08 UTC 
Ok, seems like this can be closed as not a bug.