HighTechTalks DotNet Forums  

new line in innerText not preserving when xml is opend in Excel

Dotnet XML microsoft.public.dotnet.xml


Discuss new line in innerText not preserving when xml is opend in Excel in the Dotnet XML forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Supriya
 
Posts: n/a

Default new line in innerText not preserving when xml is opend in Excel - 12-20-2007 , 03:51 AM






Hi All,
I need to set innerText of a cell element like "line1\nline2" in XML.
When I open the xml file in Excel new line in that cell is missing.
When I insert new line in cell in Excel using ALT + ENTER and save
it is creating innerText "line1 line2".When I tried to set same value to
innerText in XML from code,
it is converting to "line1\nline2".So I am unable to get the correct cell
information when I open in Excel.
Please help me, how to set new line in the middle of innerText sothat I can
see the line when I open in Excel.
Thanks in advance.
Supriya



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.