Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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


Did you try
menu:File>Page Preview
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.



Marc Paré Supports OpenDocument Formats (ODF) Supports

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.