Scale up the print output to full page width

I want a table to be scaled up to fill the entire page. I just want scaling, I don’t want any ratios to change.

I looked up this: How to have calc document print full page? and also this: Calc: print a sheet to fit A4

  • opened print preview
  • checked margins and they are fine
  • clicked “format page” and selected the sheets tab
  • changed “scaling mode” to “fit print range(s) to width/height”
  • checked “width in pages” and set value to 1
  • unchecked “height in pages”

I didn’t adjust the width of the columns with the mouse, because that’s not what I want. The font size matches the column size and I don’t want that to change. I only want the table to be zoomed in until it perfectly fits the width of the page.

The table still doesn’t fill the page. The size of the table didn’t change at all in the print output when I changed the scaling mode.

Am I doing it wrong or could it possibly be that it’s only able to scale down, but not to scale up?

1 Like

You did everything right. Please upload the problematic file or file fragment after your actions.

Here is a shortened example with dummy content:
example.ods (24.0 KB)

1 Like

Choose File - Print Preview and increase the printing scaling factor.
imagen

After that, you can see and modify the scaling factor value in the Sheet tab of the Page Style dialog:
imagen

Setting the scaling mode to shrink print range(s) will not work here, because there is no need to shrink.
imagen


Version: 24.2.7.2 (X86_64) / LibreOffice Community
OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win

4 Likes

Oh, interesting. For you it says “shrink print range(s) to width/height”, but for me the option is labeled: “fit print range(s) to width/height”. That was leading me to think it would automatically scale up.

OK, so if I want to scale up to fit the page width, I just have to increase scale factor manually.

The same in version: 6.4.7.2 (x64).
If you can, update your LibreOffice.

Enabling margins could help here.

print to pdf, then enjoy … https://www.adobe.com/acrobat/hub/change-page-size-of-pdf-in-4-steps.html

Thanks fpy, that would be an obvious workaround for a one pager, but it would make it very hard for me to edit all the line brakes. I’d have to be constantly exporting, scaling in adobe to check the line breaks.

I thought this to be a rather reasonable request. Isn’t the print dialog of calc providing any solution?

EDIT: I meant page breaks on not line breaks of course.