Difference between revisions of "Tabname"
From Apache OpenOffice Wiki
(New function: tabName()) |
|||
| Line 1: | Line 1: | ||
| − | A well-known spreadsheet program has a formula that will return the name of the present tab: | + | A well-known spreadsheet program has a formula that will return the name of the present tab: '''<font color="blue">=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)</font>.''' |
| − | '''=MID(CELL("filename") | + | In Calc, the formula would be '''<font color="blue">=MID(CELL("filename");FIND("$";CELL("filename"))+1;255)</font>.''' If part of a spreadsheet originally written in the other program, the formula doesn't get translated and must be edited. |
| − | It would be | + | 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? |
| − | [[User:Stoopidme|Stoopidme]] | + | [[User:Stoopidme|Stoopidme]] 14:13, 23 August 2008 (CEST) |
Revision as of 12:13, 23 August 2008
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)
