You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/01/22 08:47:13 UTC
[Bug 124077] New: Filter does not differentiate numeric and string
value which looks numeric
https://issues.apache.org/ooo/show_bug.cgi?id=124077
Bug ID: 124077
Issue Type: DEFECT
Summary: Filter does not differentiate numeric and string value
which looks numeric
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: nnagesh@in.ibm.com
CC: issues@openoffice.apache.org
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124077] Filter does not differentiate numeric and string value
which looks numeric
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124077
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |elish@apache.org
--- Comment #2 from Edwin Sharp <el...@apache.org> ---
Can not reproduce
AOO410m1(Build:9750) - Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124077] Filter does not differentiate numeric and string value
which looks numeric
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124077
--- Comment #4 from Nagesh <nn...@in.ibm.com> ---
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-
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124077] Filter does not differentiate numeric and string value
which looks numeric
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124077
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Latest|--- |4.1-dev
Confirmation on| |
Ever confirmed|0 |1
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124077] Filter does not differentiate numeric and string value
which looks numeric
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124077
--- Comment #1 from Nagesh <nn...@in.ibm.com> ---
Created attachment 82345
--> https://issues.apache.org/ooo/attachment.cgi?id=82345&action=edit
File showing the problem
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.