[Libreoffice-bugs] [Bug 124810] New: Formatting in pivot table saved as XLSX degrades after refreshing table in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: mikekaganski at hotmail.com
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190418/4a080b5b/attachment.html>