"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..."