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

From
Eike Rathke <>
Date
2007-02-19T23:16:29+00:00
ID
Thread
Re: [office-formula] Proposal: array results inline for test cases
Hi David,

On Monday, 2007-02-19 17:50:19 -0500, David A. Wheeler wrote:

> > Would the tool handle hard line breaks (entered with
> > shift+return) within the cell?
> 
> It doesn't handle EITHER approach yet.  But I don't see why it can't handle that, when modified to do so.  I can't think of a case where hard line breaks are needed for array returns; do you have one in mind?

Not as part of array data, just for a better overview. Take a look at
the LINEST return and stuff that into one cell, only on one line. It
would be better to insert a line break between rows, such that it
becomes

{
11; 21; 31|
12; 22; 32|
13; 23|
...}


  Eike

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