1. Open LibreOffice Calc 2. Create the following 2-column spreadsheet: headerA,headerB value1, value2,b 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 Expected: @11: No change to displayed pivot table @12: Pivot filter remains as it was before Results: @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.
Hello, 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. http://www.libreoffice.org/download/
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.
Maybe a duplicate of: https://bugs.documentfoundation.org/show_bug.cgi?id=73845
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 ***