Bug 151969

Summary:	Multi-line cell breaks selected image export with modified dimensions
Product:	LibreOffice	Reporter:	Daniel Collins <dcollins>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	stephane.guillou
Priority:	medium
Version:	6.3.6.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Test case with one wrapped cell Result of making dimension bigger Result of making dimension smaller Example data and exports to show that text hasn't scaled Example data and exports to show that text hasn't scaled

Description Daniel Collins 2022-11-09 04:43:50 UTC

Description:
I'm exporting a selection of a spreadsheet as an image file and modifying the destination dimensions. For most of the spreadsheet this works as expected, but in the case of a multi-line cell (either from "Wrap text automatically" or a hard-typed line break) the modified size is broken. It appears that the multi-line cell stays at the same size & position while the rest of the sheet image dilates around it.

Steps to Reproduce:
1. Create a spreadsheet with at least one multi-line cell.
2. Select part of the sheet of interest.
3. Click File > Export > Selection > Save > Modify Dimensions > choose a different Width (e.g., half or twice the base size). 
4. View the resulting image file.


Actual Results:
The multi-line is misplaced and at a different size from the other cells.

Expected Results:
The multi-line cell should be resized and positioned similar to the other cells.


Reproducible: Always


User Profile Reset: No

Additional Info:
- This works with either type of image format export (JPG or PNG). 

- This works *only* if the limited "Selection" box is checked in the Export dialog. If that box is not checked (i.e., export the whole page), then this bug does not occur.

- Initial observation was from exporting as PNG with increased resolution (e.g., 96 -> 1200 p/i), while keeping the dimensions fixed. This resizes the total number of pixels and exhibits the bug described here.

Version: 7.3.5.2 (x64) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

Comment 1 Daniel Collins 2022-11-09 04:46:53 UTC

Created attachment 183487 [details]
Test case with one wrapped cell

Test case with one wrapped cell

Comment 2 Daniel Collins 2022-11-09 04:48:13 UTC

Created attachment 183488 [details]
Result of making dimension bigger

Result of making width dimension bigger (2.81 -> 6 inches).

Comment 3 Daniel Collins 2022-11-09 04:49:26 UTC

Created attachment 183489 [details]
Result of making dimension smaller

Result of making width dimension smaller (2.81 -> 1.5 inches).

Comment 4 Daniel Collins 2022-11-09 05:27:40 UTC

Related issue: As noted above, if the "Selection" box is unchecked, then this specific bug is not visible, and the multi-line cell stays in proportion with the other cells. HOWEVER: It appears that works by *none* of the content actually scaling at all in that case. (E.g., scale dimension bigger, and blank page gets huge, while content stays at the same pixel size, effectively shrinking in terms of size on the page). Probably that should be written up as a separate bug. (?)

Comment 5 Stéphane Guillou (stragu) 2022-11-10 14:46:48 UTC Comment hidden (obsolete)

Created attachment 183521 [details]
Example data and exports to show that text hasn't scaled

Confirmed in:

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

Wrapped text was completely misplaced only when PNG export size was modified.

It's as if everything was upscaled or downscaled _except_ for the text that is wrapped. See in attachment.

Comment 6 Stéphane Guillou (stragu) 2022-11-10 14:51:23 UTC

Created attachment 183522 [details]
Example data and exports to show that text hasn't scaled

Confirmed in:

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

Wrapped text was completely misplaced only when PNG export size was modified.

It's as if everything was upscaled or downscaled _except_ for the text that is wrapped. See in attachment.
Same happens with JPG.

Other issue can be a separate bug, yes, making sure this one is listed in the "See also" field.
Thank you!

Comment 7 Stéphane Guillou (stragu) 2022-11-10 14:53:28 UTC

Already an issue in LO 6.3:

Version: 6.3.6.2
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

Comment 8 Stéphane Guillou (stragu) 2023-09-06 22:55:17 UTC

This had already been reported in bug 137263, so marking as a duplicate.
Thank you!

Comment 9 Stéphane Guillou (stragu) 2023-09-06 22:56:34 UTC


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