Hello,
I have a problem to call function SUMPRODUCT .
I used :
Object aFuncAddIn =
xServiceManager.createInstanceWithContext("com.sun.star.sheet.AddIn",
oooRef.getContext());
com.sun.star.sheet.XAddIn xFuncAddIn = (com.sun.star.sheet.XAddIn)
UnoRuntime.queryInterface(XAddIn.class, aFuncAddIn);
Object[] oMatrice = new Object[1];
oMatrice[0] = "'2004'.D129:D139";
Object aResultSommeProd = xFuncAcc.callFunction("SUMPRODUCT", oMatrice);
System.out.println("SUMPRODUCT ="+((Double) aResultSommeProd).doubleValue());
The value is always 0.0 .
It is the good parameters?
Thank you
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
