[OASIS Issue Tracker] Commented: (OFFICE-734) Public Comment:Statistical SUMMARY() function

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15247#action_15247 ] 

Andreas Guelzow  commented on OFFICE-734:
-----------------------------------------

I believe the author of the comment confuses missing application features with missing ODF functions.

It is of course useful to have a mechanism to create a descriptive statistical output for a dataset. 

Excel has a menu item that creates a one-time snapshot of the data. As the comment author points out this has the drawback of not changing with the data.

We can contrast this with Gnumeric which also has a menu item but by using it the user effectively enters an appropriate selection of functions calls. This is much more flexible that a summary function that would need various options to be adjustable tot he needs of the user, and that once entered would be rather opaque since it would virtully impossible to tell that the output in the third cell of such an array function is the mean.

> Public Comment: Statistical SUMMARY() function
> ----------------------------------------------
>
>                 Key: OFFICE-734
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-734
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: OpenFormula
>            Reporter: Robert Weir 
>             Fix For: ODF-Next
>
>
> Copied from office-comment list
> Original author: Leonard Mada <discoleo@gmx.net> 
> Original date: 2 Jun 2008 22:27:09 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200806/msg00003.html

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira