Description: If you enter a long text in the rightmost cell and fit it in the cell, it should fit on one page, but an extra second page will be printed. Steps to Reproduce: 1.Calc open. 2.Enter a long text in cell G1 and select Shrink to fit Cell Size under Cell Format. 3.Print Preview or PDF export. Actual Results: page 2 is printed Expected Results: print only one page Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2a9e83a673300dfe15a3acc66acd560b2a7cae43 CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: CL threaded
Created attachment 188694 [details] sample file
Put it right in: Menu/Format/Page Style – [Sheet] – Scale Set up it as you need. https://help.libreoffice.org/latest/en-US/text/scalc/01/05070500.html?&DbPAR=CALC&System=WIN Search for 'Scale'
Created attachment 188712 [details] manually font size changed Second page not visible after manually reducing cell font size In this case, don't you think it's strange that the next page is displayed even though the print range is up to column G? I know that using scale in page style will fit on one page
With both files, I'm not able to reproduce the issue with the three steps in comment#1 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2a9e83a673300dfe15a3acc66acd560b2a7cae43 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Please test in safe mode, Menu/Help/Restart in Safe Mode
Created attachment 188979 [details] i think it's a bug Reproduce it at hand. A blank page prints as in the attached image. Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 24; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded
Reproduce in Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded
It's interesting that this bug is reproduced just by Japanese users. So, could be something with locale.
Try this step 1.Enter "ZZZZZZZZZZZ" in cell G1. (11 or more "Z"s) 2.Select [View]>[Page Brake] (You should be able to confirm that there is a second page.) 3.Select Shrink to fit Cell Size under Cell Format. Should fit on page 1, but page 2 exists