Bug 143089 - FILEOPEN: charts show wrong bar widths, miss line wraps in labels/show in wrong position
Summary: FILEOPEN: charts show wrong bar widths, miss line wraps in labels/show in wro...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.3.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2021-06-26 17:16 UTC by Gerald Pfeifer
Modified: 2023-07-24 06:14 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample PPTX slide with charts (1.36 MB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2021-06-26 17:16 UTC, Gerald Pfeifer
Details
Visual comparison LibreOffice 7.3 vs Office 365 (192.72 KB, image/png)
2021-06-26 17:17 UTC, Gerald Pfeifer
Details
Simple reproducer made in Impress (18.65 KB, application/vnd.oasis.opendocument.presentation)
2021-08-02 07:50 UTC, NISZ LibreOffice Team
Details
The reproducer document in Impress (57.60 KB, image/png)
2021-08-02 07:52 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gerald Pfeifer 2021-06-26 17:16:47 UTC
Created attachment 173228 [details]
Sample PPTX slide with charts

Open the sample document in both Office 365 and LibreOffice and observe

 - how some charts show wrong bar widths,
 - lack line wraps for their labels (which I speculate are related),
 - use different colors for the third bar in each chart

Seen with Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: f446a203fa2897bab8ae7686c948a8bf060675c6
CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-24_15:16:38
Calc: threaded

Already seen in: Version: 6.4.8.0.0+
Build ID: 99b065ec31d032fc08ab14f66430dac4fef904a5
CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:libreoffice-6-4, Time: 2020-10-08_08:57:08
Comment 1 Gerald Pfeifer 2021-06-26 17:17:54 UTC
Created attachment 173229 [details]
Visual comparison LibreOffice 7.3 vs Office 365
Comment 2 m_a_riosv 2021-06-26 22:22:41 UTC
Repro
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 1db375e06516d0532f01f9585986617aa3079866
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded

I think not supported, in excel figures like a combo type that allows to select a type for every series.

Perhaps should be a request for enhancement.
Comment 3 NISZ LibreOffice Team 2021-08-02 07:47:36 UTC
The third bars with 4 colors use a multi-step gradient as fill - that's bug 76682.

The other two issues are connected, but not OOXML-specific problems: they are the current limits of the chart engine.

These narrow charts have only one data series and that is presented differently than in PP:
- Long labels are wrapped in PP when they reach the chart areas vertical edges. This does not happen in Impress/LO, not even when the axis labels Break option is enabled, but the drawing area gets narrowed. (let's try to focus on this here)
- The drawing area has an automatic layout which does not fill the entire width of the chart area in PP but it does in Impress, so it's columns look wider in case of the charts with shorter axis labels. (I'll open a separate one for this)

The <c:v>Lemons in 
Truckbay</c:v> text has a manual row break in it this is why there is line break for that one chart in Impress.
Comment 4 NISZ LibreOffice Team 2021-08-02 07:50:13 UTC
Created attachment 174019 [details]
Simple reproducer made in Impress

Long axis label and reduced chart width made in current nightly.
Comment 5 NISZ LibreOffice Team 2021-08-02 07:52:11 UTC
Created attachment 174020 [details]
The reproducer document in Impress

The label is not broken even if the Break option is enabled (like it is for OOXML-import):

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7c38362dbe1922c9825dffb463072030948d406b
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 6 Gerald Pfeifer 2022-03-10 11:34:43 UTC
Tomaž Vajngerl has addressed the wrapping issue with the following:

  https://gerrit.libreoffice.org/c/core/+/129813
  https://gerrit.libreoffice.org/c/core/+/129814

The primary difference between Impress and Office 365 is that the
individual charts are wider in Impress, narrower in 365 (and multi-step
gradient, which is unrelated).


Tomaž, how do you recommend to proceed with this bug report?



(In reply to NISZ LibreOffice Team from comment #3)
> - The drawing area has an automatic layout which does not fill the
>   entire width of the chart area in PP but it does in Impress, so
>   it's columns look wider in case of the charts with shorter axis
>   labels. (I'll open a separate one for this)

Hi NISZ / Arun, have you opened that separate report? Would you mind
sharing its number? Thank you!