Hello I'm stuck on what is probably a simple question. I have created a function in StarBasic to simplify the cell formulae that I'm writing in a Calc spreadsheet. I want to be able to call the standard sheet functions like LOG10, POWER, LOOKUP from my little BASIC function and I can't figure out if (or what) fully qualified name I need to prefix (in this example) Log10.
The example below returns the standard error dialog: "Sub-procedure or function procedure not defined" I'm suspecting that I may otherwise need to instantiate an object with some sort of global context that contains the Log10 etc functions and then call them as object methods but I've looked around api.openoffice.org and can't figure out which object contains Log10 and the others that I want to use. TIA Harry ----------------------------------- REM ***** BASIC ***** Sub Main End Sub Function get_e96(resistance) Dim exp as Long exp = Log10(resistance) REM Just return the exponent as a test for now get_e96 = exp End Function ----------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
