Hi, while generating cell content I'd like to know how to code a line break in the cell data (datatype string). I'm using XML (Office XML + SpreadsheetML) to generate the Exel sheet and the .net framework 2.0 XML XML classes (XmlDocument, XmlNode, etc.).
I tried to code "
" but this unfurtunately resolves to "
" in the resulting file. So I tested to replace "
" with "
" (manually, after creating the file), but Excel doesn't recognize that as line feeds until (sic!) entering the cell an pressing <enter>. Then, excel does some conversion (but I didn't find any difference in the XML files cell data afterwards) and then accepts the line feed - more sic! :-(
So I need to know how to do that the recommended way. Any idea???
Or any hint where to search such information?
Thx in advance, hd
|
Similar Threads
