https://bz.apache.org/ooo/show_bug.cgi?id=127550
Issue ID: 127550
Issue Type: DEFECT
Summary: Pivot table needs option to show missing values as 0
(zero)
Product: Calc
Version: 4.1.3
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Calc needs an option to show missing values as 0 (zero) in pivot tables, as
Excel does, instead of them just being empty. For example, when the data
consists of counts, it is sometimes valuable to see a 0 for a count when a
particular combination is missing.
See the discussion with example in the forum:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=90631&p=428668#p428668
--
You are receiving this mail because:
You are the assignee for the issue.