Bug 134842 - FILESAVE - Export to .png or .jpg shrink the image adding white borders
Summary: FILESAVE - Export to .png or .jpg shrink the image adding white borders
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
6.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Graphics-Export
  Show dependency treegraph
Reported: 2020-07-15 20:59 UTC by LeroyG
Modified: 2023-01-28 23:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Sample .ods file (9.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-15 21:00 UTC, LeroyG
Resulting file from sample (1.44 KB, image/png)
2020-07-15 21:02 UTC, LeroyG
Partial Black Border Example (4.90 KB, image/png)
2023-01-28 23:00 UTC, flywire

Note You need to log in before you can comment on or make changes to this bug.
Description LeroyG 2020-07-15 20:59:00 UTC
Exporting a cell, range of cells or sheet as .png or .jpg, adds white borders at right and bottom (sometimes left). Image is shrinked. Noticeable when using background color or borders.

Steps to Reproduce:
1. Apply background color or borders to a cell or range of cells.
2. If less than a page, select cell or range of cells.
2. Choose menu `File` - `Export…`, type file name, (check `Selection` if only is a cell, or range less than a page), `Save` - `OK`.

Actual Results:
Resulting image is shrunk and shows white borders.

Expected Results:
Background or border color seen up to the edge of the image.

Reproducible: Always

User Profile Reset: No

OpenGL enabled: Yes

Additional Info:
Version: (x86)
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: es-MX (es_MX); UI-Language: en-US
Calc: threaded

Tryed with OpenGL disabled, and see no difference.
Comment 1 LeroyG 2020-07-15 21:00:44 UTC
Created attachment 163081 [details]
Sample .ods file
Comment 2 LeroyG 2020-07-15 21:02:31 UTC
Created attachment 163082 [details]
Resulting file from sample
Comment 3 Xisco Faulí 2020-07-16 10:00:41 UTC
Reproduced in

Build ID: d851a02df57ab378ed0cc6d9362516de09c3279c
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded


Build ID: 3a801799536e6870f2fb111b1cc00b9575a35a39
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group

in previous versions, the whole page is exported even if the option selection is opted in
Comment 4 Telesto 2022-02-10 10:13:35 UTC
Version: (x64) / LibreOffice Community
Build ID: 42c5506a9e9ef58efd8193a193464e3b49d481ca
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL
Comment 5 flywire 2023-01-28 23:00:13 UTC
Created attachment 184983 [details]
Partial Black Border Example

Optionally add a border. Displaying this file on black background loses the partial black border detail on left-hand side.