Re: [libreoffice-users] Calc- print specific pages...but what are the page numbers?

At 08:34 28/04/2016 -0400, Craig Noname wrote:
> On a single LO Calc spreadsheet file that I have there are many 
> pages on different sheets that need to be printed but I'd like to 
> exclude specific pages. That's fine and well but I have no idea what 
> the sheet page numbers are. What should I do?

It's difficult to see how you can know that some *pages* are not 
required unless you have a clear idea of the page structure. In this 
case, you would know what pages these were.

There are two ways to think of this, I think:

o Set print ranges. Go to Format | Print Ranges > | Define and Format 
| Print Ranges > | Edit... and mark all the material that you need to 
print. Note that any print range set anywhere in your spreadsheet 
will suppress any material not so marked, even on other sheets.

o First control the page structure of your printed document using 
breaks. Go to Insert | Manual Break > | Row Break and Insert | Manual 
Break > | Column Break to do this. Then go to View | Page Break 
Preview to display the relevant page numbers to print.

You may also find the scaling facilities helpful - at Format | 
Page... | Sheet | Scale | Scaling mode.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted