I’ve created a six page calc sheet with borders around pertinent clumps of data. I inserted page breaks a few months ago and I can’t seem to get rid of them. I’ve followed the directions I find when I do a search for this issue. They sound simple, but they don’t work.
Have you overridden your full page size with manual printable area definitions? Can you reset page breaks using Format/Print Ranges/Clear, which will change the breaks back to the Format/Page size definition, or maybe test a sample sheet after setting a manual Print Range? Also, do you mean only the visual display of the page breaks, not the function? That check box is under LIbreOffice/Preferences (Tools/Options)/LIbreOffice Calc/View/Page Breaks.
I have the same problem. I set up a new Calc sheet, and it is showing arbitrary page breaks. When I go to Sheet->Delete Page Breaks, both Row Break and Column break are greyed out. I.e., Calc doesn’t seem to recognize the breaks. (They’re real–Print Preview shows them.) I checked Format/Print Ranges, and there are none set–“Clear” is greyed out.
Using LO 24.2.7.2 (X86_64) on Fedora 40.
Click Format > Page style > Sheet. There you will see a field Scaling mode, change the mode from “Shrink print range(s)…” to Reduce/enlarge printout so you can modify page breaks manually.
It was set for Reduce/enlarge printout already. The Scaling Factor is set to 100%.
PS: the sheet is a log I keep. Each year I start a new one by copying the last week’s entry from the previous year’s log. The arbitary page breaks go back any number of years–I just noticed them now. But I can’t see why that would keep me from modifying page size in the current version.
And if you right click on the range, do you see a context menu item Delete Page Breaks?
I don’t have any named ranges. I don’t know what you mean by right clicking on the range.
The range of data
I select that entry and right-click, but nothing about Delete Page Break
If I insert a column break, then I can delete that break. But that does nothing to affect the page breaks that are showing up as it were by default when I copy from the previous document.
In that case there should be only the automatically generated ones.
Can you provide a small sample file? You can use Find and Replace to replace your text with XXX or something.
If I click View > Page break then I see just the page breaks generated by LibreOffice for that percentage scale, that is, 100%. I can drag the page breaks to another position without problem.
.
If you just don’t want to see the dotted lines representing the page breaks you can turn them off. Click Tools > Options > LibreOffice Calc > View and untick Page breaks
Thanks. I didn’t know I could just drag them like that.
What is it 100% of? Why isn’t it 100% of the 8.5x11 page that’s the set page size?
Anyway, thanks for your help and patience.
100% of contents, I suppose cell size but there are some fudge factors.
Page is secondary for spreadsheets but changing the percentage will allow more content to fit the width of the page. As you drag the page breaks, you scale the contents to fit more into the same size page so the percentage will change.
1 Like
Real size in print. If there is a column that don’t fit, there will be more “margin”.
In the Print Preview mode you can use the scaling factor slider (this will be reflected in menu Format - Page Style - Sheet tab).
