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: nnag...@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.
