Ask Your Question
0

printing from calc print is postage stamp

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

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 5.4.5.1 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
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 57 times

Last updated: Jun 01 '18