[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]