https://bugs.documentfoundation.org/show_bug.cgi?id=150734
Bug ID: 150734
Summary: Filter to exclude empty cells on Pivot Table still
shows empty cells when deselected
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: that.man.co...@gmail.com
Description:
Not the same as Bug 108834 which claims a failure when the filter is set to
show ONLY empty cells. This is the exact opposite.
When deselecting empty values they are still shown so there is no effective way
to simply show the first level
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
Try to exclude blanks by deselecting the blanks check box in the column filter
on column 1 or 2
Actual Results:
Screen full of empty cells and every value is shown
Expected Results:
Whichever column has been selected to exclude blanks should exclude the blanks
but far more importantly it should produce a sub total for the appropriate
consolidation of column 1, 2 & 3 items. Therefore, if you date the same
companion on multiple occasions at many of the places you attend then there
should be appropriate subtotals at the day level, the venue level and the
companion level.
Of course, if you prefer to sell different groceries from different market
stalls on different days for variable sums of money you would probably still
want the same subtotals.
If I tell a PT filter to not display an empty item it means the same as in an
ordinary filtered array - I don't care what is further along the line exclude
it AND ensure the appropriate subtotals are maintained.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.5.2 (x64) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
