Multi-line cell text content saved in XML
 

Hi,

I want to generate a spreadsheet as an xml file and use
text on several lines in a cell.

This works:
<Data ss:Type="String"Line 1 Line 2</Data

This does not work:
<Data ss:Type="String"Line 1
Line 2</Data

Trouble is, the implementation of the XML DOM I'm using
(.Net System.Xml classes) will not render the first
representation, and loading the second one in Excel
ignores the newline character.

Is this an encoding problem?
Does anyone know of a work-around?

Many thanks to all who can provide input. Regards,

Dag Johansen
dagOystein . johansen @ sage . com