Apache OpenOffice (AOO) Bugzilla – Issue 83490
Wrong spelling of Thai text converted from number in BAHTTEXT()
Last modified: 2013-08-07 15:12:27 UTC
When the number 1 is at the least digit of an integer number in Thai, it is spelled 'เà¸à¹‡à¸”' not 'หนึ่ง' such as; 31 is spelled 'สามสิบเà¸à¹‡à¸”' not 'สามสิบหนึ่ง', or 201 is spelled 'สà¸à¸‡à¸£à¹‰à¸à¸¢à¹€à¸à¹‡à¸”' not 'สà¸à¸‡à¸£à¹‰à¸à¸¢à¸«à¸™à¸¶à¹ˆà¸‡', or 50001 is spelled 'ห้าหมื่นเà¸à¹‡à¸”' not 'ห้าหมื่นหนึ่ง', and so on. There is only one case it is spelled 'หนึ่ง' when the number is 1. In OOo 2.0.2 (which I am currently using,) it spells all the numbers ending with '-01' as 'หนึ่ง', not 'เà¸à¹‡à¸”' which are all wrong. There is only 2 cases that it spells correctly, when the number is 1, and when the number has other number next to 1 such as '-21', '-51', ...
Hi, OOo2.0.2 was faulty in some points. So please use the latest stable version which currently is OOo2.3. 2.3 and Excel2003 shows the same result. As BAHTTEXT is a compatibility function for Excel, it works as designed and therefore this Issue is closed worksforme. Frank
closed wfm
Sorry that I did not mention that Excel has been spelling wrong also. I expect OO.o can do better by being not just compatible with Excel but correct one that Excel do wrong. And it is very easy to correct this.
Hi, sorry to tell you but this function was integrated just for compatibility to Excel, therefore it works as designed. Nevertheless we may do it better. So I re-flag this as enhancement and re-assign for decission finding to requirements. Frank
Thanks for consideration of improving it. Please let me know if nobody going to correct it. I really want to help edit the code but I am not comfortable to install all the development code of OO.o in my machine. So if you just send me the module to let me correct it and send back to you to test. That would be fine. Its logic is less complicated than the current one and I guess my correction should cause no new bug. However, if there is any Thai developer contributing OO.o already, it'd better let them check it first. I have written this function in Java, C, php for my own use for a long time. Just an opinion. Will see how it will go.