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 tree / graph
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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.