Issue 65574 - New Function: sheet number -> sheet name
Summary: New Function: sheet number -> sheet name
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-05-19 09:38 UTC by claudiadzm
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description claudiadzm 2006-05-19 09:38:39 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
Comment 1 frank 2006-05-19 13:59:09 UTC
one for requirements