<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=TIS-620"> </head> <body bgcolor="#ffffff" text="#000000"> 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 <a href="https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B__gfZ8MHOEoMDg2YjQ2ZmQtNTlkZi00NDZkLTk4ZGMtNWU4ZmQyMTdjMWUy&hl=en">i18ndate.xls</a> file) <img src="cid:part1.00090905.01010405@osdev.co.th" alt=""> When import to Calc will become <img src="cid:part2.01010904.02030201@osdev.co.th" alt=""> The reason is that Excel international number format (LCID) is completely different from Calc's. See <a class="moz-txt-link-freetext" href="https://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx">https://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx</a> The correct import would generate the following in Calc (see manually-fixed <a href="https://docs.google.com/leaf?id=0B__gfZ8MHOEoYTc5NzY1NjEtZDUyNS00NjBlLWEzODMtOWU4MmNjNzZhYjY5&hl=en">i18ndate.ods</a>) <img src="cid:part3.05080207.01050802@osdev.co.th" alt=""> (note: still see difference in how Excel and Calc interpret Hijri calendar) See LibO bug <a class="moz-txt-link-freetext" href="https://bugs.freedesktop.org/show_bug.cgi?id=33089">https://bugs.freedesktop.org/show_bug.cgi?id=33089</a> and the original OOo issue <a class="moz-txt-link-freetext" href="http://openoffice.org/bugzilla/show_bug.cgi?id=93503">http://openoffice.org/bugzilla/show_bug.cgi?id=93503</a> In bugzilla, I and Kohei have made a discussion about the approaches to fix this problem :- 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 Calc number format. When export use the LCID already there. Since this is a feature that effect many non-western locales. Each with specific details in how they handle local calendars and natnums. I think we should make this important decision first, before we start to implement it. This will benefit every non-western locales with natnums and/or local calendars. I know because this is the top-priority bug in Thai, to convert date in buddhist calendar from Excel. Other non-western locales must have faced similar problems. So what do you think? <div class="moz-signature">-- _/|\_ Samphan Raruenrom. Osdev - Open Source Development Co., Ltd. สัมพันธ์ ระรื่นรมย์. โอเอสเด็บ - บริษัท โอเพนซอร์สดิเวลอปเมนต์ จำกัด tel: +66 2 269 9889 web: <a href="http://www.osdev.co.th/">osdev.co.th</a> twitter: <a href="http://twitter.com/osdev">@osdev</a> facebook: <a href="http://www.facebook.com/osdev">facebook.com/osdev</a></div> </body> </html>