Am 15.07.2010 06:23, schrieb Tantai Thanakanok:
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.
Hi,
the export of number formats to Excel format is implemented in
File: sc/source/filter/excel/xestyle.cxx
Class: XclExpNumFmtBuffer
special handling may be added to the function
XclExpNumFmtBuffer::GetFormatCode() that already contains special
handling for e.g. the "General" or for Boolean format codes.
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
