Re: [libreoffice-users] Estimating size of page with Calc

At 09:51 02/11/2014 -0500, Marc Paré wrote:
> I am just creating a spreadsheet with 
> calculations of costs for some music projects. 
> It uses a series of sheet (4) and on the last 
> sheet I would like it to print off on a single 
> US Letter size page. I am curious, how does one 
> make sure that the printed lines all end up on one page?

o Select either all the material on the last 
sheet - or else the entire last sheet (by 
clicking the square where the row and column headers meet).
o Go to Format | Print Ranges > | Define.
o Go to Format | Page... | Sheet | Scale. For 
"Scaling mode" select "Fit print range(s) on 
number of pages" and for "Number of pages" select 1.

> It seems to me that Calc has a very poor WYSIWYG 
> representation of a printed page (unlike Writer 
> and Impress). [...] Is there a way to have the 
> sheets show as pages rather than just a series of unlimited rows and columns?

Have you tried both File | Page Preview and View 
| Page Break Preview? An alternative way to 
achieve the above is to use Page Break Preview 
and then to drag the page break appropriately - 
in this case to the foot of the data.

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