https://bz.apache.org/ooo/show_bug.cgi?id=126718
Issue ID: 126718
Issue Type: DEFECT
Summary: Pivot table fails to aggregate boolean categories
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Linux 64-bit
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: editing
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the issue.
