Description: If the font size in a spreadsheet is adjusted to make all rows barely fit on a single page, as shown by the View->Page Break display, then if the spreadsheet is saved and reloaded, the page break falls at a different place (the last row then falls onto a second printed page). Steps to Reproduce: 1. Load the attached demo.ods 2. View->Page Break (notice that the last two rows do not fit) 3. View->Styles (or hit F11, or click the Styles icon on the right edge) UN-check "Show previews" 4. Put mouse on "Default"; rightclick->Edit Style... 5. In the "Font" screen, change Size from 14pt to 13.5 pg; click OK (notice that all rows now fit on the same page according to the Page Break preview) 6. File->Save 7. File->Reload Actual Results: The last row no longer fits on the first page Expected Results: Formatting (including exact sizes and row heights) should not change; all rows should still fit on the first page Reproducible: Always User Profile Reset: No Additional Info: Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3b0ea28e061f9335b907ae8febfadf8fc04c599b CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 203543 [details] demo.ods
Confirmed. After adjusting the font size to 13.5 pt to fit all rows on one page (using the page break preview to confirm), saving and reloading the file causes then causes the last row to no longer fit on one page. Tested in: Version: 25.8.2.2 (X86_64) Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
At least with the example file, reproduced already in oldest of Linux 43all repo.