[Solved] Page layout changes that affect all Calc sheets

Discuss the spreadsheet application
Post Reply
glcarteraz
Posts: 1
Joined: Tue Dec 04, 2007 6:40 pm

[Solved] Page layout changes that affect all Calc sheets

Post by glcarteraz »

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.
Last edited by Hagar Delest on Wed Jul 30, 2008 9:51 am, edited 1 time in total.
Reason: tagged the thread as Solved.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: making page layout changes in Calc that affect all sheets

Post by Villeroy »

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
Post Reply