Apache OpenOffice (AOO) Bugzilla – Issue 91387
Auto select for Filter Value modifies criteria
Last modified: 2013-01-29 21:44:06 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 filtered. 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.
@steve_ooo: 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.
Created attachment 54947 [details] sample file for comments from rainerbielefeld Fri Jul 4
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.)
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 field).