Issue 124077 - Filter does not differentiate numeric and string value which looks numeric
Summary: Filter does not differentiate numeric and string value which looks numeric
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.0.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-22 07:47 UTC by Nagesh
Modified: 2014-01-23 12:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Attachments
File showing the problem (7.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-22 07:48 UTC, Nagesh
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Nagesh 2014-01-22 07:47:13 UTC
I have a column "Code" which has the values 1,2,4,3,"2+","2-","1+","1-" and similar. the values in quotes are entered as a string like '2+ ..When I have autofilter for this column when I try to filter for say 1 ... it shows rows with 1 as well as "1+" (note it does not show "1-") similarly if I filter for 2 if shows rows with 2 and "2+" (note it does not show "2-") However if I filter for "2+" or "1+" or "1-" or "2-" the filter behaves correctly. I think Calc is treating "2+" as a numeric and converts to 2.
This behavior is not seen in other Spreadsheet applications.
Comment 1 Nagesh 2014-01-22 07:48:29 UTC
Created attachment 82345 [details]
File showing the problem
Comment 2 Edwin Sharp 2014-01-22 08:30:22 UTC
Can not reproduce
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian
Comment 3 Edwin Sharp 2014-01-23 11:15:49 UTC
Filter     Result
1          1 1 
2          2
3          3
1+         1 1 1+
2+         2 2+
3+         3 3+
2-         2-
1-         1-  

AOO410m1(Build:9750)  -  Rev. 1560574
Rev.1560574
Win 7
Comment 4 Nagesh 2014-01-23 12:14:59 UTC
Thanks Edwin, I see your comment I too get it that way... but shouldn't the correct result be as follows.... because the value "2+" is different from "2" as "2-" is again different... 

Filter     Result
1          1 1 
2          2
3          3
1+         1+
2+         2+
3+         3+
2-         2-
1-         1-