Full Printing (Not Split Pages) In Calc

Well_well · April 18, 2024, 9:47pm

I want to print, in landscape, a Calc document that has a longer set of cells than is appearing in the Print Preview–it keeps wanting to split the document into two pages…

… but that isn’t going to do me any favors, only complicate things.

How can I do this?

LeroyG · April 18, 2024, 10:20pm

Row Break?
Edit: Column Break?

Well_well · April 18, 2024, 10:27pm

I’m not sure what you’re saying.

The issue is it is not fitting all of the columns into a single page when printing, but is wanting to put some of the columns onto another page. That is not helpful, as I’m sure you could imagine.

LeroyG · April 18, 2024, 10:37pm

Take a look at Scaling mode.
Otherwise, anonymize your file and share here to test.

Well_well · April 18, 2024, 10:37pm

How do I share file?

LeroyG · April 18, 2024, 10:38pm

Edit your question:
· 3 dots icon
· pencil icon
· box with upward arrow icon

Well_well · April 18, 2024, 10:38pm

OK I found the upload button.

Well_well · April 18, 2024, 10:39pm

Anonymous.ods (25.9 KB)

LeroyG · April 18, 2024, 10:48pm

Try changing page size to Tabloid* (menu Format - Page Style - Page tab); now is set to Letter.
* Edit: and Landscape

Well_well · April 18, 2024, 11:24pm

It actually comes out blank.

LeroyG · April 19, 2024, 12:35am

I can’t recognize from where is this screenshot.
Two not related ideas:

There is an empty cell selected, so, nothing is printed. See menu Format - Print Ranges.
Why the screenshot say Letter?

Take a look at the file modified by me:
Anonymous_LeroyG.ods (32.0 KB)

Well_well · April 19, 2024, 12:53am

The screenshot is from the “preview before printing” screen.
I’m not sure, because I had thought that I’d set it to “landscape”, but I’ll make sure I did. I think it was blank in both cases, but I’ll check again.

Well_well · April 19, 2024, 12:53am

Cool, how’d you do that?

Grantler · April 19, 2024, 5:14am

Toggle Print Preview ⇒ Format Page ⇒ Page ⇒ ⦿ Landscape
Toggle Print Preview ⇒ Scaling Factor ⇒ diminish factor a little bit

LeroyG · April 19, 2024, 1:08pm

Well_well · April 19, 2024, 9:06pm

I tried setting to Tabloid, and then Landscape, and it is still doing two pages.

Well_well · April 19, 2024, 9:07pm

OK it was not working because I was not setting Landscape in the same area as I was setting to Tabloid, but, rather, was setting to Landscape in the other Printing options dialogue.