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.
Place the cell cursor on a cell immediately right of the column break and then go Sheet > Delete Page Break > Column Break.
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).
Please upload your ODF type sample file here.
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.
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).
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.
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!
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
Do not answer a question unless it is a real answer.