At 10:30 11/08/2015 -0700, Ingrid Walther wrote:
I am creating documents using a template. Each worksheet I add, I insert using "insert sheet from file". That sheet is a template that I did not create. I am creating an inventory and each sheet is a list of what is in that numbered box. The problem I am having is that I can only print the first page (each worksheet is a single page). In print preview, only the first page is shown (page 1 of 1 only).

It's very likely that your first sheet has a print range defined, so that only some part of that sheet will actually print. Perhaps there are some parts used for intermediate calculations that do not need to appear in the printed version. If you have a print range defined anywhere in a document, this limits what happens for the entire document - so if your inserted sheets do not also have print ranges defined, nothing in them will print.

I have created several documents with dozens of worksheets in each. I'm in a bit of a panic to get them all printed. Can you offer any tips?

If my guess is correct, you have two options:

o Remove the print range from the sheet that is printing. To do this, go to Format | Print Ranges > | Remove. This will enable all sheets to print, but will allow parts of the first sheet to print that were not printing before and maybe you don't want.

o If you do need to restrict what prints from the first sheet using its print range, you will need to add similar print ranges to all the other sheets that you need to print. Do this for each sheet by selecting its relevant parts and then going to Format | Print Ranges > | Add.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to