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