Bug 134537 - Print to 1 Page Width shifts centered output to right, off page
Summary: Print to 1 Page Width shifts centered output to right, off page
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print
  Show dependency treegraph
 
Reported: 2020-07-05 23:57 UTC by Peter Davis
Modified: 2023-06-02 05:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc Spreadsheet of Problem, Only contains text. (14.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-05 23:57 UTC, Peter Davis
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Davis 2020-07-05 23:57:27 UTC
Created attachment 162671 [details]
Calc Spreadsheet of Problem, Only contains text.

Printing a single column (A) of centered text in Calc 6.4.5.2 (x64) WIN PRO 10.0.19041 using a defined area of 11 rows of Col A (Page Breaks not the problem) and page scaling set to print to 1 page width. Both Preview and the actual printed page show the text shifted to the right actually off the page and with EXTRA SPACE on the left side of the page.  I recall this used to work fine in previous versions. I have left & right margins set to .24" minimum, but there is roughly .50" extra space on left, so the offset is about .25" to the right. Is it doubling the left margin?
While saving a copy to attach to this thread, the copy now is offset less to the right. Changing the Font Size in the spreadsheet column changes how far off the page it goes. The original document was created in ver 5.something in 2017, but creating a new one in 6.4.5.2 and pasting in the info, it has the same problem.
In all cases the words appear centered in the Normal Display Window but not in the Preview Window.
Comment 1 m_a_riosv 2020-07-06 20:43:15 UTC
Repro
Versión: 6.4.5.2 (x64)
Id. de compilación: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
Subprocs. CPU: 4; SO: Windows 10.0 Build 19608; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded
Comment 2 QA Administrators 2022-07-07 03:30:49 UTC Comment hidden (obsolete)
Comment 3 Peter Davis 2022-07-08 07:27:56 UTC
I'm currently using version 7.3.2.2 (x64) WIN PRO 10.0.19044 and tried to recreate the problem as it has been a year and I didn't remember the original document used. It seemed to be working fine now, until I downloaded my original document attached to the bug and the problem persists with that document.

It may be caused by 2 things: on the attached document, apparently the "center" table feature is UNCHECKED. Checking it centers now centers the preview and printed page, however the "fit to 1 page width" is checked but the output is now off the page both left and right.

Is the selection of font size overriding the "fit to 1 page width"?
Comment 4 BogdanB 2023-06-02 05:54:42 UTC
Wrong in print Preview and also in the exported PDF.

Repro in
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 3e6f4bbefaa4f4f83210970210aa7796aab7cf03
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded