[Libreoffice-bugs] [Bug 124629] New: Filtering a pivot table group field may hide all group fields, including the filtered one

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124629
           Summary: Filtering a pivot table group field may hide all group
                    fields, including the filtered one
           Product: LibreOffice
           Version: 3.6.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 150630
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150630&action=edit
A sample pivot table with multiple group fields

Open the attached file, and filter any group field (Years, Quarters, ... , Fix
date) to exclude everything but ">25.03.2021" or "<25.03.2019" (">12.10.2022"
or "<20.09.2022" for last two groups).

When the filtering is confirmed, all the data gets hidden from the table, and
the pivot table naturally gets empty; but also all the group fields but the
first one get hidden, too. If one had filtered some group field other than the
first one, this filtered field would get hidden, too, making it impossible to
easily change the filter back.

It is currently impossible to use "Undo" to revert the action: while the data
gets displayed after Undo, the filter is inaccessible (seems like an unrelated
bug); but even if Undo worked, it is not always possible to use it: e.g., pivot
table could turn into that state because of pre-existing filtering, which used
to provide some data for the table; but after changing data in the source, and
refreshing (possibly after saving and reloading), the new source does not
provide any data for the table. It's impossible to undo a pivot table refresh;
and closing unsaved could loose the work done thus far in this editing session.

There is an obscure way to fix the table, though: one needs to change the table
layout to make filtered field the first one.

The behavior is very inconvenient, and also inconsistent e.g. with Excel, where
all the fields are shown even when no data is displayed in the table.

This is reproducible since version 3.6 (older versions would crash when
filtering attempted).

-- 
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/20190409/1f6870b7/attachment-0001.html>