[ Thanks to Jane Walker for this link.
]
“What are some ways to create individual headers for OpenOffice
Calc spreadsheets?“Solveig Haugland: There are some possibilities
to work with; all of them might not work depending on your
spreadsheet.“You can base the header for the document on the sheet name.
This is the default. Right-click on the sheet name, choose Rename
and the spreadsheet will reflect the current sheet name on every
page…”