Re: [rt-users] Spreeadsheet, utf-8 and ms excel

[Jesse Vincent]

On May 1, 2008, at 11:50 AM, Mailing List SVR wrote:

Il giorno gio, 01/05/2008 alle 09.55 -0400, Jesse Vincent ha scritto:

On May 1, 2008, at 8:21 AM, Mailing List SVR wrote:

When export a search result as tsv spreedsheet ms excel doesn't
properly
display non ASCII characters:

for example ò is displayed as ò

and so on,

Nicola, What RT are you testing with?

Thanks for your quick answer,

I'm using rt 3.6.5 on centos 5.1,

I quickly looked at 3.6.6 code and doesn't seem there are changes
related to spreeadsheet generation

If I open the tsv file with notepad and save it as unicode and then I
open the file with ms excel all is fine,

If I open with openoffice calc and import as utf-8 all is fine,


in Results.csv source file and then I import the generated tsv in ms
excel and specify utf-8 encoding all is fine

maybe some header in missing in tsv generation

even if I change content_type from application/vnd.ms-excel to text/ csv

Can you find out whether MS accepts a way to specify this from MIME types (possbily application/vnd.ms-excel; charset=utf8) ? If there's a change we can make, I'd be happy to make it

PGP.sig
Description: This is a digitally signed message part

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com