Bug Hunting Session
Bug 47523 - Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source
Summary: Functionality request for PIVOTTABLE: Add option for Pivot table will count e...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.5 release
Hardware: x86 (IA32) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2012-03-19 09:27 UTC by David F Smith
Modified: 2019-09-01 12:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
As requested: spreadsheet with data (containing some empty cells) and resulting pivot table. (8.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-13 05:18 UTC, David F Smith
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David F Smith 2012-03-19 09:27:18 UTC
I want to use a pivot table to count responses to a survey question, but it ignores blank cells in the answer column.  To see the behavior:
1. Enter the following data in a column
   Answer
   Yes
   Yes
   No

   Yes
   No


   No
   Yes
   (That's 4 Yes, 3 No, and 3 blank cells in the column titled Answer.)
2. Select all 11 cells and choose Data | Pivot Table | Create.  "Current
   selection" should be selected.  Click OK.
3. Drag the Answer button to Column Fields and to Data Fields.
4. Click Options, change the function to Count, and click OK.
5. Click OK to create the pivot table.

The resulting table looks like this:
(empty)  No     Yes    Total Result
           3      4       7
The three empty cells have not been counted.

Apologies in advance if I have misunderstood what "empty" means.

(I also submitted this a couple of years ago for OpenOffice.)
Comment 1 David F Smith 2012-05-01 16:41:44 UTC
This issue has not been addressed in more than a month.  Is there any information that I can add?
Comment 2 sasha.libreoffice 2012-06-13 02:05:51 UTC
Thanks for bugreport
Please, attach document produced in description for testing
Comment 3 David F Smith 2012-06-13 05:18:35 UTC
Created attachment 62961 [details]
As requested: spreadsheet with data (containing some empty cells) and resulting pivot table.
Comment 4 sasha.libreoffice 2012-06-14 23:51:48 UTC
Thanks for attachment
Using attachment, reproduced in 3.3.4, 3.5.4 and msExcel 2007
in all cases used right mouse click->Refresh

IMHO it done so for compatibility with Excel. Therefore NOT A BUG

But, may be possible to add some option elsewhere for counting empty cells too
Comment 5 Joel Madero 2012-07-02 21:34:54 UTC
This is a bug. It should definitely count blank cells. I'm marking this as a MINOR bug with LOW priority as I don't think many people are affected but for those who are, correcting it means not using the pivot table or taking extra steps to count blanks. Thanks for reporting this.
Comment 6 Kohei Yoshida 2012-07-09 15:15:44 UTC
Marking this as an enhancement request.
Comment 7 bugquestcontri 2013-05-11 06:26:43 UTC
I wonder why bugs are sometimes marked as "enhancement". IMHO a "bug" is a fault in a current functionality already built into LibO. An "enhancement" is a further improvement of something which is already working but it can be made better. 

Not counting of blanks is IMHO a bug because a pivot table should be able to count blanks.

This very bug might not be important for many users, some might be able to create a work around, but for some it could be show stopper of using LibO.

There is currently again a related question in AskLibO: 
http://ask.libreoffice.org/en/question/17316/pivot-table-empty-line-field/?answer=17341#post-id-17341
Comment 8 David F Smith 2013-07-18 16:16:27 UTC
For the record, this problem still exists in 4.0.4.2, tested under Windows 7 Professional (6.1.7601 Service Pack 1).
Comment 9 David F Smith 2015-03-12 04:00:42 UTC
For the record, this problem still exists in Version 4.4.1.2
(Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432)
under Windows 7 Professional (6.1.7601 Service Pack 1).
Comment 10 David F Smith 2016-04-23 03:31:58 UTC
This problem still exists in v5.1.2.2
under Windows 7 Professional (6.1.7601 Service Pack 1).
Comment 11 David F Smith 2016-09-29 16:23:32 UTC
For what it's worth, I have retested this with version 5.2.2.2
(Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad)
under Windows 10 (version 10.0.10586)
and it still fails.

The user interface for creating a pivot table has changed (under Insert rather than Data, and different selection of the data function), but the result is the same: empty cells are not counted.
Comment 12 marc 2019-05-01 10:49:27 UTC
Still missing in 6.2.
I vouch the request for enhancement.