-
Type:
Sub-task
-
Status: Closed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: ODF 1.2 Part 2 CD 2
-
Fix Version/s: ODF 1.2 Part 2 CD 2
-
Component/s: OpenFormula
-
Labels:None
"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'.