[Solved] Page layout changes that affect all Calc sheets

Discuss the spreadsheet application

[Solved] Page layout changes that affect all Calc sheets

Postby glcarteraz » 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.
Last edited by Hagar Delest on Wed Jul 30, 2008 9:51 am, edited 1 time in total.
Reason: tagged the thread as Solved.
glcarteraz
 
Posts: 1
Joined: Tue Dec 04, 2007 6:40 pm

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

Postby Villeroy » Tue Dec 04, 2007 11:49 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 35 guests