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

Hi :)
I've always used Andreas' method.  When you get back to the spreadsheet it
then starts showing a slightly darker line to show the border of the
printed pages.

I suspect that the colour of the page border (non-printing character type
of thing) could be changed in

Tools - Options - Appearance - Spreadsheet - "Automatic page breaks"

Then it's a case of adjusting the width of the columns to force the right
columns to fit.  I often have empty tiny thin columns to separate out
important columns such as sub-totals or end-of-quarter or whatever and
often use those at the edges of pages too so that it's easier for me to
adjust if the file needs to be printed from a different machine or onto a
different printer.


It hadn't occurred to me to use Writer or Draw to view the spreadsheet.  I
can imagine a few potential problems that might or might not even happen
anyway.  It sounds well worth experimenting with as it could make things
even easier.

Regards from
Tom :)



On 2 November 2014 20:46, Marc Paré <marc@marcpare.com> wrote:

> Hi everyone,
>
> Le 2014-11-02 15:27, Andreas Säger a écrit :
>
> > Am 02.11.2014 um 15:51 schrieb Marc Paré:
> >
> > > Is there a way to have the sheets show as pages rather than just a
> > > series of unlimited rows and columns?
> > >
> > > Thanks for any help.
> > >
> > > Marc
> > Did you try
> > menu:File>Page Preview
> > and
> > menu:View>Page Layout
> > ?
> I am just playing around with Page-Preview and Layout as well as the
> suggested option of using Writer. While both have their advantages and
> disadvantages, as someone pointed out to me offline, the whole process can
> be a little of a pain to get right.
>
> I am most likely going to go with the page setup from Calc without Writer
> as I would like to later pass along just one file to other music groups so
> that they can also make use of the file.
>
> In the process, it will force me to take a closer look at how Calc can
> work in setting up page layouts on paper.
>
> Sigh, if only we could do away with paper prints!
>
> Thanks for the help, I'll keep you posted on my end product.
>
> Cheers,
>
> Marc
>
> --
> Marc Paré
> Marc@MarcPare.com
> http://www.parEntreprise.com
> parEntreprise.com Supports OpenDocument Formats (ODF)
> parEntreprise.com Supports http://www.LibreOffice.org
>
>
> --
> 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

-- 
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