[Libreoffice-bugs] [Bug 40688] New: Datapilot Filter function do not work if page field is selected

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Sep 7 05:56:16 PDT 2011


https://bugs.freedesktop.org/show_bug.cgi?id=40688

           Summary: Datapilot Filter function do not work if page field is
                    selected
           Product: LibreOffice
           Version: LibO 3.3.4 release
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: andis.lazdins at gmail.com


Created an attachment (id=50960)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=50960)
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

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.


More information about the Libreoffice-bugs mailing list