Apache OpenOffice (AOO) Bugzilla – Issue 22625
com.sun.star.sheet.GeneralFunction VAR VARP STDEVP
Last modified: 2013-07-30 02:18:30 UTC
com.sun.star.sheet.GeneralFunction.X where X= VAR, VARP, STDEVP functions return 2.637E-307 when applied to a properly defined range. In contrast AVERAGE, SUM, MAX, MIN work. see http://www.oooforum.org/forum/viewtopic.php?t=3942&highlight=
forwarding to responsible developer
SW->SBA: I suppose you have a better chance to fix this than SBA ;-)
Grrr. this has to be read SW->SAB
SW->SAB: The problem is the output of XSheetOperation.computeFunction() this works well for the arguments com.sun.star.sheet.GeneralFunction.MAX com.sun.star.sheet.GeneralFunction.MIN com.sun.star.sheet.GeneralFunction.AVERAGE com.sun.star.sheet.GeneralFunction.SUM but returns a value pretty close to 0 for com.sun.star.sheet.GeneralFunction.VAR com.sun.star.sheet.GeneralFunction.VARP com.sun.star.sheet.GeneralFunction.STDEVP I'll attach a bugdoc that demonstrates this behaviour.
Created attachment 11891 [details] Bugdoc with macro attached, which demonstrates the behaviour
I take it
not possible for OOo 2.0 anymore => set to Office Later
*** Issue 101713 has been marked as a duplicate of this issue. ***
Reset assignee on issues not touched by assignee in more than 2000 days.