Jerry Westrick wrote:

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

Been playing with Excel (Office XP under Win98SE).
Set up the cells as you stated - two lines in the third cell, alt-enter to produce the carriage return inside the third cell - Cells were A1, A2, A3.
Saved as tab delimited text file, and as CSV.
In Excel ...
Opened CSV file - A3 had only the first line, B1 had the second line from A3
Opened tab delimited text - same as CSV
In Calc ...
Same as with Excel.


Excel won't reconstitute the data for me from CSV or tab delimited
I've never exported from Excel using comma delimiters before - can't find how to do it - and excel (XP) treats commas the same as CSV and tab for me, same as Calc
Opening the Excel file in Calc works ok.
My conclusion: both Excel and Calc have their problems with multiline cells - they don'e save/recognise the <alt><enter> or <ctrl><enter> characters.
A bug report or enhancement request would probably be appropriate


Back to you ..................

Brian

--
OpenOffice Suite 1.1.4 :  Firefox Browser 1.0 : Thunderbird Email 1.0


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



Reply via email to