Re: [Libreoffice] Approaches to enable international number format import/export in Calc

2011-03-09 Thread Samphan Raruenrom
OK. Let me propose a better patch (attached) using the first approach. Also attach to the bug : https://bugs.freedesktop.org/show_bug.cgi?id=33089 This only to enable the conversion of Thai buddhist calendar and Thai native numeral between Excel and Calc. I wish I could add more support for other

Re: [Libreoffice] Approaches to enable international number format import/export in Calc

2011-03-07 Thread Kohei Yoshida
On Mon, 2011-03-07 at 13:57 +0700, Samphan Raruenrom wrote: 1) When import from Excel, convert Excel LCID (4-8 hex digits) to Calc's natnum and calendar specifier. When export reverse the process to generate the appropriate Excel LCID. 2) When import form Excel, maintain Excel LCID as-is in

Re: [Libreoffice] Approaches to enable international number format import/export in Calc

2011-03-07 Thread Kohei Yoshida
On Tue, 2011-03-08 at 00:04 -0500, Kohei Yoshida wrote: So what do you think? Given the above, to me the choice is clear. The only issue is that, we may already have lost an window of opportunity to do it the right way for 3.4. So, we may have to take your patch for 3.4, and work on my

[Libreoffice] Approaches to enable international number format import/export in Calc

2011-03-06 Thread Samphan Raruenrom
Surprisingly, Calc doesn't support or even handle import/export from/to Excel international number format, result in lost of information from dates in non-western locale when convert. For example, these dates in Excel (see i18ndate.xls file) When