[Libreoffice-bugs] [Bug 56187] Standard Filter gets wrong criteria from Autofilter and vice versa

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=56187

--- Comment #13 from oli <oliver.mager at gmx.net> ---
Tested with 
Version: 6.3.2.2 (x64)
Build-ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU-Threads: 8; BS: Windows 6.1; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE

---------------------------------   
today's results: SF -> AF i.o.
                 AF -> SF n.i.o.
---------------------------------

Terms: 
- Autofilter (AF)
- Standard Filter (SF)

Please do the following:

* load Test.ODS:

Zeile   Wert_1  Wert_2
1       1       a
2       1       b
3       1       c
4       2       a
5       2       b
6       2       c
7       3       a
8       3       b
9       3       c
10      4       a
11      4       b
12      4       c

* click Wert_1 / AF ; unmark [3] and [4] ; click <ok>

Zeile   Wert_1  Wert_2
1       1       a
2       1       b
3       1       c
4       2       a
5       2       b
6       2       c
(this is ok)

* click Wert_1 / AF ; click <Standard Filter ...> and look at the creteria:
   Wert_1 = 1
only the first creteria from AF is passed to SF 

It should read:
   Wert_1 = 1
OR Wert_1 = 2

the second line is missing ;

  click <Cancel>

Zeile   Wert_1  Wert_2
1       1       a
2       1       b
3       1       c
4       2       a
5       2       b
6       2       c

* click Wert_2 / AF ; unmark [a] ; click <ok>

Zeile   Wert_1  Wert_2
2       1       b
3       1       c
5       2       b
6       2       c
(this is ok)

* click Wert_2 / AF ; click <Standard Filter ...> and look at the creteria:
    Wert_1 = 1
AND Wert_2 = b

only the first AF-creteria from each column is passed to SF
OR-Creteria and brackets!!! are not considered about.
So this should read without brackets

    Wert_1 = 1
AND Wert_2 = b
OR  Wert_1 = 1
AND Wert_2 = c
OR  Wert_1 = 2
AND Wert_2 = b
OR  Wert_1 = 2
AND Wert_2 = c

[maybe somebody can think about introducing brackets, then we would get:
(Wert_1 = 1 OR Wert_1 = 2) AND (Wert_2 = b OR Wert_2 = c)   ] 

  add missing lines to SF ; click <ok>

Zeile   Wert_1  Wert_2
2       1       b
3       1       c
5       2       b
6       2       c
(this is ok)

* click Wert_1 / AF and look at the checkboxes
[1] and [2] is checked
(this is ok now)

  click <ok> 

Zeile   Wert_1  Wert_2
2       1       b
3       1       c
5       2       b
6       2       c

* click Wert_2 / AF and look at the checkboxes
[b] and [c] is checked
(this is ok now)

  click <ok>

--- end of test ---

please check filter Syntax and AF->SF
thank you!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191027/632f457e/attachment.html>