new line in innerText not preserving when xml is opend in Excel -
12-20-2007
, 02: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 |