Proposing a new parameter type: ForceArray

[Eike Rathke <erack@sun.com>]

Hi,

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

=SUMPRODUCT(ABS(A1:A3))

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?

  Eike

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