Issue 19556

Summary:	csv export & import of multi-line cells fails & is not compatible with ms excel
Product:	Calc	Reporter:	gregjohnson <greg.johnson>
Component:	ui	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 RC4
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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