Ask Your Question
0

Format->Page->Sheet affects all sheets in a spreadsheet [closed]

asked 2018-10-24 02:11:17 +0200

let gravatar image

OS Windows 7 Pro 64 bit patched

LibreOffice 6.0.6.2 64 bit

Under LibreOffice calc I created a spreadsheet years ago. Each sheet had its own page format for printing. Format->Page->Sheet->Print order

None of these sheets are that large.

Small sheets were set to “Fit print ranges to width/height” of one.

Larger sheets would normally be set to two pages high.

With the rare one left at 100%.

Recently, maybe with the update to 6.0.6.2 but I’m not sure all the sheets must use the same page formatting. Small sheets are now spread over two pages or large sheet become unreadably small on one page.

My current solution is to format the page prior to printing, not an elegant solution. Next up would be breaking each printing style of sheet into their own spreadsheets.

Is there some option to let each sheet save its own page format or an option that removes that ability?

Thank you

Luke

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-10-24 20:58:38.602956

1 Answer

Sort by » oldest newest most voted
2

answered 2018-10-24 05:22:03 +0200

KH gravatar image

I think what you're experiencing now is intended behavior. Perhaps things were different in the past -- I don't know.

If you notice, when you open the page formatting dialog, it shows the page style, e.g. "Page Style: Default". So this is really the same as opening the styles sidebar (F11), clicking the page style button (second from the left) and modifying the current (highlighted) style.

So, the solution is to create the page styles you need, then apply them to the appropriate sheets.

edit flag offensive delete link more

Comments

Thank you that solved the problem.

Using the F11 styles sidebar, selecting the page style button and then selecting the style worked.

calc had all but one of the formats I used there, so I created it and then selected a style for each sheet. Haven't printed anything yet but the previews look good.

Thanks!

Luke

let gravatar imagelet ( 2018-10-24 15:47:05 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2018-10-24 02:11:17 +0200

Seen: 236 times

Last updated: Oct 24 '18