| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multi Line text box | Excel Discussion (Misc queries) | |||
| Multi-Line Text In Same Cell | Excel Discussion (Misc queries) | |||
| Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
| How do I show only the last portion of text in a multi line cell? | Excel Worksheet Functions | |||
| how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
![Dag Johansen[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
