[OASIS Issue Tracker] Commented: (OFFICE-2247) Array Functionscategorization

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

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

Dennis Hamilton commented on OFFICE-2247:
-----------------------------------------

For reasons beyond my ken, when I said, "Why is there no matrix multiplication?" I was staring at the list and MMULT was right in front of me.   

I support this change.

> Array Functions categorization
> ------------------------------
>
>                 Key: OFFICE-2247
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2247
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Broken out from issue OFFICE-1170
> "Array Functions"
> This categorisation seems to me to be inconsistent. Functions which return arrays are:
> MINVERSE, MMULT, MUNIT, TRANSPOSE, FREQUENCY, GROWTH, LINEST, LOGEST, TREND
> Functions which have ForceArray parameters are:
> MDETERM, MINVERSE, MMULT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, TTEST (and LOOKUP sometimes).
> This doesn't relate to the current functions listed as array functions.
> We have for instance SUMPRODUCT listed as an array function (but it's really a maths function) but MODE listed in stats (OK) - but both force array_mode calculation. Surely either both should be 'array functions' or both where they belong.
> Perhaps only matrix functions should be in this category: MINVERSE, MMULT, MUNIT, TRANSPOSE, MDETERM. It could then be called 'matrix functions'.
> TODO: check what we have changed there already and what's left to do, if any. Certainly not all functions that have ForceArray parameters or return arrays belong into the Array Functions category just because they do so.

-- 
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