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

[Eike Rathke <erack@sun.com>]

Hi David,

On Sunday, 2007-02-18 21:33:53 -0500, David A. Wheeler wrote:

> I propose that in such cases, the "Result" column should be in the form of an inline array, e.g., { 1; 2; 3 | 4 ; 5 ; 6}.  I think it's important that we be consistent about the format, so that the tool can handle it.

Generally I'm fine with that. However, it may get a bit confusing in
case the function returns larger arrays as is the case with LINEST.
There the current approach using separated cells gives a better
overview. Would the tool handle hard line breaks (entered with
shift+return) within the cell?

  Eike

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