OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


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



     [ http://tools.oasis-open.org/issues/browse/OFFICE-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-2247:
--------------------------------

          Component/s: OpenFormula
        Fix Version/s: ODF 1.2
    Affects Version/s: ODF 1.2
          Description: 
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.


> 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

        


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]