The nearest feature to what you're looking for is the CELL function.
=CELL("SHEET";Sheet1.A1) returns 1 for example.All we are missing is the mapping from sheet number to sheet name that would automatically update when thesheet is renamed. On 9/22/05, Megan Vowell <[EMAIL PROTECTED]> wrote: > I am using Oo 1.1.4 and need help on a spreadsheet. > > I would like to set up multiple pages in a template. How do I make the > cell value the name of the sheet? In other words, I want it set up so > that when I rename the sheet, it fills in the appropriate cell on the > individual's page as well as on the front summary sheet. > > Thanks, > > Meg > > > > > ___________________________________________________________ > $0 Web Hosting with up to 200MB web space, 1000 MB Transfer > 10 Personalized POP and Web E-mail Accounts, and much more. > Signup at www.doteasy.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
