Hello, please help me with the following: I want to determine the maximum value in an open office calc column using the OOoTools.pas interface. This as fas as I come:
Procedure FindMaximum(oMySheet : Variant);
Var
oFuncService : Variant;
Begin
oFuncService := CreateUnoService('com.sun.star.sheet.FunctionAccess');
ShowMessage(oFuncService.callFunction('MAX', VarArrayOf([10,20,50])));
End;
This works
Of course I want to fill in the values of a column like:
ShowMessage(oFuncService.callFunction('MAX', VarArrayOf([oMySheet.getCellRangeByName('K8:K10')])));
I get the message "com.star.lang.IllegalArgumentException:." why? Thanks