Bug 150434 - LibreOffice displays the full text of the legend, so the legend overflows the chart area.
Summary: LibreOffice displays the full text of the legend, so the legend overflows the...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Tünde Tóth
URL:
Whiteboard: target:7.5.0
Keywords: filter:xlsx
Depends on:
Blocks: OOXML-Chart Chart-Legends
  Show dependency treegraph
 
Reported: 2022-08-16 09:12 UTC by NISZ LibreOffice Team
Modified: 2022-08-22 06:46 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Test file with .xlsx file format (14.66 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-16 09:13 UTC, NISZ LibreOffice Team
Details
Visual comparison Excel vs LO (154.96 KB, image/png)
2022-08-16 09:15 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 2022-08-16 09:12:13 UTC
Description:
When I made a diagram in Excel, with long legend text. Excel cuts off the text to fit the legend in the chart area.
LibreOffice displays the full text of the legend, so the legend overflows the chart area.


Steps to Reproduce:
1. Open attachment document (long_legend.xlsx) in LibreOffice



Actual Results:
LibreOffice displays the full text of the legend, so the legend overflows the chart area.

Expected Results:
The text does not flow outside the diagram area. The entire text of the legend is not displayed, similar to Excel.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 5dde7a14a2bfc4c29f5f60b7e47fdc7046ede0b0
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2022-08-16 09:13:20 UTC
Created attachment 181802 [details]
Test file with .xlsx file format
Comment 2 NISZ LibreOffice Team 2022-08-16 09:15:39 UTC
Created attachment 181803 [details]
Visual comparison Excel vs LO
Comment 3 Commit Notification 2022-08-18 11:40:14 UTC
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/e59db22b3b57c9e1a5678218cb56fb75bcc84c26

tdf#150434: chart2, XLSX import: strip long legend labels

It will be available in 7.5.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.
Comment 4 NISZ LibreOffice Team 2022-08-22 06:46:32 UTC
Verified in:

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 1c1647e6ee252fe68d7406d01043e88f1721590f
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL