Summary: | Filter to exclude empty cells on Pivot Table still shows empty cells when deselected | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | ilmari.lauhakangas, xiscofauli |
Priority: | medium | ||
Version: | 7.3.5.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103381 | ||
Attachments: |
Screen Dump
Sample pivot table |
Description
Colin
2022-08-31 20:34:40 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) Created attachment 182472 [details]
Screen Dump
As can be seen, the filter to exclude all blanks had been activated but all the blank lines in that column are still visible.
I would expect it to collapse all the blank rows in that column and produce sub-totals as appropriate - just like a pivot table would.
In this guise, it's more like an inferior Autofiltered array without the benefit of SUBTOTAL() to include or exclude values in the "hidden" rows.
A pivot table should of course consolidate the values into subtotals at the appropriate levels of collapse.
(In reply to Colin from comment #0) > Steps to Reproduce: > Create a data table with perhaps four columns > Column 1 is a name - ensure you have more than one name > Column 2 is a category - ensure you have more than one category > Column 3 is a date - ensure you have a busy diary > Column 4 is a sum of money - ensure you spend loads of dough on your date ;) > Perhaps even get a refund so there are some credits as well as debits > Create the pivot table with columns 1, 2 & 3 as the Row Fields: entries and > column 4 as the Data Fields: summed entry. > > Ensure your PT display includes blank spaces in columns 1 & 2 Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document. Created attachment 185088 [details]
Sample pivot table
Try to exclude the EMPTIES with the filter on column 1 "Name"
Observe that nothing changes all the empties are still producing values in columns 2,3 & 4
Exclude or re-include any of the other Names in column 1 and observe how the other columns respond approriately.
I would expect a subtotal anywhere there are groups say "tender" or "Juicy"
Hello Colin, Thank you for reporting the bug. I can confirm that the bug is present in master. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d9031bd83ffe718a80da9ecbdbeb485e35fbabee CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded |