Bug 36771 - [Datapilot] Wrong filtering with both "page filter" and "field filter"
Summary: [Datapilot] Wrong filtering with both "page filter" and "field filter"
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.0 Beta3
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.4
Keywords:
: 37006 38407 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-05-02 07:22 UTC by GerardF
Modified: 2011-06-17 11:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description GerardF 2011-05-02 07:22:15 UTC 
4 columns : date, cat, in and out
4 rows : 4 financial ops (each at a different date)
Data pilot :
Filter by date
Page field : cat
Results : In (Sum) , Out (Sum)

1st check :
Filter : none, Cat : all
Right results : Out = 20 ; In = 2

2nd check :
Filter : date > 01/01/10 AND date <= 01/002/11 , Cat : all
Right results : Out = 10 ; In = /

3rd check :
Filter : date > 01/01/10 AND date <= 01/002/11 , Cat : A
Wrong results : Out = 20 ; In = /
e.g. filter is not filtering anymore.

This bug appears with LibreOffice 3.3.x and OOo 3.3 
He is still in LibO 3.4 Beta 3 but is tagged Fixed for OOo 3.4

Link for the OOo issue : http://openoffice.org/bugzilla/show_bug.cgi?id=117661
There is an attachment with this issue.

Kohei, i think it's for you.
Comment 1 Kohei Yoshida 2011-05-02 22:58:10 UTC 
Just fixed this one in the 3.4 branch.
Comment 2 GerardF 2011-05-09 08:04:10 UTC 
*** Bug 37006 has been marked as a duplicate of this bug. ***
Comment 3 GerardF 2011-06-17 11:57:50 UTC 
*** Bug 38407 has been marked as a duplicate of this bug. ***