I want to fix this bug http://qa.openoffice.org/issues/show_bug.cgi?id=93503 . (Calc export of Buddhist date to Excel is broken)
Steps to reproduce: 1. Start OpenOffice.org Calc 2. Tool -> Option -> Language Setting -> Languages and set Locale setting to Thai 3. Type a date (ex. 15/05/2008) in a cell 4. Click the cell and choose Format -> Cells -> Numbers, then changes the following 3.1) Change Category to Date 3.2) Change Language to Thai 3.3) Change Fomat to 31 ธันวาคม 2542 5. Click OK 6. Save as Microsoft Excel 97/2000/XP (.xls) 7. Exit OpenOffice.org Calc 8. Open the xls file in Microsoft Excel Excel will show error dialog box "Some number formats may have been lost." 9. Observe the Date will be formatted as an integer number This bug caused by format code in xls file created by OpenOffice.org contain "[~buddhist]" and excel can't resolve "[~buddhist]" to "[-107041E]". I test by use hex editor open file with [~buddhist] format code and and change it to [-107041E]. after I fix it, xls file is display correctly. After testing I want to fix code but I can't find where to fix it. can anyone help me to find it. -- _/|\_ Tantai Thanakanok. Open Source Development Co., Ltd. Tel: +66 38 311816, Fax: +66 38 773128, http://www.osdev.co.th/
