Download it now!
Bug 125046 - Exporting to XLSX a pivot table based on a field having long text elements produces warnings and repairs when opened in Excel
Summary: Exporting to XLSX a pivot table based on a field having long text elements pr...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Mike Kaganski
URL:
Whiteboard: target:6.3.0
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: XLSX-Corrupted Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-04-30 13:25 UTC by Mike Kaganski
Modified: 2019-04-30 15:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A pivot table referencing a cell with a long text string (12.73 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-30 13:25 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-04-30 13:25:42 UTC
Created attachment 151093 [details]
A pivot table referencing a cell with a long text string

Saving the attachment to XLSX and reopening with Excel gives warning about "a problem with some content", then "Repaired Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)".
Comment 1 Roman Kuznetsov 2019-04-30 13:30:27 UTC
repro in

Version: 6.3.0.0.alpha0+
Build ID: 7334034ae93b49fc93b5859a3c047a319d138282
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-04-30_02:53:03
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 2 Mike Kaganski 2019-04-30 13:47:46 UTC
https://gerrit.libreoffice.org/71585
Comment 3 Commit Notification 2019-04-30 15:09:06 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/6952a3ba27d0d0fc08c5701b4ed7dd9982c9c60d%5E%21

tdf#125046: export longText attribute for sharedItems element

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.