Probably not a new question - certainly a very basic one - but I am having difficulty with adding headers and footers to multi-sheet calc files (LO 7.1.7.2, Windows 10). I want the header/footer to have the same field eg sheet name etc on each sheet but expect to see different values, but that is not happening. I believe it has something to do with Page Style but every page/sheet is showing as a different style, and I do not know how to make sure that every sheet has the same style. I am obviously missing something simple!
Can you upload an ODF type sample file here?
In Styles manager (F11), double-clicking on a page style applies that style to the currently active sheet. So if you want, you may iterate over all the sheets in your document, and apply the style to each; or you may click on the first sheetâs tab, then shift-click on the last sheetâs tab (that selects all the sheets in between, inclusive), and apply the wanted style to all of them at once.
Is that what you were looking for?
The situation with different print styles on different sheets is very common when opening files in Microsoft Excel formats. In this case, each sheet has its own style called PageStyle_SheetName.
1 Like
My thanks to all the people who were kind enough to offer help. Mike Kaganski has produced a solution that works, and I am very pleased, and grateful.
Part of the problem I was having was a lack of familiarity with the concept of Styles, especially in Calc. It also doesnât help that the names âsheetâ and âtabâ are sometimes used almost interchangeably, but have different meanings in Calc from Excel. (In Calc the spreadsheet is a document which consists of separate sheets, whereas I seem to recall that in Excel the whole spreadsheet is a sheet which is divided into separate tabs. But I expect you all know that!).
In this case, I had converted a pdf to Excel first, then saved it as *.odf because I couldnât find a way of converting it directly from pdf to *.ods format.
In Excel, a workbook contains worksheets.
In Calc, a spreadsheet document contains spreadsheets.
The essence is the same.
Well, âspreadsheetâ is used as a short name for âspreadsheet documentâ (see e.g. out help menu), and I donât recall use of âspreadsheetâ to call what is usually called âsheetsâ.
Great catch!
(Still I believe my comment holds - with usual âit has specifics in programmersâ slangâ)
Just goes to demonstrate (at least) 2 things:
- I am so content with LO Calc that I havenât used Excel for years and so my recollections are not 100% reliable
- Nothing is as much fun as watching a good argument between techies!
1 Like