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

Kenneth Crocker KFCrocker at lbl.gov
Thu May 1 12:35:12 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

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