WOResponse with single LF, without CR
WOResponse with single LF, without CR
- Subject: WOResponse with single LF, without CR
- From: "Sennikov, Dimitri" <email@hidden>
- Date: Fri, 11 Apr 2008 11:16:58 -0400
- Thread-topic: WOResponse with single LF, without CR
Hi,
I've come onto a problem with exporting .csv files for Excel. I have
certain data in a multi-line format. I want this data to stay multi-line
in Excel but what happens in reality is the cells in Excel display
squares instead of new line characters.
The cause of the problem is the Carriage Return (CR) character in the
CSV file. In appendToResponse I try to replace all "\r" with just empty
string but that has no effect whatsoever.
In essence, I want the following CSV file output:
Cell Title CRLF
"cell data1" CRLF
"multi-line LF
cell LF
data" CRLF
But what I get is the following:
Cell Title CRLF
"cell data1" CRLF
"multi-line CRLF
cell CRLF
data" CRLF
Has anybody dealt with this before, what is a possible solution or a
workaround? I have searched but couldn't find a solution if one is
possible. I'm not even sure what is putting the unneeded CRs in the
output (whether it's WebObjects, Web Server (Tomcat 5), or Internet
Explorer). I know that MAC likes just CRs, Unix just LFs and windows
CRLFs, but in this case it is MS Excel that I'm after.
Thanks,
Dmitri Sennikov
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden