I've had this problem for some time but it was highlighted today by my
experience with a working function posted in the forum (
http://www.oooforum.org/forum/viewtopic.phtml?p=203524#203524 ):
Function foo(MyRange)
da =
ThisComponent.CurrentController.ActiveSheet.getCellRangeByName(MyRange).getDataArray()
For I = lBound(da) to uBound(da)
x = da(I)
Tot = Tot + x(0)
Next
foo = Tot / (uBound(da) + 1)
End Function
I entered a formula in the correct format in the spreadsheet, viz:
=foo(B1:B5) which generated two identical error messages "Basic runtime
error. Object variable not set". The line raising the error is the
first line in the script.
I have had this problem ever since I began trying to construct functions
for use in the spreadsheet. Could it be some problem with my user
settings or the OpenOffice version I am using - Linux 2.0.2 en_GB?
Regards, TerryJ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
