Bug 124810 - Formatting in pivot table saved as XLSX degrades after refreshing table in Excel
Summary: Formatting in pivot table saved as XLSX degrades after refreshing table in Excel
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Mike Kaganski
Whiteboard: target:6.3.0
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
Reported: 2019-04-18 04:53 UTC by Aron Budea
Modified: 2019-04-20 19:40 UTC (History)
1 user (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 Aron Budea 2019-04-18 04:53:30 UTC
Description taken from bug 124772, which dealt with part of the issue (number formats, removed from the list below).

The samples are two similar pivot tables, one created in Excel (bug 123421), and another in Calc (bug 108343).

- Open Calc-created attachment 149245 [details] (bug 123421) and save it as XLSX, or Excel-created attachment 133861 [details] (bug 108343) and save it again as XLSX.
- Open in Excel (the first sample needs bug 123421's fix to work), right-click table and choose Refresh.

=> Note the following:
- the borders fade,
- the grey background of the fields (Country, Product) disappears (already upon import).

A potential fix idea is to round-trip the "pivotTableStyleInfo" element in a grab-bag, and in Calc-created pivot tables export one with Excel's default "PivotStyleLight16" style.

Observed using LO (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418), / Windows 7.
Comment 1 Mike Kaganski 2019-04-18 13:01:43 UTC
Comment 2 Commit Notification 2019-04-20 05:15:59 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":


tdf#124810: Roundtrip pivot table style info from XLSX.

It will be available in 6.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.