Ask Your Question

printing from calc print is postage stamp

asked 2018-03-15 19:34:41 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

normal spreadsheet when I print the output prints in a square about the size of a postage stamp. There is a page break and I get two sheets printed.

What setting controls this.

Using LO on Windoze 10

p.s. I just printed another calc spreadsheet and it printed correctly using an entire sheet of paper.

pss, fast forward 24 hours.

I did a Ctrl-A and copied the sheet, then I did a Paste Special and only pasted with the boxes on text and numbers checked. That printed. I have had to reformat a bunch of columns, fonts, sizes but I am able to print.

So there must be a corrupt setting in the old sheet. So consider this closed unless someone at LO wants a copy of the corrupt spreadsheet to try and find the problem. I did not delete it.

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-06-01 13:46:34 +0100

hjek gravatar image

To control the scale of the printed output of Calc go to Format -> Page and in the Scale section, you can choose how you want the spreadsheet to fit onto the page. If it is too small (like the size of a postage stamp), then you could try increasing the Scaling factor, and checking in File -> Print Preview whether it looks fine.

edit flag offensive delete link more


LO 6.0+: Menu Format - Page… - Sheet tab - Scale section, set Scaling mode: to Reduce/enlarge printout and Scaling factor: to 100%.

LeroyG gravatar imageLeroyG ( 2020-06-10 19:20:29 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-15 19:34:41 +0100

Seen: 106 times

Last updated: Jun 01 '18