Bug 152714 - Exporting range selection in JPG or PNG, Position object (shape, textbox, formula...) is shifted vertically
Summary: Exporting range selection in JPG or PNG, Position object (shape, textbox, for...
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 All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks:
 
Reported: 2022-12-29 03:26 UTC by nobu
Modified: 2023-09-20 08:07 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
sample file (19.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-29 03:28 UTC, nobu
Details
sample output (jpg) (48.99 KB, image/jpeg)
2022-12-29 03:29 UTC, nobu
Details
the horizontal direction is also shifted, the cell range is shrinking in both directions (33.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-09-19 00:06 UTC, nobu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2022-12-29 03:26:27 UTC
Description:
Exporting Selected Range in JPG, Shapes placed below are greatly shifted.

Steps to Reproduce:
1. Open a new Calc.
2. Place the Shape (ex. Button) in Cell [A30].
3. Draw the border around for comparison
4. Select Range [A1:A30]
5. File > Export (.uno.ExportTo)
6. Check the Selection Range and output JPG images

Actual Results:
7. The shape is out of the position of the Calc display.

Expected Results:
7. The shape is as shown in Calc.


Reproducible: Always


User Profile Reset: No

Additional Info:
There is a similar Bug in PNG.

If you do not check the selection range, it will be output correctly

Version 6.4.2 32bit
OS:Windows10 64bit

Version 7.5.0.1 64bit
OS:Windows10 64bit
Comment 1 nobu 2022-12-29 03:28:51 UTC
Created attachment 184379 [details]
sample file
Comment 2 nobu 2022-12-29 03:29:58 UTC
Created attachment 184380 [details]
sample output (jpg)
Comment 3 m_a_riosv 2022-12-30 02:07:42 UTC
Reproducible
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 376152fbd110cdc0a2cde1fa9758f36c016d9352
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded Jumbo
Comment 4 BogdanB 2023-02-22 16:01:25 UTC
Also on Linux
Version: 7.5.0.1 (X86_64) / LibreOffice Community
Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df
CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 5 Stéphane Guillou (stragu) 2023-09-06 23:14:59 UTC
Still reproduced in:

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

Already the case in 6.0.0.3, when it started being possible to export as JPG. (Eike's commit 52a6c68fb2fc817fc58419835cca73f6cd20b8fe for bug 108317). Didn't check precisely at that commit, but assuming it's an implementation error.
Comment 6 Stéphane Guillou (stragu) 2023-09-18 21:20:39 UTC
*** Bug 157293 has been marked as a duplicate of this bug. ***
Comment 7 Stéphane Guillou (stragu) 2023-09-18 21:29:16 UTC
I also tested with text box and formula: all objects are shifted, regardless of their anchoring (tested to page and to cell).
Applies to both JPG and PNG.
Comment 8 nobu 2023-09-19 00:06:46 UTC
Created attachment 189682 [details]
the horizontal direction is also shifted, the cell range is shrinking in both directions

The vertical gap is easy to understand, but the horizontal direction is also shifted.

I didn't know how to express it, so I used "Out of Place".

Assuming that the image size is output correctly, it should be thought that the object is not shifted, but the cell range is shrinking in both directions.

When the selection of a table with a border is output with PNG, you can understand the phenomenon that causes a blank to the right and down.

Attach a file that shows these phenomena.
Comment 9 Stéphane Guillou (stragu) 2023-09-20 08:06:31 UTC

*** This bug has been marked as a duplicate of bug 134842 ***
Comment 10 Stéphane Guillou (stragu) 2023-09-20 08:07:12 UTC
(In reply to nobu from comment #8)
> Created attachment 189682 [details]
> the horizontal direction is also shifted, the cell range is shrinking in
> both directions
> 
> The vertical gap is easy to understand, but the horizontal direction is also
> shifted.
> 
> I didn't know how to express it, so I used "Out of Place".
> 
> Assuming that the image size is output correctly, it should be thought that
> the object is not shifted, but the cell range is shrinking in both
> directions.
> 
> When the selection of a table with a border is output with PNG, you can
> understand the phenomenon that causes a blank to the right and down.
> 
> Attach a file that shows these phenomena.

Thank you for clarifying the issue, nobu! It's now obvious it's the same problem as bug 134842. I changed that report accordingly.