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

Mailing List SVR lists at svrinformatica.it
Thu May 1 12:40:06 EDT 2008



> 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

Kenn,

thanks for your answer, the type is xls.

I did a test also changing charset as suggested here (UTF-16LE)

http://www.weberdev.com/get_example-3701.html

but still
doesn't work

> 
> 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:
sales at bestpractical.com
>>>>
>>>>
>>>> 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: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials
from O'Reilly Media.
>> Buy a copy at
http://rtbook.bestpractical.com
>>
> 
>





More information about the rt-users mailing list