Issue 102538

Summary: cell multiline text exporting to MS XML issue
Product: Calc Reporter: lunter <lunter>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, raal
Version: 4.1.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
source
none
solution none

Description lunter 2009-06-05 11:55:11 UTC
1. Open untitled1.ods (from attachement) in Calc 3.1
2. Save it as 'MS Excel 2003 XML' format
3. Open untitled1.xml with MS Office Excel (I have 2003 version)
4. Watch the first cell.
5. Bug: text is one-line, but should be multi-line.

6. Solution: encode new-line and cariage-return [chr(10) and chr(13)] 
characters in XML files using numeric character references (NRC) [&#10; and 
&#13;].
Comment 1 lunter 2009-06-05 11:57:22 UTC
Created attachment 62793 [details]
source
Comment 2 lunter 2009-06-05 12:11:34 UTC
Created attachment 62795 [details]
solution
Comment 3 raal 2009-10-17 21:22:50 UTC
I can confirm within version OOO320m2.
Comment 4 Edwin Sharp 2013-11-27 19:35:48 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7