I have tried pivot table functionality out again from the software “LibreOffice Calc 6.2.4.2-821.3” (Build-ID: 20(Build:2)). * Data filters can be applied. https://help.libreoffice.org/6.2/en-US/text/scalc/guide/datapilot_filtertable.html * Items can be hidden individually. https://help.libreoffice.org/6.2/en-US/text/scalc/01/12090106.html I would appreciate clearer indications for these data exclusions. Can their adjustment become also more convenient?
Markus can you give more detail info about your suggest?
(In reply to Roman Kuznetsov from comment #1) * How often would you like to see in the graphical user interface that filtered data are presented by a specific pivot table? * Can the display of filter criteria be helpful besides the computation report?
Changing to Documentation
Reported was not referring to docs, but UI, so switching component back to Calc
Created attachment 153496 [details] Test scenario True, there is no indicator on filtered data (in the example I set value>0). User expectation is probably to have the same look and feel (as well as workflow) as known from (auto-)filtering spreadsheet data. As a more simple solution we could introduce a colored triangle on top-right of the cell as feedback.
Excel adds a tiny little dot to the autofilter funnel symbol if a filter is active. Don't see any standard/advanced filter. WPS works more or less the same but has a nice feedback with blue font for the rows (1..n) if those are included by the filter. Don't get how the advanced filter should work, looks similar to Gnumeric. Let's pick up this idea. If a filter is active, we draw the respective rows in blue. Would be 2..4 in the example.
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@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 [details]) 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.