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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
