> > >> >> 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: [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
