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

[Mailing List SVR]

> 
> 
>>
>> 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,
>>>
>>>
even if I change
> content_type from application/vnd.ms-excel to
text/
>>> csv
>>> 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
>>
>>
>> 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
>

> It doesn't work ...
> 
> Can I export the
> spreadsheets with iso-8859-15 encoding ?
> 
>
thanks
> Nicola
> 

It seems that Excel doesn't
use the charset header, it always import the file as Windows-1252 (on
Windows). The only solution I found is to export as html entity.

I tested the solution proposed here (export as html entity) and it
works:

http://www.listsearch.com/Lasso/Thread/index.lasso?16733

I
would like some help to do this inside request tracker,

thanks
Nicola



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

> Community help: http://wiki.bestpractical.com
>
Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.
> Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080501/06f1f7fc/attachment.htm>