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 2012/06/25 07:30:37 UTC
[Bug 120076] New: [From Symphony]2+ and 2 will be filter out at the
same time
https://issues.apache.org/ooo/show_bug.cgi?id=120076
Priority: P3
Bug ID: 120076
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony]2+ and 2 will be filter out at the same
time
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: yanji.yj@gmail.com
Hardware: All
Status: CONFIRMED
Version: AOO340
Component: editing
Product: spreadsheet
Created attachment 78454
--> https://issues.apache.org/ooo/attachment.cgi?id=78454&action=edit
sample
Build: AOO 3.4
Steps:
1. Open attached sample file
2. Filter out numerical 2
Defect: string "2+" is also shown
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
zhaoshzh <ao...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #78456| |review?
Flags| |
--- Comment #2 from zhaoshzh <ao...@gmail.com> ---
Created attachment 78456
--> https://issues.apache.org/ooo/attachment.cgi?id=78456&action=edit
make the “2+”、“2-” as a string
Root cause:AOO does not make the "2+"/"2-" as a string when filter data in a
column.
Resolve method:
If the condition is a number followed by '+'/'-',then make is as a string.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #8 from zhaoshzh <ao...@gmail.com> ---
No matter what you may do,should think what is the result that the user want to
get. In this sample, if user select "2+",the result should only be the items of
"2+", not other items.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
Andre <af...@a-w-f.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |af@a-w-f.de
--- Comment #3 from Andre <af...@a-w-f.de> ---
The patch works as described but I am not yet convinced that there is a problem
that has to be solved.
2+ does not look like a number (to me it looks like a German school grade), so
why should it be treated like one?
Also, the drop down box of the "filter" button has two different entries for
"2" and "2+". If they are treated differently there then why treat them
differently in the cells below?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #9 from Andre <af...@a-w-f.de> ---
That is basically my point. If you select "2+" in the filter then only "2+"
rows should be displayed. And if you select "2" as filter string then only "2"
rows should be displayed. Unless all rows that contain the filter string
should match.
So the important question (I am not a Calc expert and can not answer it myself)
is whether the filter matches rows that are
a) equal to or
b) contain
the filter string.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #5 from zhaoshzh <ao...@gmail.com> ---
and if you open the sample document,the cell type in "2+" is string ,not
number.
so "2+" must be made as a string when do filter function.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #4 from zhaoshzh <ao...@gmail.com> ---
I am confused by Andre's comment.
In the opinion,if the cells contains such string "2+","2-",and "2".
if user selects "2" in the data filter, the filter result should be
all of them ("2","2+","2-")?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #7 from Regina Henschel <rb...@t-online.de> ---
I see an error the other way round. If you select item 2+ from the filter, it
will match rows too, that have the number 2.
I see the error only with entry 2+ not with entry 2-
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #10 from zhaoshzh <ao...@gmail.com> ---
the answer is
a) equal to
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
zhaoshzh <ao...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |aoo.zhaoshzh@gmail.com
--- Comment #1 from zhaoshzh <ao...@gmail.com> ---
I am investigating this issue.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120076] [From Symphony]2+ and 2 will be filter out at the same
time
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120076
--- Comment #6 from Andre <af...@a-w-f.de> ---
I am still not convinced that a filter pattern "2" should match strings like
"2+" and "2-". Unless it is treated as a substring match. In that case it
should also match strings like "this contains a 2" or "2&&1". Why have special
handling of "2+" and "2-" but nothing else?
--
You are receiving this mail because:
You are the assignee for the bug.