Ask Your Question

Page break preview not working in Calc

asked 2015-08-09 01:48:46 +0200

BrianM gravatar image

updated 2015-08-14 06:29:25 +0200

I've used this successfully before, but not now. I have a spreadsheet which doesn't fit on a single sheet of paper. I need to see the breaks so I can adjust accordingly. When I select the Page Break Preview in the View menu I see a slightly shrunken version of my page on a large, medium gray back ground and with no sign of where the breaks might be. It's just one spreadsheet. I've got another one open right next to it and breaks are displayed correctly. What am I doing wrong? Thanks.

Edit: adding a sample file, as requested.TestFile.ods

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2015-08-10 23:06:18 +0200

m.a.riosv gravatar image

updated 2015-08-14 22:41:12 +0200

May be you need to enable the option.

Menu/Tools/Options/LibreOffice calc/Print - Always apply manual break.

Edited 20150811

Have you tried with the scale options in?:
Menu/Format/Page [Sheet] -Scale.

Edited 20150814

Seeing your file it has an easy solution, seems as it has a range defined but no one there.

Menu/Format/Print ranges/Clear

solves the issue.

edit flag offensive delete link more


Thanks. I tried it, but that's not it. I have no manual breaks, nor do I want any. What I want to do is select View|Page Break Preview and see the breaks which have been applied automatically. Then I will shrink my cells down until they just fit on one page.
Unfortunately, when I turn on the Page Break Preview, it just shows the whole spreadsheet on a medium to dark gray background with no breaks. And yet it prints with breaks so I know they are there. I've even tried enlarging my sheet

BrianM gravatar imageBrianM ( 2015-08-10 23:51:43 +0200 )edit

Regarding your edit. I just looked at it. I don't have a "-Scale" option so I'm guessing you mean to adjust the scaling. Currently the option is set as Reduce/Enlarge Printout. It is this way both on the sheet that displays correctly, and on the one that displays incorrectly. They are also both set to a scaling factor of 100%. So I don't think that's it.

BrianM gravatar imageBrianM ( 2015-08-11 19:21:22 +0200 )edit

Can you share a sample file with the issue?, please remember delete any private/personal information.

m.a.riosv gravatar imagem.a.riosv ( 2015-08-13 02:50:50 +0200 )edit

Is there a way to do this within this forum? Otherwise I suppose I could put a file up for you to download.

BrianM gravatar imageBrianM ( 2015-08-13 03:17:37 +0200 )edit

I think I figured it out, I went back to my original message and found a paper clip and tried to attach the file, but it says I need >3 points to do it. How do I get points?

BrianM gravatar imageBrianM ( 2015-08-13 03:40:40 +0200 )edit

Please try to do now, I have voted you question.

m.a.riosv gravatar imagem.a.riosv ( 2015-08-13 10:08:50 +0200 )edit

OK, I added a test file. It has two sheets in it. The first one is an example of the problem, the second shows the breaks correctly. On my system. Hopefully on yours, too! :)

BrianM gravatar imageBrianM ( 2015-08-14 06:31:50 +0200 )edit

answered 2019-09-28 04:28:22 +0200

theoldwizard1 gravatar image

Menu/Tools/Options/LibreOffice calc/Print - Always apply manual break.

On V6.3, thius is now Tools / Options / LibreOffice calc / Print - Always apply manual break

edit flag offensive delete link more


Huh? could you clarify where's the difference? ;-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-28 07:37:03 +0200 )edit

answered 2015-08-14 08:34:13 +0200

JohnD gravatar image

Select the whole sheet then go to menu and select Format - Print Ranges - Define

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-09 01:48:46 +0200

Seen: 2,000 times

Last updated: Sep 28 '19