| Summary: | Exporting to XLSX a pivot table based on a field having long text elements produces warnings and repairs when opened in Excel | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Mike Kaganski <mikekaganski> |
| Component: | Calc | Assignee: | Mike Kaganski <mikekaganski> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | aron.budea |
| Priority: | medium | Keywords: | dataLoss, filter:xlsx |
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.3.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 104839, 112416 | ||
| Attachments: | A pivot table referencing a cell with a long text string | ||
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 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. |
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)".