Bug 133190 - FILESAVE XLSX Pie charts Line break in shapes property is always set on save
Summary: FILESAVE XLSX Pie charts Line break in shapes property is always set on save
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:7.0.0
Keywords:
Depends on:
Blocks: OOXML-Chart Pie-and-Donut
  Show dependency treegraph
 
Reported: 2020-05-20 09:47 UTC by NISZ LibreOffice Team
Modified: 2024-10-15 21:05 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (12.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-05-20 09:47 UTC, NISZ LibreOffice Team
Details
The original file saved by Calc (7.95 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-05-20 09:47 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in Excel and Calc (122.89 KB, image/png)
2020-05-20 09:47 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-05-20 09:47:01 UTC
Created attachment 161027 [details]
Example file from Excel

Attached XLSX file contains a pie chart with long data labels and Line break in shapes property turned off.
This setting is imported to Calc correctly as “Auto text wrap” OFF, but on save the value is turned on.

Steps to reproduce:
    1. Create a pie chart with long data labels in Excel
    2. Go to Format Data Labels, Label Settings and turn off the Line break in shapes setting. This makes the long data labels display in one line.
    3. Save as XLSX, open it in Calc then save the file again with a different name.

Actual results:
Auto text wrap (in Calc) or Line break in shapes (in Excel) is turned on. Data labels are wrapped to multiple lines.

Expected results:
Auto text wrap setting is retained.

LibreOffice details:
Version: 7.0.0.0.alpha1+ (x64)
Build ID: 442c7b95e2ee94b66a9854d0cb22f8ecb76532c6
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-05-20 09:47:25 UTC
Created attachment 161028 [details]
The original file saved by Calc
Comment 2 NISZ LibreOffice Team 2020-05-20 09:47:43 UTC
Created attachment 161029 [details]
Screenshot of the original and exported document side by side in Excel and Calc
Comment 3 Commit Notification 2020-05-25 12:41:32 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/74d020fb1344dd904681b612739727351f183b78

tdf#133190 tdf#133191 Chart OOXML export: fix text wrap and rotation

It will be available in 7.0.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.