[Solved] Manual page break not working

[morganmusic]

Hello, I have a spreadsheet; I inserted a manual row break (tried two ways - by clicking the desired cell and by selecting the desired row); I can see a visual purple line within the spreadsheet where the page break is supposed to occur. However, when I print to PDF or preview the spreadsheet, the page break does not occur. How can I fix this problem? Thank you.

[FJCC]

Can you upload an example document. I just tested a manual row break and it works for me. To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.

[MrProgrammer]

I inserted a manual row break (tried two ways - by clicking the desired cell and by selecting the desired row); I can see a visual purple line within the spreadsheet where the page break is supposed to occur. However, when I print to PDF or preview the spreadsheet, the page break does not occur.

Check Format → Page → Sheet → Scaling. If you're using one of the Fit to settings, you're asking Calc to determine the page breaks. Try Reduce/Enlarge and see if that solves the problem.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[morganmusic]

Thank you, Mr Programmer -- that's the issue. I removed a "fit" setting and the page breaks now works as expected.