<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Standard Filter gets wrong criteria from Autofilter and vice versa"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=56187#c13">Comment # 13</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Standard Filter gets wrong criteria from Autofilter and vice versa"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=56187">bug 56187</a>
from <span class="vcard"><a class="email" href="mailto:oliver.mager@gmx.net" title="oli <oliver.mager@gmx.net>"> <span class="fn">oli</span></a>
</span></b>
<pre>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!</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>