Issue 22625 - com.sun.star.sheet.GeneralFunction VAR VARP STDEVP
Summary: com.sun.star.sheet.GeneralFunction VAR VARP STDEVP
Status: ACCEPTED
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows 2000
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 101713 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-11-19 08:47 UTC by dfrench
Modified: 2013-07-30 02:18 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Bugdoc with macro attached, which demonstrates the behaviour (6.35 KB, application/octet-stream)
2003-12-11 14:48 UTC, stephan.wunderlich
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.