Apache OpenOffice (AOO) Bugzilla – Issue 65574
New Function: sheet number -> sheet name
Last modified: 2013-08-07 15:12:27 UTC
Sometimes it would be helpfull to refer to a cell of a different sheet using the sheet number instead of the name of the sheet. Stefan Weigl published a user-function that can find the name of a sheet when submitting the number: function Tabellenname(Nummer as Integer) as String Tabellenname = thisComponent.Sheets(Nummer).Name end function It would be fine to have this function or something simular (perhaps an enhancement of the function CELL) as a standard-function in sCalc. cheers
one for requirements