[ http://jira.codehaus.org/browse/DISPL-107?page=comments#action_49350 ]
Ray Tsang commented on DISPL-107:
---------------------------------
I am experiencing the same issue. The exported file is indeed UTF8 encoded,
but Excel does not open it correctly when opened directly (through the browser
or by double clicking). If you start Excel first, then open the file through
"Open File" operation, it would detect the encoding correctly. Moreover, if
you resave the file from Excel as tab delimited file again, it would open
correctly in the future.
Turns out, when saving Tab-delimited file from Excel, it does not save w/ the
surrounding quotes (").
> Excel and Text exports use Windows Latin-1 encoding
> ---------------------------------------------------
>
> Key: DISPL-107
> URL: http://jira.codehaus.org/browse/DISPL-107
> Project: DisplayTag
> Type: Bug
> Components: Export
> Versions: 1.0 RC2
> Reporter: J. Patterson Waltz III
> Assignee: fabrizio giustina
> Priority: Minor
>
>
> Data coming out of my UTF-8 format Postgres database appears correctly in
> displaytag tables on webpages, but when I request an export in Excel or text
> format, all non ASCII characters are garbled. I am using the Mac OS X
> Platform.
> After some exploration, I determined that this is due to the file encoding
> being set to Windows Latin-1. Excel documents which were created on Windows
> and that I open on my Mac do not have garbled non-ASCII text, so I suspect
> that all that is missing in the exported file is some way to indicate to
> Excel what encoding has been used. Some of my recent web searches suggest
> that at least the more recent versions of Office store characters in
> little-endian UCS2 encoding.
> For text files, it seems to me that UTF-8 would be the the most platform and
> language agnostic encoding to use.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
displaytag-devel mailing list
displaytag-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
