[Solved] Unexpected result when printing spreadsheet

Discuss the spreadsheet application
Locked
Powderdog
Posts: 38
Joined: Wed Jun 12, 2013 7:10 pm

[Solved] Unexpected result when printing spreadsheet

Post by Powderdog »

I'm trying to create a spreadsheet showing fertilizer data for various of my garden plants. The problem is that, when I try to print it, it comes out insane. See attached screen shots.
I can't figure out how to attach the screen shots !!!
Last edited by MrProgrammer on Fri Jul 30, 2021 1:46 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.6 Windows 10 home
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: printing calc

Post by Hagar Delest »

Your screenshots have to be smaller than 128KB. Crop them if needed.

Define print ranges and export to PDF first to make sure of the rendering.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: printing calc

Post by Zizi64 »

See attached screen shots.
The file size limit is 128 KiB in this forum. Use the lossless compression .png file format with 64 color depth. Then the image will not be blurry. Crop the irrelevant parts of the imege. Then the file size will be extremly decreased.

Use a third party image manager software like the free IrfanView.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Powderdog
Posts: 38
Joined: Wed Jun 12, 2013 7:10 pm

Re: Unexpected result when printing spreadsheet

Post by Powderdog »

I don't remember why I thought that screen shots were the preferred conveyance but I'm glad to hear that they aren't. It's much less trouble just to attach the actual file.
I give up: now I can't figure out how to attach a file. I'm just going to try to tag this as SOLVED and figure out the printing problem myself. I created a spreadsheet for my income tax that I had no trouble with except that I was learning Calc as I went along. At that time I didn't even know how to initiate the program but I succeeded in creating a spreadsheet that I was happy with. Adios.
Attachments
Spreadsht page preview.ods
(11.51 KiB) Downloaded 109 times
Spreadsht created.ods
(11.69 KiB) Downloaded 108 times
OpenOffice 4.1.6 Windows 10 home
gpgrego
Posts: 39
Joined: Fri Jan 31, 2020 4:04 pm

Re: Unexpected result when printing spreadsheet

Post by gpgrego »

By clicking on "Page Format" you can set the page format, margins and everything else.
Attachments
Spreadsht_1.jpg
openoffice 4.1.6 - Windows 10
Bill
Volunteer
Posts: 8932
Joined: Sat Nov 24, 2007 6:48 am

Re: Unexpected result when printing spreadsheet

Post by Bill »

Take a look at Row 9. There is a date in columns A, B and I through AMG that possibly shouldn't be there. Either delete those dates before selecting Page Preview, or select only the cells you want to print before selecting Page Preview.
AOO 4.1.14 on Ubuntu MATE 22.04
Locked