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.
[Solved] Page layout changes that affect all Calc sheets
-
- Posts: 1
- Joined: Tue Dec 04, 2007 6:40 pm
[Solved] Page layout changes that affect all Calc sheets
Last edited by Hagar Delest on Wed Jul 30, 2008 9:51 am, edited 1 time in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
Re: making page layout changes in Calc that affect all sheets
Call the stylist (F11) and change the underlying page style.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice