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
Please could attach a minimal sample file for test?
Created attachment 133515 [details] Autofilter with similar values
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
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,
Ok, seems like this can be closed as not a bug.