https://bugs.documentfoundation.org/show_bug.cgi?id=96241
Bug ID: 96241
Summary: Pivot table fails to aggregate boolean categories
Product: LibreOffice
Version: 4.4.6.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Copied from AOO bugzilla https://bz.apache.org/ooo/show_bug.cgi?id=126718
Forum topic: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=80635
The attached spreadsheet tries to resolve the problem by appending a calculated
field =ISBLANK($C2) to the source table.
The only the FALSE values are reflected in the pivot table.
Surprisingly, turning the boolean into a text field with 2 categories
=IF(ISBLANK($C2);"Yes";"No") makes no difference. Only the "No" values will
aggregate.
Conversion of formulas to two constant values makes no difference.
The aggragation works when there are more than two different values.
The attached file contains a source table, a wanted result and a pivot sheet
with 2 pivots, one where the aggregation of a boolean field fails and another
one where the aggregation of 3 values works.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
