Download it now!
Bug 125086 - Export XLSX: Pivot table with a field present both in Row Fields and Data Fields produces warnings in Excel
Summary: Export XLSX: Pivot table with a field present both in Row Fields and Data Fie...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Mike Kaganski
URL:
Whiteboard: target:6.3.0
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-05-02 15:50 UTC by Mike Kaganski
Modified: 2019-05-02 18:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A pivot table with a field both in Row Fields and Data Fields (9.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-02 15:50 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2019-05-02 15:50:36 UTC
Created attachment 151134 [details]
A pivot table with a field both in Row Fields and Data Fields

Saving attachment as XLSX, and opening in Excel, produces a warning, after which the pivot table gets repaired.

Tested with master (in 6.2.3.2, the table gets removed after the warning).
Comment 1 Mike Kaganski 2019-05-02 17:03:14 UTC
https://gerrit.libreoffice.org/71687
Comment 2 Commit Notification 2019-05-02 17:49:58 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/31297f32aa9a35897055b0d377af332a4bb977a1%5E%21

tdf#125086: Write dataField attribute for fields that also appear in Data

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:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.