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


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