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+unsubscr...@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

Reply via email to