[Libreoffice-bugs] [Bug 124883] New: Calc should correctly import and roundtrip data field names as defined in XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124883

            Bug ID: 124883
           Summary: Calc should correctly import and roundtrip data field
                    names as defined in XLSX
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Something like a follow-up of bug 124881.

1. Open attachment 133861 from bug 108343 in Excel;
2. Change the name of the Data field (Values area in PivotTable Fields sidebar)
from "Sum of Amount" to, say, "FooBar";
3. Save it in Excel;
4. Open it in current LO master;
5. Save as XLSX again;
6. Re-open in Excel.

The data field in the original XLSX is initially named "Sum of Amount" (default
name automatically assigned by Excel on creation), changed to user-defined
"FooBar". When imported to Calc, it's shown as "Sum - Amount". Prior to [1],
Calc didn't export anything as the field's name; which allowed Excel (older
than 2016) to re-construct the name *as default "Sum of Amount"*. After the
said commit, Calc started to export empty string, forcing the name to be empty.
With [2], it now exports a name *as generated by Calc*.

The problem is, Calc should read, use, and export the name as defined in
original XLSX.

[1] https://git.libreoffice.org/core/+/1a28b0a602bb3c10f75c3c6408cf9bc555020d34
[2] https://git.libreoffice.org/core/+/e913727c7ee3af0bb4031c6829abfb3373306492

-- 
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/20190422/ab137246/attachment.html>