https://bugs.documentfoundation.org/show_bug.cgi?id=124810
Bug ID: 124810
Summary: Formatting in pivot table saved as XLSX degrades after
refreshing table in Excel
Product: LibreOffice
Version: 6.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 112416
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 6.3.0.0.alpha0+ (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418),
6.0.0.3 / Windows 7.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX pivot table bugs
--
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
