How to format one sheet differently?

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.

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

?