Ask Your Question

How do I move an extraneous Page Break in Calc?

asked 2020-11-20 03:54:24 +0100

WWWsub2 gravatar image

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 flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2020-11-20 23:52:04 +0100

m.a.riosv gravatar image

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

edit flag offensive delete link 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!

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

answered 2020-11-20 14:35:58 +0100

erAck gravatar image

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

edit flag offensive delete link more


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

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

Please upload your ODF type sample file here.

Zizi64 gravatar imageZizi64 ( 2020-11-20 20:27:32 +0100 )edit

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.

erAck gravatar imageerAck ( 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).

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

answered 2020-11-21 18:37:27 +0100

WWWsub2 gravatar image

updated 2020-11-23 17:35:54 +0100

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

edit flag offensive delete link more



Do not answer a question unless it is a real answer.

gabix gravatar imagegabix ( 2020-11-22 11:50:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-20 03:54:24 +0100

Seen: 51 times

Last updated: Nov 23