
Type: Subtask

Status: Closed

Priority: Major

Resolution: Fixed

Affects Version/s: ODF 1.2 Part 2 CD 1

Fix Version/s: ODF 1.2 Part 2 CD 1

Component/s: OpenFormula

Labels:None

Proposal:

Resolution:
Broken out from issue OFFICE1170
"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.