[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org
   Assignee|libreoffice-b...@lists.free |felipel...@mortemale.org
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #20 from hobartpainte...@gmail.com ---
This is great, I strongly agree! 
https://www.hobartpainters.com/house-painting
https://www.wollongongbathroom.com

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #19 from Felipe Lema  ---
cross-referencing patch for this https://gerrit.libreoffice.org/c/core/+/129088

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #18 from Felipe Lema  ---
Hello there

I've changed the "yes/no ignore empty rows" bool to a "list, ignore or count"
enum in the code

However

I'm having trouble understanding where/how to count the empty rows.

I believe it should be done in `ScDpfilteredCache::fillTable(…)`, but I could
use some help understanding the tree structures there (see
https://opengrok.libreoffice.org/xref/core/sc/source/core/data/dpfilteredcache.cxx?r=f528fff9#95
)

It doesn't seem documented, so it's feels like I'm rummaging too much around
here. And it seems I get more questions than answers (Why trees? Are tree items
cells, rows? do row-col represent original data or pivoted data? is "(empty)"
added within this method?)

Anyway,a some pointer around this code would me appreciated (mayme counting
should me done elsewhere)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

Felipe Lema  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

--- Comment #17 from Felipe Lema  ---
lemme give this one a go

I'll add a "count empty cells" checkbox to the Pivot Table Layout dialog
(visually close to the "Ignore empty rows" checkbox) that defaults to "off" (to
preserve original behaviour). Let's see how it looks from there.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #16 from terrysaunders  ---
This is exactly the conditions I was facing last few months. Thanks for sharing
the bug https://www.cleaningservicesmackay.com/house-cleaning

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #15 from Valerio Bozzolan  ---
Trying to be useful I've described the use-case and the steps to reproduce also
here:

https://stackoverflow.com/questions/68019239/libreoffice-calc-and-pivot-table-with-empty-cells

It could be clearer with screenshots and bows and ribbons.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #14 from David F Smith  ---
In response to Valerio's Comment 13, please note that the Pivot Table Layout
box already has an Option checkbox "Ignore empty rows."  If that option is
checked, there is no column in the resulting pivot table headed "(empty)", but
even if the option is not checked, blank rows are not counted and not included
in the total.

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

Valerio Bozzolan  changed:

   What|Removed |Added

   Hardware|x86 (IA32)  |All
 OS|Windows (All)   |All

--- Comment #13 from Valerio Bozzolan  ---
I can reproduce on 6.4.7.2 on Ubuntu 20.04.2 LTS (Focal Fossa).

Sadly, I've seen a customer who had to abandon LibreOffice on 40 workstations
because of this bug.

An option like:


 [X] process also empty cell


Was present in another proprietary solution but not LibreOffice.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #12 from m...@neiger.org ---
Still missing in 6.2.
I vouch the request for enhancement.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #11 from David F Smith  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #10 from David F Smith  ---
This problem still exists in v5.1.2.2
under Windows 7 Professional (6.1.7601 Service Pack 1).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=47523

--- Comment #9 from David F Smith davidjudysm...@gmail.com ---
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=47523

--- Comment #8 from David F Smith davidjudysm...@gmail.com ---
For the record, this problem still exists in 4.0.4.2, tested under Windows 7
Professional (6.1.7601 Service Pack 1).

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=47523

--- Comment #7 from bugquestcon...@online.de ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=47523

Kohei Yoshida kohei.yosh...@gmail.com changed:

   What|Removed |Added

   Severity|minor   |enhancement

--- Comment #6 from Kohei Yoshida kohei.yosh...@gmail.com 2012-07-09 15:15:44 
PDT ---
Marking this as an enhancement request.

-- 
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=47523

sasha.libreoff...@gmail.com changed:

   What|Removed |Added

Summary|PIVOTTABLE: Pivot table |Functionality request for
   |doesn't count empty cells   |PIVOTTABLE: Add option for
   |in single-column data   |Pivot table will count
   |source  |empty cells in
   ||single-column data source

-- 
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=47523

sasha.libreoff...@gmail.com changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs