Displaying Carriage Return || Line Feed
-
Our app transforms xml data with xsl into html. I use (space, carriage return, line feed) to separate data on different lines that eventually is displayed on an excel spreadsheet. After each line is a square that is undesirable. Can anyone please tell me how to get rid of this square or how to display a line feed without it? Thanks, Lilian
-
Our app transforms xml data with xsl into html. I use (space, carriage return, line feed) to separate data on different lines that eventually is displayed on an excel spreadsheet. After each line is a square that is undesirable. Can anyone please tell me how to get rid of this square or how to display a line feed without it? Thanks, Lilian
-
this is realted to either: &nbap;* your character encoding in your xslt
* or the fact that excel is not recognising the line feed - try missing out the line feed. hope this helps.After I retrieve the transformed CComBSTR that is produced with XML and xsl, I wrote code to parse through the wstring to replace the CRLF with a \n. I guess Excel didn't like what xsl did to it. Lilian