https://bugs.documentfoundation.org/show_bug.cgi?id=91412
Bug ID: 91412
Summary: Pivot table filters reset to first column after file
save/reopen
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs