https://bugs.documentfoundation.org/show_bug.cgi?id=56187
oli <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
--- Comment #10 from oli <[email protected]> ---
Bug is still present at
Version: 6.1.1.2 (x64)
Build-ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
CPU-Threads: 8; BS: Windows 6.1; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: group threaded
Today's test results:
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)
click <cancel>
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)
click <ok>
Zeile Wert_1 Wert_2
(no more lines (2-13) are shown at all!!!)
(this is wrong!)
* click Wert_1 / AF and look at the checkboxes
there are no values / checkboxes but <all> which is checked
click <Standard Filter...>
Wert_2 = b
AND Wert_2 = c
AND Wert_2 = b
AND Wert_2 = c
AND Wert_1 = 1
(all <OR>-lines from the SF that we have entered above are missing, and the
first line has moved to the end
(this is wrong!)
--- end of test ---
So sorry to say that SF and AF is still buggy
**********************************************************************
**********************************************************************
--- further test on old version ---
LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
There are no checkboxes in AF-window, thus only one value per row can be
selected as creteria for AF.
Therefore AF -> SF gives only <AND>-junctions between different rows. This
works fine.
SF itself works fine with <AND> and <OR>, and there is no need to translate SF
back to AF (as there are no checkboxes in AF).
--> added 'regression' to keywords
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
