introduce line breaks in an excel cell using xslt.

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi All,
Im trying output an excel doc using xslt with line breaks for data in a single excel cell.
Example,
This is line 1 text This is line2 text
should be displayed in an excel cell as
This is line 1 text
This is line 2 text
I have tried using ascii char for Alt+enter etc. but all these are getting interpreted as a white space.
Somebody suggested using indent="yes" in the xslt output tag and I have tried this and had no luck.
Any help is highly appreciated.
Thanks again,
-renni
PS: im using MSoffice 2007

View the full article
 
Back
Top