Apache OpenOffice (AOO) Bugzilla – Issue 102538
cell multiline text exporting to MS XML issue
Last modified: 2013-11-27 19:35:48 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) [ and ].
Created attachment 62793 [details] source
Created attachment 62795 [details] solution
I can confirm within version OOO320m2.
As given in description. AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7