https://bugs.documentfoundation.org/show_bug.cgi?id=105254
Bug ID: 105254
Summary: Pivot table Filter field is lost if saved in Microsoft
2007-2013 XML file format, but if saved from ODF then
whole pivot table is lost
Product: LibreOffice
Version: 5.2.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Test 1 - Pivot table Filter problem
1. Open LibreOffice Calc.
2. In fields type in:
A1: Name
A2: Alice
A3: Bob
A4: Connie
B1: Size
B2: 170
B3: 180
B4: 160
3. Select fields from A1:B4.
4. Tools | Pivot Data | Pivot Data.
5. On "Select Source" leave default and click on OK button.
6. "Pivot Table Layout" dialog opens. From "Available Fields" drag Name field
to "Rows Fields".
7. From "Available Fields" drag Size field to "Data Fields" and click on OK
button.
8. Right mouse click somewhere on displayed pivot table and select Filter.
9. Filter dialog opens. In first drop-down row select "Field name" to Name,
Condition select "=" and Value select Alice.
10. File | Save and select "Save as type": "Microsoft Excel 2007-2013 XML"
format and confirm.
11. Close document.
12. Open saved document. Problem appears. Filter (step 8) is lost.
Test 2 - Works fine
13. In opened document add filter (step 8).
14. File | Save a Copy and select data type "ODF Spreadsheet".
15. Close all files.
16. Open from step 13 saved document and filter is preserved. Works as
expected.
Test 3 - Pivot table is lost
17. File | Save a Copy and save file to "Microsoft Excel 207-2013 XML" format.
18. Close all files.
19. Open in step 14 saved document.
20. Pivot table is lost. Instead of pivot table ordinary table data are
displayed.
Tested on Windows 7 SP1.
==== Help | About ================
Version: 5.2.4.2
Build ID: 3d5603e1122f0f102b62521720ab13a38a4e0eb0
CPU Threads: 3; OS Version: Windows 6.1; UI Render: default;
Locale: sl-SI (sl_SI); Calc: group
==================================
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
