Apache OpenOffice (AOO) Bugzilla – Issue 42727
Interoperatability with Thai MS Excel 97 : BAHTTEXT() and t number format prefix
Last modified: 2013-08-07 15:03:05 UTC
Thai version of MS Excel 97 has two custom extensions that will introduce incompatability when converting the Excel document to OOo Calc, if not handled appropriately. 1) The BAHTTEXT() function only available on Thai Excel 97. It is used to spellout Thai currency, e.g. ฿210.50 becomes two hundred and ten bath fifty satang. 2) The 't' number format prefix. It is used in Thai Excel 97 to make a number displayed using Thai digit, the same way OOo uses '[natnum1]'. For example, Thai Excel 97 number format 't0' is the same as OOo '[natnum1]0' and will make 210 displayed as ๒๑๐. The OOo Excel filter should be able to support the use of these extensions to import/export the documents (that use the features) correctly. The 't' number prefix should be easy to convert (to [natnum1]). But the BAHTTEXT() function requires the same function or alike to be implemented in OOo.
There's a hack to achieve these functionalities, available in the OOo-derived "Pladao Office" http://www.pladao.org/ fyi, Pladao Office 3.1 (current version, based on OOo 1.1.x) source tarball is here http://www.pladao.org/files/3.1/PladaoOffice3.1-src.tar.gz although I have no clue where are the changes that makes it supports BAHTTEXT() and 't' number format. nusorn@ may able to help us.
Samphan, Can you provide a testcase for this?
I've just found that the BATHTEXT() function and t prefix also available and working in Excel 2003. Test case:- - The attached document is an Excel 2003 document with two cell : one is '=BATHTEXT(12.5)', the other is '123' formated using number format 't0'. The result of the first cell is the spellout of 12.50 Baht. The result of the second cell is the number 123 displayed using Thai digit. See the attach screenshot from Excel. - Load the attached document in Calc. The Thai feature from Excel will not work. See the second screenshot. The BATHTEXT() will convert to _xlfn.BAHTTEXT(). And the 't0' number format convert to '0', result in the number to be displayed using ASCII.
Created attachment 22691 [details] Excel 2003 file with BAHTTEXT() and t number format
Created attachment 22692 [details] Screenshot of the document loaded in Excel 2003
Created attachment 22693 [details] Screenshot of the document loaded in OOo 1.9.77 Calc
Test with OOo 1.9.79 (Windows). Confirmed.
Created attachment 25428 [details] BAHTTEXT in MS Excel 2003 "Insert Function" dialog
Created attachment 25429 [details] BAHTTEXT in MS Excel 2003 Help
Change Priority to P2, Issue type to DEFECT. As it's now clear that this loss of BAHTTEXT() is a loss of MS Office-compatibility, import/export, which can be considered as: - Data loss - Basic functionality is not working correctly
FT: Yes, you are right. Nevertheless BAHTTEXT is hardy ever used outside Thailand (in fact does not ship with German or standard English version of Excel). Therefore no fix in 2.0.x
set target to 2.0.1
reassign
BAHTTEXT function implemented. See issue 53826 for the "t" prefix. Fixed in SRC680/dr41 (OOo 2.0.1)
back to QA re-open issue and reassign to oc@openoffice.org
reassign to oc@openoffice.org
reset resolution to FIXED
found fixed on cws dr41 on Linux, Solaris and Windows build
closed because fix available in OOo2.0m136