Ubuntu
openoffice.org package

in Openoffice calc is there a formular that will enter the sheet tab name into a cell?

Asked by Garth Gregory

how can I have a sheet tab name automatically entered in a cell. i.e. Like in B3 enter =D4 what ever is in D4 will be shown in B3, how can I make B3 display the sheet name?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
actionparsnip
Solved:
Last query:
Last reply:
Revision history for this message
Best actionparsnip (andrew-woodhead666) said : 		#1

http://www.oooforum.org/forum/viewtopic.phtml?t=4314

You'd have been better posting on the openoffice forum, its more specific to your issue

Revision history for this message
Garth Gregory (garth-gregory) said : 		#2

Fantastic the formula "=RIGHT(CELL("filename",A2),LEN(CELL("filename",A2))-FIND("#$",CELL("filename",A2))-1)" worked a treat. However it doesn't update if you change the sheet name. I resolved this by creating all the sheets I wanted, selected them all the entered the formula in the cell I wanted. This produced the corresponding sheet names on each sheet.

Thanks to all those who responded to my question. Well done!