Red Hat Bugzilla – Bug 104568
Incorrect date entry format in oocalc for locales other then US
Last modified: 2007-04-18 12:57:37 EDT
Description of problem:
The only format in which dates can be entered into cell in spreadsheet is
MM/DD/YYYY which is confusing for people outside US. Date entry format should be
set from current locale settings or should be setable in preferences.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Enter a date in for example Polish format (DD-MM-YYYY) under Polish locale
2. Set display format to the same setting as above
3. Month and day are swaped.
Invalid date entered and displayed.
Valid date entered.
Tested on Redhat 9 and openoffice from the distribution. Third party oo (1.0.1)
under RH7.3 is also broken.
Appears to be fixed in rawhide 1.1.2. Please reopen if its not.