Bug 157293 - When exporting cells + shapes in libreoffice calc into a png or jpg, shapes moves and are not aligned anymore
Summary: When exporting cells + shapes in libreoffice calc into a png or jpg, shapes m...
Status: RESOLVED DUPLICATE of bug 134842
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/png-jpg...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-17 15:10 UTC by thurston.more@laposte.net
Modified: 2023-09-20 08:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description thurston.more@laposte.net 2023-09-17 15:10:18 UTC
Description:
if i export a sheet (calc) in png or jpg, where some shapes are used, aligned with cells, these shapes will always be shifted vertically in the resulting image, not let aligned with the cells they refer to. (It can be seen in the image joined). All the losenges should be aligned with their corresponding text. bottom losenge should be located and aligned to the left of “earliest date…”

Steps to Reproduce:
i put / upload some files here
https://ask.libreoffice.org/t/png-jpg-export-of-calc-sheet-with-shapes-shapes-shifted-vertically/95928

Actual Results:
Take an empty sheet (ods).
Put some text in a cell (in the middle of the sheet) It could start be like "- test".
Place a lozenge from shape and align it with the "-" of your test.
export the selection of cells around, including test + shape, into png or jpg. the lozenge will not stay in place, being shifted to the bottom (and a bit to the left).
Whatever it is locked with cell or page will give the issue.
Note that exporting in pdf seems to work fine, it is when exporting into png or jpg the issue comes.

Expected Results:
The software should have kept the shape aligned with the text (or with the cell) as it is shown in the spreadsheet under calc.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Please have a look here
https://ask.libreoffice.org/t/png-jpg-export-of-calc-sheet-with-shapes-shapes-shifted-vertically/95928
Comment 1 Stéphane Guillou (stragu) 2023-09-18 21:20:39 UTC
Reproduced in 7.6.1.2 and 6.0.0.3. Only happens when exporting a cell range selection, not when the whole sheet is exported.
Marking as a duplicate of bug 152714.

*** This bug has been marked as a duplicate of bug 152714 ***
Comment 2 Stéphane Guillou (stragu) 2023-09-20 08:06:02 UTC

*** This bug has been marked as a duplicate of bug 134842 ***