• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
WOResponse with single LF, without CR
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References: 
 >Custom Main Component (From: "Daniele Corti" <email@hidden>)
 >Re: Custom Main Component (From: Stefan Klein <email@hidden>)
 >Re: Custom Main Component (From: Francis Labrie <email@hidden>)
 >Re: Custom Main Component (From: Mike Schrag <email@hidden>)
 >Re: Custom Main Component (From: Francis Labrie <email@hidden>)
 >Re: Custom Main Component (From: Mike Schrag <email@hidden>)

  • Prev by Date: Re: Custom Main Component
  • Next by Date: Re: JavaClient RMI and Validation
  • Previous by thread: Re: Custom Main Component
  • Next by thread: Re: Custom Main Component
  • Index(es):
    • Date
    • Thread