Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Wrong spelling of Thai text converted from number in BAHTTEXT()|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description zybersup 2007-11-09 11:31:52 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', ...
Comment 1 frank 2007-11-12 13:42:25 UTC
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
Comment 2 frank 2007-11-12 13:43:19 UTC
Comment 3 zybersup 2007-11-13 04:35:18 UTC
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.
Comment 4 frank 2007-11-13 08:13:41 UTC
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
Comment 5 zybersup 2007-11-13 08:42:09 UTC
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.