Issue 19556 - csv export & import of multi-line cells fails & is not compatible with ms excel
Summary: csv export & import of multi-line cells fails & is not compatible with ms excel
Status: CLOSED DUPLICATE of issue 834
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-14 10:07 UTC by gregjohnson
Modified: 2003-09-15 09:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gregjohnson 2003-09-14 10:07:28 UTC 
to reproduce export defect:
* enter a multi-line cell (eg aaa^\nbbb^\nccc)
* export as csv (eg x.csv)
* cell is exported as "aaa bbb ccc"

to reproduce import defect:
* create a file x.csv with a field "aaa\nbbb\nccc" (including the " marks)
* open x.csv
* imports as cell1 aaa, cell2 bbb, cell3 ccc" (nb the trailing ")
arguably, csv need not support multi line fields, but ms excel does and as a
consequence, Ooo cannot open csv files with multi-line fields that have been
written by excel
Comment 1 frank 2003-09-15 09:24:16 UTC 
Hi Greg,

this is a double to Issue 834.

So I have to close it as double.

Frank

*** This issue has been marked as a duplicate of 834 ***
Comment 2 frank 2003-09-15 09:24:34 UTC 
closed double
Comment 3 gregjohnson 2003-09-15 09:29:57 UTC 
apolgies for not finding issue 834