C.
PS: In Excel / VBA this can be achived by
- Code: Select all Expand viewCollapse view
Application.Caller
Application.Caller
Villeroy wrote:No way. Spreadsheet functions calculate nothing but cell values.
http://api.openoffice.org/docs/common/r ... AddIn.html
Function Test
Test = ThisComponent.CurrentController.ActiveSheet.Name
End Function
Function Tester(arg1, arg2)
On Error GoTo EH
Tester = arg1^0.5
exit function
EH:
Print "This cell caused an error: " & arg2
End function
=TESTER(D3; CELL("ADDRESS";B5))
Villeroy wrote:There is nothing like Application.caller and the documentation proves my point.
Function ViewData
ViewData = ThisComponent.CurrentController.viewData
End Function
FJCC wrote:The example of ROW() is not relevant, I think, because ROW() requires an argument.
Function trigger(a(),s,r,c)
ThisCell= getSheetCell(s,r,c)
msgbox "something in the referenced range of "& ThisCell.AbsoluteName &" did happen"
End Function
Users browsing this forum: No registered users and 2 guests