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
Appending new Elements with respect to XSI:TYPE 0
Line break in cell 2
How to get NewLine in a cell? 4
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Line break from vLookup 1
How make long string in a cell become text line by line in same cell? 6
Insert line in a text file between 3rd and 4th lines 3

Top