On Sunday 23 January 2005 22:06, Brian wrote:
> Jerry Westrick wrote:
> >Dear Users:
> >
> >Is it just me or does OO not accept Multi-line Cells in CSVs?
> >
> >Example:
> >
> >comp_1;mlshist;"1 MLS entries found:
> >The comparable sold for 180000 on 1997-07-30 (mlsnum: 122293)"
> >
> >The above 2 lines, should be give 1 row with 3 cells, the last cell having
> > 2 lines...
> >
> >Unfortunately, OO gives me 2 rows.
>
> Hi Jerry,
> If I make a new text doc with your data exactly as shown here (on two
> lines) then I get two lines in the spreadsheet.
> If I make the doc with one line only (as I would expect in the CSV file)
> and open it a a colon separated CSV(.txt) file I get only one line.
> Please post the CSV file to a website where we can check it's exact
> contents, or email me a copy of it direct - this list will strip
> attachments.
>

ahh brian..  If you notice, that the Quote value has no ending on line 1, 
therefore the value includes the <cr>, and should thefore insert the <cr> 
into the 3rd cell as if you entered <ctrl><cr> giving you 2 lines in Cell 3 
instead of a second row.

The 2 lines where quoted verbatim, just take of the >> at the begining...
Jerry
P.S. Excell does just that...
> Brian


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to