To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42727 Issue #:|42727 Summary:|Interoperatability with Thai MS Excel 97 : BATHTEXT() |and t number format prefix Component:|l10n Version:|680m74 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|code Assigned to:|ft Reported by:|samphan
------- Additional comments from [EMAIL PROTECTED] Mon Feb 14 04:51:41 -0800 2005 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
