Bug 153544 - Labels moved and/or lost when exporting Calc charts as vector (SVG), raster (JPG, BMP, PNG), or pasted as GDI Metafile
Summary: Labels moved and/or lost when exporting Calc charts as vector (SVG), raster (...
Status: RESOLVED DUPLICATE of bug 153672
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Chart regression-scaled-glyph-positions
  Show dependency treegraph
 
Reported: 2023-02-11 13:07 UTC by tomaskeb
Modified: 2023-11-22 11:11 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
png testimage (4.63 KB, image/png)
2023-02-11 13:08 UTC, tomaskeb
Details
svg testimage (7.79 KB, image/svg+xml)
2023-02-11 13:08 UTC, tomaskeb
Details
test ods file (15.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-11 13:09 UTC, tomaskeb
Details
Source file (20.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-17 11:11 UTC, Jürgen Mähnß
Details
jpg-output (20.27 KB, image/jpeg)
2023-02-17 11:12 UTC, Jürgen Mähnß
Details
png-output (21.28 KB, image/png)
2023-02-17 11:12 UTC, Jürgen Mähnß
Details
svg-output (12.59 KB, image/svg+xml)
2023-02-17 11:12 UTC, Jürgen Mähnß
Details
same source but with additional labelling for the axis (22.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-17 11:23 UTC, Jürgen Mähnß
Details
svg-output: Only label on y-axis misplaced (13.85 KB, image/svg+xml)
2023-02-17 11:23 UTC, Jürgen Mähnß
Details
Labels moved or lost - VIDEO.mp4 (4.15 MB, video/mp4)
2023-02-23 14:25 UTC, Piotr Osada
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tomaskeb 2023-02-11 13:07:36 UTC
Description:
When exporting the chart in Calc as image, the titles of x/y axes are not visible (png) or have wrong positions (svg).

Steps to Reproduce:
1. create a chart with x/y axis titles
2. export it as image

Actual Results:
the titles are moved away or are not present at all

Expected Results:
the exported chart looks like the one in Calc


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: cs-CZ (cs_CZ); UI: cs-CZ
Calc: threaded
Comment 1 tomaskeb 2023-02-11 13:08:00 UTC
Created attachment 185313 [details]
png testimage
Comment 2 tomaskeb 2023-02-11 13:08:18 UTC
Created attachment 185314 [details]
svg testimage
Comment 3 tomaskeb 2023-02-11 13:09:00 UTC
Created attachment 185315 [details]
test ods file
Comment 4 Ezinne 2023-02-13 10:03:48 UTC
Reproducible in:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4a0d671706306661c4a5072ce4769dc47bc65f71
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 5 Stéphane Guillou (stragu) 2023-02-13 11:32:33 UTC
Thank you for the report, this is a regression in LO 7.5 and a serious one in my opinion.

Seen in:

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

But not in:

Version: 7.4.5.1 / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 6 Stéphane Guillou (stragu) 2023-02-13 11:53:53 UTC
bibisected with linux-64-7-5 repo to first bad commit 5e9e431b4a9bc67357adaf635c34bdfd3ee61321 which points to core commit:

commit 1fa731d03ba0f22cb9392a578124ea977eaab2e9
author	Caolán McNamara <caolanm@redhat.com>	Tue Aug 16 23:39:53 2022 +0100
committer	Caolán McNamara <caolanm@redhat.com>	Thu Aug 18 20:30:33 2022 +0200
tree fd415b74a5f728e0eb99eb25b552c248c80112e9
parent b72ebcf5b26ab2e54c5251c5c45e6d45cade9236
tdf#150462 don't prescale dxarray before using DrawTextArray
setup the device scaling instead and pass in the unscaled dxarray and at
least give vcl the chance to retain some accuracy
Change-Id: I17660eb77adf8586be6eb54e61bded3a5bcc20a9
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/138448

Caolán, can you please have a look?
Comment 7 Jürgen Mähnß 2023-02-17 11:10:56 UTC
I tested another spreadsheet and can confirm misplaced labeling and axis in png and jpg but not in svg
Comment 8 Jürgen Mähnß 2023-02-17 11:11:48 UTC
Created attachment 185429 [details]
Source file
Comment 9 Jürgen Mähnß 2023-02-17 11:12:19 UTC
Created attachment 185430 [details]
jpg-output
Comment 10 Jürgen Mähnß 2023-02-17 11:12:39 UTC
Created attachment 185431 [details]
png-output
Comment 11 Jürgen Mähnß 2023-02-17 11:12:56 UTC
Created attachment 185432 [details]
svg-output
Comment 12 Stéphane Guillou (stragu) 2023-02-17 11:18:55 UTC
(In reply to Jürgen Mähnß from comment #7)
> I tested another spreadsheet and can confirm misplaced labeling and axis in
> png and jpg but not in svg

Jürgen, can you please check that you are describing the same issue by confirming that it didn't exist back in LO 7.4? Thank you!
Comment 13 Jürgen Mähnß 2023-02-17 11:21:47 UTC
(In reply to Jürgen Mähnß from comment #7)
> I tested another spreadsheet and can confirm misplaced labeling and axis in
> png and jpg but not in svg

Modified the graph and added labels for axis : Now as well in svg wrong labelling, but only for for y-axis.
Comment 14 Jürgen Mähnß 2023-02-17 11:23:06 UTC
Created attachment 185434 [details]
same source but with additional labelling for the axis
Comment 15 Jürgen Mähnß 2023-02-17 11:23:42 UTC
Created attachment 185435 [details]
svg-output: Only label on y-axis misplaced
Comment 16 Jürgen Mähnß 2023-02-17 11:33:00 UTC
(In reply to Stéphane Guillou (stragu) from comment #12)
> (In reply to Jürgen Mähnß from comment #7)
> > I tested another spreadsheet and can confirm misplaced labeling and axis in
> > png and jpg but not in svg
> 
> Jürgen, can you please check that you are describing the same issue by
> confirming that it didn't exist back in LO 7.4? Thank you!

I just tested with 7.4.3.2 portable: Works as intended

Version: 7.4.3.2 (x86) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

Malfunction with 
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Comment 17 Stéphane Guillou (stragu) 2023-02-20 11:03:08 UTC
*** Bug 153757 has been marked as a duplicate of this bug. ***
Comment 18 Piotr Osada 2023-02-23 14:25:58 UTC
Created attachment 185547 [details]
Labels moved or lost - VIDEO.mp4

The same behaviour for:

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-GB
Calc: threaded
Comment 19 Stéphane Guillou (stragu) 2023-02-24 12:36:03 UTC
Regression is also seen when copying the chart in attachment 185315 [details] and pasting it as a GDI metafile: all text is lost.

JPG and BMP also affected, but likely using the same route as PNG.
Comment 20 Caolán McNamara 2023-03-02 16:14:52 UTC
seems to be the same as bug 153672 the proposed fix seems to address this too at least

*** This bug has been marked as a duplicate of bug 153672 ***
Comment 21 Stéphane Guillou (stragu) 2023-03-07 06:12:47 UTC
*** Bug 154033 has been marked as a duplicate of this bug. ***