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


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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

Subject: Proposing a new parameter type: ForceArray


To be able to specify functional behavior we need a different parameter
type for functions that force calculation of an argument into array
(non-scalar) calculation mode, which is different from the Array type we
already have, for example the parameters of SUMPRODUCT are of type


forces the calculation of ABS(A1:A3) into array mode, no implicit
intersection of the formula cell's position and the range A1:A3 is
constructed, and the entire 1x3 array result of ABS is passed to the
SUMPRODUCT function. There are several functions with this behavior,
I'll do the necessary changes in the spec and also will write a short
definition of that parameter type, this fits into the specification of
the general array (non-scalar) calculation mode.

I propose to name this parameter type ForceArray.

Anyone coming up with a better name for it?


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

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