GNOME Bugzilla – Bug 333809
Autofilter broken
Last modified: 2006-03-09 16:48:00 UTC
From version 1.4.3 through 1.6.1, the Autofilter function has been broken for numbers stored as text. I can successfully filter on 'normal' text fields, and also for numeric fields that are detected as numeric ( ie they are right-aligned in the cell, indicating a numeric value ), however numbers stored as text will not filter. When I select the filter combo, and then select a value to filter on, ALL rows are hidden.
Could you create a sample file, please?
Excel appears to do a string comparison when a specific item is selected in a filter. For example, 1e10 and 10000000000 are considered different, as-is the strings "0100", "100", and '100.0".
Thanks for the quick response :) Note in the attached file, that if you filter on a column that has string values ( eg the 'Site' column has 'PARRAMATTA' values in it, the filter works correctly. The 'Duration' column has numeric values ( right-aligned ). Filtering on this column also works. However, filtering on the 'Number Called' or 'Line' columns makes all rows disappear.
Created attachment 60940 [details] Small Excel document to demonstrate filter bug
fixed in cvs HEAD.