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

            Bug ID: 123358
           Summary: Pivot Table default setting should be Count not Sum
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
The default "Data Field" is Sum. This results in empty cells if the data are
strings. A better default would be Count. This is the default in Excel and it's
more sensible. 

Steps to Reproduce:
1. Select a data of strings
2. Insert Pivot Table
3. Drag "Available Fields" to "Data Fields"

Actual Results:
Nothing in the cells

Expected Results:
If the default were changed to count, the cells would have the count.


Reproducible: Always


User Profile Reset: No



Additional Info:
You could say it's a design issue, not so much a bug, but for me it's serious
enough that I wouldn't recommend LibreOffice Calc to my students for Pivot
Tables.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to