Bug 124881 - In XLSX pivot table exported from LO, data field name disappears after refresh in Excel
Summary: In XLSX pivot table exported from LO, data field name disappears after refres...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Mike Kaganski
Whiteboard: target:6.3.0
Keywords: bibisectNotNeeded, regression
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
Reported: 2019-04-22 09:00 UTC by Mike Kaganski
Modified: 2019-04-22 12:15 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 Mike Kaganski 2019-04-22 09:00:49 UTC
Open attachment 133861 [details] from bug 108343 in current master (after [1]); save it as XLSX again; open the result in Excel (note that Sheet2!B3 has "Sum - Amount"); refresh the pivot table in Excel.
This removes the text from Sheet2!B3, leaving the cell empty. Also the name of the field in "Values" area of PivotTable Fields sidebar is empty.

This is the regression from the mentioned commit for bug 124651, which was Excel 2016-specific.

[1] https://git.libreoffice.org/core/+/1a28b0a602bb3c10f75c3c6408cf9bc555020d34
Comment 1 Mike Kaganski 2019-04-22 09:19:46 UTC
Comment 2 Commit Notification 2019-04-22 10:14:44 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":


tdf#124881: Provide a non-empty name for pivot table's data field

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.