# How do I move an extraneous Page Break in Calc?

I don't know how the column Page Break became created/caused. When I try to delete it (Sheet menu) it isn't recognized as being present. Trying to drag it doesn't work -- moves, but upon un-clicking, it returns to its orginal position.

edit retag close merge delete

Sort by » oldest newest most voted

With Menu/Format/Page - Sheet - Scale
and other already commented options you should be able to solve it.
Menu/Tools/Options/LibreOffice calc/Print - Always apply manual breaks.

more

By working with this procedure I suceeded in obtaining a page break exactly where wanted it, but I don't know how it happened. In examining Sheet, Insert Page Break and Delete Page Break both Row and Column are shaded, so how could I move where a page break occurs? This would be nice to know!

( 2020-11-21 18:13:24 +0100 )edit

Place the cell cursor on a cell immediately right of the column break and then go Sheet > Delete Page Break > Column Break.

more

Doesn't work. Column Break is shaded out (as is Row Break). Same is true whether View Normal or Page Break. LibreOffice 6.4.7.2 (x64).

( 2020-11-20 18:52:03 +0100 )edit

( 2020-11-20 20:27:32 +0100 )edit
1

Maybe it's just a calculated page break, not a manually created one? Page breaks get calculated when going into View > Page Break mode or Print Preview. Those can not be (re)moved unless a manual break results in a smaller page area than a calculated one after which they are recalculated.

( 2020-11-20 21:51:47 +0100 )edit

This reply explains the problem. I am expressly trying to shift your CALCULATED page break 1 column to the right -- to make a LARGER page 1 area. Does Calc have any way around this? Say Format, Page ranges, Edit in which User Defined can define multiple pages $A$1:$S$30(??)C:D? (If so what is (??)? Does Off-line Help provide any insight into how Caculated page breaks are determined? (I'll look.) If worse comes to worse I will try to reconstruct the Calc spreadsheet using Microsoft Excel 2007. But should I want to maintain that in Calc is Calc going to impose its Calculated break?. (I am deferring for now sending the ODF version because of the personal and confidential nature of the data).

( 2020-11-20 23:36:34 +0100 )edit

Please cancel my last Comment question> I found that it was true for a Protected sheet, but not true for an Unprotected sheet. To change placement of a page Break, the sheet must be unprotected. My question has been answered and the query closed. Thanks for your help

more

1