Nicola,
When you save your spreadsheet, what do you have in the "save as type"
dropdown? Make sure it is NOT ",txt" or anything other than ".xls".
Kenn
LBNL
On 5/1/2008 8: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
>
>>> the exported file is utf-8 encoded but I think this info isn't
>>> passed to ms excel.
>>>
>>> any hint?
>>>
>>> regards
>>> Nicola
>>>
>>> _______________________________________________
>>> 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
>>>
>
> _______________________________________________
> 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
>
_______________________________________________
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
