https://bugs.freedesktop.org/show_bug.cgi?id=47523
Bug #: 47523
Summary: PIVOTTABLE: Pivot table doesn't count empty cells in
single-column data source
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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.)
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
