GNOME Bugzilla – Bug 508237
"Insert current date"+Enter gives wrong date
Last modified: 2008-01-16 02:50:50 UTC
Please describe the problem: insert current date inserts incorrect date in ru_RU (month and day of month exchanged) Steps to reproduce: - On January 9th 2008, in ru_RU locale (ru_RU.UTF-8) - create new spreadsheet - set format of A1 to yyyy/mmm/dd - press Ctrl-; and Enter Actual results: "2008/Сен/01" appears in the cell (Sep. 1st) Expected results: "2008/Янв/09" appears in the cell (Jan. 9th) Does this happen every time? Yes. Other information: Ubuntu 7.10, Gnumeric 1.7.11
Confirmed in principle -- I don't read Russian. What we do on Insert-date is to make a text representation of the current date using the default date format and insert that inside the edit line. When Enter is pressed, that string gets reinterpreted and it is not surprising that it ends up wrong, then. I guess we can use the cell's format if it happens to be a date format, but that has its own problems. I don't think we want weekdays etc. in the edit line.
Confirmed with en_CA. On January 9 Ctrl-; enters 9/1/08 which makes sense in this locale.
Note that if I first enter the current date and then format the date to yyyy/mm/dd the problem does not occur.
Created attachment 102522 [details] [review] Proposed patch Please try this patch.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report. This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.