[Rt-devel] Fwd: patches for spreadsheet export

[Alexandr Kovalenko]

---------- Forwarded message ----------
From: Alexandr Kovalenko <alexandr.kovalenko at gmail.com>
Date: Tue, Dec 21, 2010 at 5:04 PM
Subject: Re: [Rt-devel] patches for spreadsheet export
To: Ruslan Zakirov <ruz at bestpractical.com>


On Tue, Dec 21, 2010 at 5:00 PM, Ruslan Zakirov <ruz at bestpractical.com> wrote:
> On Thu, Dec 16, 2010 at 8:46 PM, Christian Loos <cloos at netsandbox.de> wrote:
>> Am 16.12.2010 18:00, schrieb Kevin Falcone:
>>> On Thu, Dec 16, 2010 at 11:56:35AM -0500, Kevin Falcone wrote:
>>>>> utf-8 didn't work on Windows XP with Excel 2003.
>>>>
>>>> Does it work on more modern Excels?  This seems like a really odd
>>>> patch.  I wonder if it would even work on Macs with Numbers.
>>>
>>> Forgetting client issues for a minute, how would this patch work on
>>> actual utf8 data (such as asian languages)
>>
>> OK forget about the first patch.
>> I will try to test utf8 on more modern excel. If this still fails maybe
>> it makes sense to have a config value where you can override utf8
>> encoding if it doesn't work for someone like me.
>
> It doesn't work for many as excel is stupid and expect that csv files
> are in some preferred encoding, for example on ru Windows it should be
> cp1251.

I've found the most convinient way to feed Excel with data is using
it's XML format (no, not xslx, but MS Excel Speadsheet XML).
It should be well-formed UTF-8 XML.

--
Alexandr Kovalenko
http://uafug.org.ua/



-- 
Alexandr Kovalenko
http://uafug.org.ua/