1 message in org.openoffice.fr.prog[prog] Callfunction on JAVA and SUMPR...
FromSent OnAttachments
step...@free.frJun 22, 2005 3:04 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[prog] Callfunction on JAVA and SUMPRODUCTActions...
From:step...@free.fr (step@free.fr)
Date:Jun 22, 2005 3:04:10 am
List:org.openoffice.fr.prog

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: prog@fr.openoffice.org For additional commands, e-mail: prog@fr.openoffice.org