Hello guys, I’m having some problems with the VAR and STDEV function, when
executing these lines of code. The average is well calculated but the
remaining two return very low, unrealistic and equal values
(6.93018471335974E-310).
To add to a bad situation, I can’t execute the function CHISQINV as stated
in the second code box below. It gives out the error:
BASIC runtime error.
An exception occurred
Type: com.sun.star.lang.IllegalArgumentException
Message: .
Any help is deeply appreciated!
Thanks,
Rui
====================== CODE BLOCK 1 ======================oRange =
xSheet.getCellRangeByPosition(7, 1, 7, rangeLim)'Media (funciona)
average = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.AVERAGE)
print average'Variancia (ver)
variance = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.VAR)
print variance'StdDev (ver)
stdDev = oRange.computeFunction(com.sun.star.sheet.GeneralFunction.STDEV)
print stdDev
====================== CODE BLOCK 2 ======================
function CHISQINV (erro, degree) dim oFunction as variant
oFunction = createUnoService("com.sun.star.sheet.FunctionAccess")
dim aArgument(1 to 2) as variant
dim result as double aArgument(1)=erro
aArgument(2)=degree result = oFunction.callFunction("CHISQ.INV",
aArgument()) CHISQINV = resultend function
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
