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

On Tuesday, 2007-02-20 10:40:22 +0100, Eike Rathke 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.

Excel sets the #N/A error value in those elements. That would probably
be the way to go for apps. OOo setting the #N/A string dates back to the
times when individual error values for array elements weren't
implemented.

  Eike

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