From Apache OpenOffice Wiki
Jump to: navigation, search
This page is a short article on something that should have a lot more information written on it. If you know anything else about it, you are STRONGLY encouraged to add the information in. If you are unsure of proper formatting or style, add it to the talk page or this page itself as you think best and others will help.

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 08:15, 23 August 2008 (EST)

Personal tools