Re: [office-formula] Proposal: array results inline for test cases

[Eike Rathke <erack@sun.com>]

Hi David,

On Monday, 2007-02-19 22:49:20 -0500, David A. Wheeler wrote:

> I really hope that LINEST won't be returning irregularly-shaped arrays :-).

No, it doesn't. The "empty" elements contain a #N/A string in OOo,
numeric value 0 in Gnumeric, I'll check later what they are in Excel.

> Seriously, let's make sure that the spec clarifies that apps won't necessarily support them.

We already defined in "4.7 Array" "that applications that claim to
support arrays support arrays with one or more columns, each with one or
more rows, where exactly the same number of columns are contained in
each row."

Should we explicitly state that arrays are always regularly shaped?

  Eike

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