[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards


At 14:36 25/12/2019 -0700, David S. Crampton wrote:
Here it is 9 years later.

I think the answer is much as was given in 2011!

I just encountered a need to have Sheet1 use Footer1 (Sheet1 prints in 3 pages). Then Sheet2 use Footer2 (another 3 pages). With focus on either Sheet1 or Sheet2 to set 'Format | Page | Footer ... ' changes the Footer to be the same in both Sheets. I worked around it but clumsy and error prone.

(You really ought to tell anyone hoping to help you what workaround you have found and consider error-prone.)

Headers and footer are properties of page styles. If you have the same page style for both of your sheets, changing the footer of that page style will obviously affect the pages produced by both sheets. All you need to do is to use a different page style for each of your two sheets (probably creating a suitable new page style yourself) and set appropriate footers in each.

The only difference I see between the behaviour with spreadsheets (Calc) rather than text (Writer) documents is that in text documents you can insert manual page breaks wherever you wish, whereas in spreadsheets you cannot insert them within sheets but an automatic possibility of a break of style occurs between every sheet.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Follow-Ups:
[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards"David S. Crampton" <david_crampton@ie2b.com>
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.