[Libreoffice-bugs] [Bug 138493] New: Wrong value in Pivot for a table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138493

            Bug ID: 138493
           Summary: Wrong value in Pivot for a table
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Roland.Dietz at gmx.de

Description:
I have a table with 11 columns. And I calculate a pivot table where one line is
obviously wrong and I found out what happens.
As fields for the lines I use a column called "Category" and as datafield I use
the sum of a column called "price".

There are two lines in my table one with category let's say 'X' and one with an
empty value in the column category. In this case the price for the line with
category field empty is counted in pivot to the category 'X'.

Actual Results:
see description

Expected Results:
Empty fields should be added to another pivot sum.


Reproducible: Always


User Profile Reset: No



Additional Info:
see description

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201125/04f5ec97/attachment.htm>