Issue 22625

Summary: com.sun.star.sheet.GeneralFunction VAR VARP STDEVP
Product: App Dev Reporter: dfrench <dfrench>
Component: apiAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Bugdoc with macro attached, which demonstrates the behaviour none

Description dfrench 2003-11-19 08:47:05 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=
Comment 1 ooo 2003-11-19 13:47:13 UTC 
forwarding to responsible developer
Comment 2 stephan.wunderlich 2003-12-11 14:14:23 UTC 
SW->SBA: I suppose you have a better chance to fix this than SBA ;-)
Comment 3 stephan.wunderlich 2003-12-11 14:16:05 UTC 
Grrr. this has to be read SW->SAB
Comment 4 stephan.wunderlich 2003-12-11 14:47:01 UTC 
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.
Comment 5 stephan.wunderlich 2003-12-11 14:48:22 UTC 
Created attachment 11891 [details]
Bugdoc with macro attached, which demonstrates the behaviour
Comment 6 sascha.ballach 2003-12-11 17:43:53 UTC 
I take it
Comment 7 ooo 2004-12-01 10:20:26 UTC 
not possible for OOo 2.0 anymore => set to Office Later
Comment 8 Regina Henschel 2009-05-10 21:32:00 UTC 
*** Issue 101713 has been marked as a duplicate of this issue. ***
Comment 9 Rob Weir 2013-07-30 02:18:30 UTC 
Reset assignee on issues not touched by assignee in more than 2000 days.