Bug 134146 - FILEOPEN XLSX Long axis title is not breaking to multiple lines
Summary: FILEOPEN XLSX Long axis title is not breaking to multiple lines
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Tünde Tóth
URL:
Whiteboard: target:7.1.0
Keywords:
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2020-06-19 09:09 UTC by NISZ LibreOffice Team
Modified: 2020-07-08 08:32 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (13.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-06-19 09:09 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc (95.37 KB, image/png)
2020-06-19 09:10 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-06-19 09:09:59 UTC
Created attachment 162204 [details]
Example file from Excel

Attached document contains a simple chart with axis titles enabled, filled with long text and in the case of Y axis even set to horizontal for better readability.
MSO automatically breaks the text in more lines when necessary, but Calc does not.

Steps to reproduce:
    1. Add a new chart in Excel, and enable axis titles
    2. Add long text to the axis title so that it breaks to multiple lines
    3. Save as XLSX, open in Calc

Actual results:
No line break in the axis titles.

Expected results:
Axis titles break.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 33a720ab802491f15b247e09755cd36205b6f435
CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: alapértelmezett; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-06-19 09:10:34 UTC
Created attachment 162205 [details]
Screenshot of the original document side by side in Excel and Calc
Comment 2 Xisco Faulí 2020-06-22 13:36:49 UTC
Reproduced in

Version: 7.1.0.0.alpha0+
Build ID: 70479e1f4cb3c120f46239a648e65f035af2922d
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.19; Render: default; 

Locale: en-US (en_US.UTF-8)

and

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 3 Commit Notification 2020-07-07 08:15:02 UTC
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/23b73bc02536455df75438e19b5c70bacc9aa700

tdf#134146 Chart OOXML import: break long horizontal Y axis title

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