[Libreoffice-bugs] [Bug 47523] Functionality request for PIVOTTABLE: Add option for Pivot table will count empty cells in single-column data source
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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