<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Filtering a pivot table group field may hide all group fields, including the filtered one"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124629">124629</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Filtering a pivot table group field may hide all group fields, including the filtered one
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.6.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mikekaganski@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=150630" name="attach_150630" title="A sample pivot table with multiple group fields">attachment 150630</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150630&action=edit" title="A sample pivot table with multiple group fields">[details]</a></span>
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).</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>