Issue 127550 - Pivot table needs option to show missing values as 0 (zero)
Summary: Pivot table needs option to show missing values as 0 (zero)
Status: CLOSED DUPLICATE of issue 32308
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.3
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-06 22:20 UTC by eponymous
Modified: 2017-10-09 21:18 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eponymous 2017-10-06 22:20:30 UTC 
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
Comment 1 oooforum (fr) 2017-10-09 08:42:00 UTC 

Already reported

*** This issue has been marked as a duplicate of issue 32308 ***