[Libreoffice-bugs] [Bug 125857] Improve indications for excluded data in a pivot table

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Jun 19 14:23:01 UTC 2021


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

--- Comment #7 from stragu <stephane.guillou at member.fsf.org> ---
Reproduced in:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 94d552f94b427f884c004dba5d4619ecf729d605
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2021-06-18_13:30:27
Calc: threaded

Steps to reproduce from scratch:

1. create a table with a categorical column and a numerical column (like Sheet
1 of the attachment 153496)
2. create a pivot table from that range, using the categorical column as the
"Row Fields" and the sum of the numerical for the "Data Fields".
3. Right-click on a cell of the Value column of the pivot table, click
"Filter..."
4. Setup a filter to not take some of the source data into consideration (e.g.
"Values > 0"); click OK.

Result: the results in the pivot table do update, but there is no sign of a
filter being present.
This is very misleading for someone who does not know how the spreadsheet was
set us.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210619/a59d1f2e/attachment.htm>


More information about the Libreoffice-bugs mailing list