Issue 91387 - Auto select for Filter Value modifies criteria
Summary: Auto select for Filter Value modifies criteria
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-07-04 17:18 UTC by steve_ooo
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

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

sample file for comments from rainerbielefeld Fri Jul 4 (6.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-07-04 18:14 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description steve_ooo 2008-07-04 17:18:22 UTC
I was playing with some CVS data and discovered an apparent flaw when trying to
filter on a computed column for rows with column H having a value of below -3...
For negative numbers I get zero filter results irrespective of the data being

To reproduce:
* New spreadsheet
A1 <= 1
A2 <= -2
A3 <= 2
* Highlight A1:A3
* Menu -> Data -> Filter -> Standard Filter
* "Column A"  "<" "-1"
* Zero results displayed - when we'd expect to see A2.

N.B. By using a formula of the form: B? <= A? + 1 - then filtering on "Column B"
"<" "0" gives the expected result... i.e. row 2 visible.  This suggests, to me,
that the bug has something to do with negative numbers entered in the dialogue.
Comment 1 Rainer Bielefeld 2008-07-04 18:13:01 UTC
Please check carefully the filter criteria in the filter dialogue while entering
it and afterwards. Can you confirm my results?

I saw with "2.4.1  Multilingual version German UI WIN XP: [680m17(Build9310)]"

1. open samplefile.ods from attachment
2. mark A1:A3
3. Menu 'Data -> Filter - Standard Filter'
   You see 'Field Name: "Column Y"',  'Condition: "="';  Value: empty
4. Modify 'Condition' to  "<"
   everything works as expected
5. Try to insert "-1" for 'Value' using the keyboard 
   expected: "-1" in 'Value'
   actual: "- not empty -" appears  immediately after you type "-" and 
           'Condition' canges back to "="!
6. Continue typing "1"
   "- not empty -" disappears, but 'Condition' remains "="
   So the complete filter criteria now is
   'Field Name: "Column Y"',  'Condition: "="';  Value: "-1"
   There is no "-1" in 'A1:A3' and so the filter works correctly if nothing
   will be shown after filtering.

If you will correct 'Condition' to "<" the filter will also work correctly and
show the expected result.

So the problem seems to be the unexpected criteria change.

I do not understand the instructions "N.B.". It would be so easy if you wohld
have contributed a sample file.

Comment 2 Rainer Bielefeld 2008-07-04 18:14:26 UTC
Created attachment 54947 [details]
sample file for comments from rainerbielefeld Fri Jul 4
Comment 3 steve_ooo 2008-07-04 19:15:11 UTC
I had not realised the criteria change... (nor did I notice "-not-empty"... as I
quickly typed "-1") I filled in the fields from top to bottom, left to right...
and didn't check back to see if previous fields had been altered.

On looking again at this, I can confirm that I'm experiencing a non-intuitive
aspect to the user interface and not the bug I thought I'd originality found.

While clearly, now, only a cosmetic issue... it is none-the-less still rather
confusing... and, I think, would benefit from being fixed to keep the values
I've entered rather than reset them.

P.S. (I hadn't realised that I could attach a file when I filled in the bug
report... though, with 3 values in 3 cells, it seemed overkill anyway.)
Comment 4 Rainer Bielefeld 2008-07-05 09:33:04 UTC
If you try to insert a negative Value into field 'Value', OOo will change
differing selections in 'Criteria' to "=" immediately after the "-" has been
inserted and the proposal "- not empty -" appears. That modification of the
criteria should wait until the 'Criteria' has been confirmed (by leaving that