GNOME Bugzilla – Bug 383400
autofilter : equality comparisons between number and number as string
Last modified: 2011-09-30 19:23:50 UTC
Please describe the problem: The autofilter seems to work incorrect in attached sheet (can't reproduce with simple data). Steps to reproduce: 1. Select autofilter in B4 2. Select 'Other' 3. Select 'equal' '6a' for 1st entry 4. Select 'OR' 5. Select 'equal' '95' for 2nd entry Actual results: Only the rows with '6a' are shown. Expected results: The rows with '6a' and the rows with '95' must be shown. Does this happen every time? It happens with this sheet. Quick attempts to check with numbers and numbers/strings mix didn't expose the problem. Other information:
Created attachment 77897 [details] incorrect autofilter example gnumeric version 1.7.5. I tried to open this file in 1.6.1 with 'Incorect expression' dialogs and same (incorrect) behavior.
Confirmed. I also get this on load: ** (gnumeric:14089): WARNING **: too lazy to support nested unshared content for now. We'll add it for 2.0 ** (gnumeric:14089): WARNING **: Invalid attribute 'ValueType0', expected integer, received '6a' ** (gnumeric:14089): WARNING **: value_new_from_string problem.
The problem is that... xml-io.c and xml-sax-write.c interchanges the Value0 and ValueType0 attribute names. xml-sax-read.c does not. Hence the dom parser can read what it wrote and what the sax writer currently writes. But the sax reader cannot.
warnings are fixed. There were a few problems. The initial problem still exists. Gnumeric compares the string '95' to the number 95 and sees them as unequal
Bump the priority to bring this up the queue.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.