[Solved] Page layout changes that affect all Calc sheets
Posted: Tue Dec 04, 2007 10:19 pm
I rec'd an OO.org Calc workbook from someone yesterday that had 10 sheets. I wanted to change the margins for all sheets, plus add a specific footer and header config to all sheets. I looked around and thought, by selecting all of the sheets (right-click>Select All) that any changes I made would be applied to all sheets. This did not work. I searched long and hard on the web for help and nothing came up.
This morning I created a multiple-sheet workbook to test this and, lo and behold, when I did Select All and changed the Page Layout, the changes were applied to all of the sheets. So why didn't it work the first time? I tried very hard to find an option that turned this on/off and couldn't see what could have done it.
This morning I created a multiple-sheet workbook to test this and, lo and behold, when I did Select All and changed the Page Layout, the changes were applied to all of the sheets. So why didn't it work the first time? I tried very hard to find an option that turned this on/off and couldn't see what could have done it.