Bug 134537

Summary: Print to 1 Page Width shifts centered output to right, off page
Product: LibreOffice Reporter: Peter Davis <peter.b.davis314>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, miguelangelrv, peter.b.davis314
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108800    
Attachments: Calc Spreadsheet of Problem, Only contains text.

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