Issue 83490

Summary: Wrong spelling of Thai text converted from number in BAHTTEXT()
Product: Calc Reporter: zybersup <zybersup>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: daniel.rentz, issues
Version: OOo 2.0.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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

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.

Comment 2 frank 2007-11-12 13:43:19 UTC
closed wfm
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

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.

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.