How to format one sheet differently?

asked 2020-04-08 18:00:37 +0200

orelphick gravatar image

In Calc I have a set of accounts on 12 separate sheets in one document.

I want to print all of them scaled down to a single page, except for one sheet, which should be on two pages, otherwise it is too small. There is no option that I can see to change the scaling of one out of all the sheets. I tried putting in a pagebreak, but it is ignored.

edit retag flag offensive close merge delete



Have you ever tried to

  • Define a new page style (e.g. PrintOn2Pages)
  • Set Scaling mode on tab:Sheet of the page style properties to: Fit print ranges on number of pages and set Number of pages: to 2
  • Assign that new page style to the sheet which needs to be printed on 2 pages


Opaque gravatar imageOpaque ( 2020-04-08 23:13:14 +0200 )edit