To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73094
User jsc changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Jan 9 08:02:11 -0800
2007 -------
Using getActiveSheet won't work anyway in your scenario if you would have more
than one sheet. The function is calculated during the load process. What should
active sheet be in this case?
Be careful with getCurrentComponent, getCurrentControler or for example
getActiveSheet. Think about the semantic of these functions ;-)
Solution:
change your macro to
function GetSheetName(sheetnumber as Integer)
msgbox sheetnumber
GetSheetName = ThisComponent.getSheets().getByIndex(sheetnumber-1).Name
end function
use a parameter to reference the sheet where you call the function!!! In the
document you can simply use
=getSheetName(Sheet(a1))
I hope this helps
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
