Bug 40688 - Datapilot Filter function do not work if page field is selected
Summary: Datapilot Filter function do not work if page field is selected
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-07 05:56 UTC by andis.lazdins
Modified: 2012-08-31 10:06 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Sample file demonstrating bug (34.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-07 05:56 UTC, andis.lazdins
Details

Note You need to log in before you can comment on or make changes to this bug.
Description andis.lazdins 2011-09-07 05:56:14 UTC
Created attachment 50960 [details]
Sample file demonstrating bug

If I have pivot table containing filter and page fields filter, like in example, when I chose "Priede" in "suga" field, data pilot calculates sum of all fields (M3+ha) in spite I set filter that only values having "ha" in "mērv." column should be calculated. If I set additional page field rule for "mērv." and select there "ha", calculation is done correctly. 

If I set show all in page field filter "suga" keeping at the same time "ha" value in "mērv." page field and data pilot filter rule to select only values having "ha" in "mērv." column, calculation is done correctly.

It seems that the problem appears in case if filter rules and page field runes represents different columns. The bug seems to be Libreoffice 3.3.4 specific, because I didn't find it in earlier versions, but it was in 3.4 branch.

This bug is relevant to the one recently solved in Libreoffice 3.4 branch: https://bugs.freedesktop.org/show_bug.cgi?id=35981
Comment 1 andis.lazdins 2011-12-10 10:31:23 UTC
This bug is solved in 3.5 beta (Ubuntu 11.10)
Comment 2 Björn Michaelsen 2011-12-23 12:36:28 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 3 Florian Reisinger 2012-08-14 14:02:56 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 4 Florian Reisinger 2012-08-14 14:03:51 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 5 Florian Reisinger 2012-08-14 14:08:25 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 6 Florian Reisinger 2012-08-14 14:10:28 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian