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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
