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
Created attachment 183487 [details] Test case with one wrapped cell Test case with one wrapped cell
Created attachment 183488 [details] Result of making dimension bigger Result of making width dimension bigger (2.81 -> 6 inches).
Created attachment 183489 [details] Result of making dimension smaller Result of making width dimension smaller (2.81 -> 1.5 inches).
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. (?)
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.
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!
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
This had already been reported in bug 137263, so marking as a duplicate. Thank you!
*** This bug has been marked as a duplicate of bug 137263 ***