Bug 91412 - Pivot table filters reset to first column after file save/reopen
Summary: Pivot table filters reset to first column after file save/reopen
Status: RESOLVED DUPLICATE of bug 73845
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2015-05-20 15:23 UTC by John Nelson
Modified: 2015-05-22 07:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description John Nelson 2015-05-20 15:23:58 UTC
1. Open LibreOffice Calc
2. Create the following 2-column spreadsheet:
3. Select range A1:B3
4. Navigate the menus to Data -> Pivot Table -> Create, click Okay
5. Drag headerA from Available fields to Row fields
6. Expand "Source and Destination", and send to D1
7. Right-click on the new pivot table, and select Filter
8. Create any filter at all based on headerB
9. Save the document, and close out of LibreOffice
10. Re-open the saved document
11. Right-click on the pivot table, and select Refresh

 @11: No change to displayed pivot table
 @12: Pivot filter remains as it was before

 @11: Pivot table changes as though the filter was on headerA, rather than B
 @12: Filter shows headerA rather than headerB

It looks like the column to which any rule applies is ALWAYS reset to the first one after saving and re-opening, although other filter details appear to remain as they were previously.
Comment 1 raal 2015-05-20 17:17:53 UTC
I can not reproduce with 4.3.7, linux. Setting bug as worksforme, set as unconfirmed again if problem still occurs in newer version. Thank you.

Comment 2 John Nelson 2015-05-20 21:33:08 UTC
Looks like I overgeneralized step 8; here is a revised version:
 8. Create a filter based on headerB either existing, or not existing.
    NOTE: (in-)equality relational tests don't seem to cause the issue.

I have also repro'd this (with minor UI-only adjustments) on both Linux and Windows.
Comment 3 m_a_riosv 2015-05-20 23:01:41 UTC
Maybe a duplicate of:
Comment 4 raal 2015-05-22 07:54:27 UTC
I can reproduce now, and yes really looks like duplicate of bug 73845. Setting as duplicate of bug 73845

*** This bug has been marked as a duplicate of bug 73845 ***