Creating a line break (newline) in a cell with SpreadsheetML

H

Harald

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newline character in XML cell reference when creating xlsx from XMLzipped files 1
Line break in cell 2
How to get NewLine in a cell? 4
Returning newline from a function to a cell 2
Generating Excel XML with embedded char(10)s 1
Add Newline(s) in a Cell 2
Exporting Data with Line Break 1
double blank lines in cells 2

Top