Have a spreadsheet file with a dozen sheets each with a different “footer” which over the past years worked fine. Now the footers of some when changed result in some of the others reflecting that change. I want each to be onto itself. As mentioned by a responder, I spent time looking at all the Page Style write up to finally discover the issue. Turns out LO creates custom page styles and now I need to find how to force each sheet to be independent of the others when I copy a sheet to use as a template creating a new sheet in the same spreadsheet file. Going Menu Bar → Format → Page → Organizer find various PageStyle_{name of sheet} as the LO created custom style. So if I copy that sheet to make a new one, now a change to one’s footer results in the other also changed. Argh!!! All things tried have as yet to discover how to defeat this linkage.
Please upload an ODF type sample file here. Then we will able to examine the applied page styles, and other settings. You can delete the sensitive content from the cells, because the relevant parts are the footers on the sheets - in this case.
As always, page footer is a property of a page style. When you change a footer, you are changing its page style. And so, the change applies to all sheets using that page style. If your change applies to several sheets, but not some others, that means exactly that those sheets 1, 2, 3, and 5 all use the same page style, while 4 and 6 use another, and sheet 7-12 use individual page styles each.
THIS IS NOT A BUG; AT LEAST NOT DIRECTLY, its a problem with a complicated feature! On top of that and as the original poster, I am NOT ABLE to delete this now misdirecting post which is a form organizer created problem.
Here is the fix:
When ever making a new sheet in a file via a copy to preserve the general layout, the page/layout style of the old will follow the new. So any changes in the style/layout on the new WILL GO BACK AND FU YOUR ORIGINAL AND ALL SUBSEQUENT SHEETS! So before making ANY CHANGES, you must do the following to establish the new sheet stands alone:
Menu → View → Styles → Page Layouts (upper left icons Cell vs Page) and see what is there.
On the bottom status bar is displayed the current sheet’s page layout or you can pull it up by doing a Menu → Format → Style → Organizer to see the name (don’t change anything here!).
If the desired style is not displayed in the M-V-S-P listing, select which is closest to your desire and then “right-click” for a pull down menu to select New-Modify-Hide-Show-Delete choosing New. On the fill in page provided, delete the Organizer name and put in what you want followed by selecting OK.
Go down the list to find the new layout you just named and “double-left-click” on it. You will see the status bar change to the new layout.
At this point, you are safe to make formatting changes which will only affect the new and just created page layout.
Argh!!! Would have been so much easier to make it a choice to name a layout to then use multiple places. This cost me 10 hours of searching, testing, posting, etc. - colossal waste!