[users] 1.9.95 script calling Calc built-in functions

[Jahn, Ray \(R.\)]

Hi:

OS = MS Windows 2000

in OO Basic inside OO Calc 1.9.95
writedbginfo( sheet_object ) indicates no
FunctionAccess  service
XFunctionAccess interface

in DeveloperGuide, version 2.0
8.4.2 Function Handling
com.sun.star.sheet.FunctionAccess  service
com.sun.star.sheet.XFunctionAccess interface

I am at a loss as how to call the built-in spreadsheet functions from scripts 
in OO 1.9.95, given the apparent conflict above.  An equivalent example in MS 
Excel VBA is given below.  Please advise if there is a better documentation to 
follow.

Thanks.

Ray

 --- MS Excel VBA equivalent example

dim answer as double
answer = Application.min( num_1, cellobj_2, rangeobj_3, num_4 )

' same as the following
' answer = Application.WorksheetFunction.min( num_1, cellobj_2, rangeobj_3, 
num_4 )

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]