Re: Printing Open Office spreadsheet
On Thu, 4 Apr 2019 10:57:26 -0400 Todd Bontrager wrote: > Hi, I'm trying to help friends of mine print their tax document in > spreadsheet, they can print other things but nothing in OpenOffice. Is > there a setting somewhere in OpenOffice where the printer needs to be > turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd It has been reported on the OO-Forum that sometimes OO cannot see the printer after installation; whether this is due to 64 bit printer drivers not seeing the 32 bit application of OO is not known. It can help to uninstall the existing printer driver, verify that one has the latest drivers (check with printer manufacturer's site - don't rely on Windows to do this) and reinstall them. A workaround is to export the spreadsheet from OO in PDF format (/File /Export as PDF) and print the PDF file from whatever PDF viewer is installed on the computer. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing Open Office spreadsheet
At 15:14 04/04/2019 -0700, Girvin Herr wrote: Do you have a Print Range specified? OpenOffice Calc will default to printing nothing if no print range is set: Format > Print Ranges > Edit You were right to identify that print ranges could be the poster's problem, but in the interest of not confusing the masses, may I please correct this? If there is no print range defined anywhere in a spreadsheet, OpenOffice will default to printing everything (not nothing). And if under "Print range" you see "none", then change it to "Entire sheet". You have no need to do that if there are no print ranges set on any sheet. Note that the print range setting defaults to "none" on all sheets (tabs), so it needs to be changed on all sheets needing to be printed. Again, that is not so: if there are no print ranges set anywhere, everything will print. The confusion arises only if there *is* a print range set somewhere. The effect of a print range or ranges is to determine that only material in a range is printed. So setting a print range on one sheet - perhaps to suppress the printing of some material on that sheet - will mean that everything on other sheets will no longer be included. (Users sometimes find this surprising.) If you need a print range anywhere, you need print ranges on all other sheets that you require to be printed. But the default of no print ranges anywhere prints everything and causes no problems. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing Open Office spreadsheet
Forwarded to OP as he is not subscribed On 05/04/2019 00:14, Girvin Herr wrote: Todd, Do you have a Print Range specified? OpenOffice Calc will default to printing nothing if no print range is set: Format > Print Ranges > Edit And if under "Print range" you see "none", then change it to "Entire sheet". You can change the rows and columns to repeat, if needed. But they will not prevent printing if empty and you probably don't want that for printing a form. Note that the print range setting defaults to "none" on all sheets (tabs), so it needs to be changed on all sheets needing to be printed. Changing it on one sheet will not change it for other sheets in the file. Also, make sure the printer is set: File > Printer settings and select the printer "Name" from the list. If you got the file from someone else, the default printer may be their printer name, not yours, so the print would go to a non-existent printer on your system. The selected printer is usually saved when the file is saved. HTH. Girvin On 4/4/19 7:57 AM, Todd Bontrager wrote: Hi, I'm trying to help friends of mine print their tax document in spreadsheet, they can print other things but nothing in OpenOffice. Is there a setting somewhere in OpenOffice where the printer needs to be turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing Open Office spreadsheet
Forwarded to OP as he is not subscribed On 04/04/2019 23:58, Alan B wrote: In your spreadsheet try the menu option Format > Print Ranges > Clear. This is just in case a print range was inadvertently specified. Then, File > Print..., make certain the desired printer is selected and click Print. That should be all that's needed. On Thu, Apr 4, 2019 at 11:50 AM Todd Bontrager wrote: Hi, I'm trying to help friends of mine print their tax document in spreadsheet, they can print other things but nothing in OpenOffice. Is there a setting somewhere in OpenOffice where the printer needs to be turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Printing Open Office spreadsheet
Todd, Do you have a Print Range specified? OpenOffice Calc will default to printing nothing if no print range is set: Format > Print Ranges > Edit And if under "Print range" you see "none", then change it to "Entire sheet". You can change the rows and columns to repeat, if needed. But they will not prevent printing if empty and you probably don't want that for printing a form. Note that the print range setting defaults to "none" on all sheets (tabs), so it needs to be changed on all sheets needing to be printed. Changing it on one sheet will not change it for other sheets in the file. Also, make sure the printer is set: File > Printer settings and select the printer "Name" from the list. If you got the file from someone else, the default printer may be their printer name, not yours, so the print would go to a non-existent printer on your system. The selected printer is usually saved when the file is saved. HTH. Girvin On 4/4/19 7:57 AM, Todd Bontrager wrote: Hi, I'm trying to help friends of mine print their tax document in spreadsheet, they can print other things but nothing in OpenOffice. Is there a setting somewhere in OpenOffice where the printer needs to be turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Printing Open Office spreadsheet
Hi, I'm trying to help friends of mine print their tax document in spreadsheet, they can print other things but nothing in OpenOffice. Is there a setting somewhere in OpenOffice where the printer needs to be turned on? They are using a Dell desktop and a Xerox printer. Thanks, Todd