To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54774 Issue #:|54774 Summary:|Bad user experience when entering dates in Thai |locale Component:|l10n Version:|680m130 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|code Assigned to:|er Reported by:|james_clark
------- Additional comments from [EMAIL PROTECTED] Sun Sep 18 17:16:56 -0700 2005 ------- In Thailand, the Buddhist calendar is more commonly used than the Gregorian calendar. Year 2005 in the Gregorian calendar is year 2548 in the Buddhist calendar. The Thai locale uses [~buddhist]D/M/YY as the default short date format (formatindex=18). In Calc, if the user enters a date as 19/10/2005, it will by default be displayed as 19/10/48. So far so good. However, if the user now enters a date as 19/10/2548, it will be treated as the year 19/10/2548 in the Gregorian calendar, which is 19/10/3091 in the Buddhist era, and thus be displayed as 19/10/91. The overall result is that by default a Thai user is required all the time to mentally translate between dates in the Buddhist calendar and dates in the Gregorian calendar. Obviously this is not good. The Thai version of Excel has the same problem if a cell uses a Buddhist calendar date format. However, the problem is less serious because by default Excel uses a Gregorian calendar date format, and so the problem will only arise if the user manually chooses a Buddhist calendar date format. There would seem to be two possible approaches: - don't use a Buddhist calendar date format as the default in Calc; however, simply changing the Thai locale data would be problematic because using the Buddhist calendar date format as the default is the right thing to do in other parts of OOo - introduce some intelligence about the calendar with respect to which years are interpreted, rather than always treating dates as being in the Gregorian calendar; this would be analagous to the current intelligence about how two digit date years are entered; for example, interpret dates between 30 and 75 as being between 2530 and 2575 in the Buddhist calendar --------------------------------------------------------------------- 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]
