Tabname
From Apache OpenOffice Wiki
A well-known spreadsheet program has a formula that will return the name of the present tab: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255).
In Calc, the formula would be =MID(CELL("filename");FIND("$";CELL("filename"))+1;255). If part of a spreadsheet originally written in the other program, the formula doesn't get translated and must be edited.
It would sure be nice if Calc had a built-in function that would do the same thing (which the other program does not have. Any takers?
Stoopidme 14:13, 23 August 2008 (CEST)