To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028
------- Additional comments from li...@openoffice.org Wed Jul 14 16:07:24 +0000 2010 ------- Hi, the same problem is visible in 3.2.1 Finnish version and with Finland/Helsinki date settting. @rainerbielefeld: Here is the result of your latest testing request: When the dates you sent below are written to cells, everything goes fine since Calc assumes 90 to mean year 1990 (Column A is text, column B is function =int(a2) – int(a12) and column C is date in format dd.mm.yy): A B C 23.07.90 33077 23.07.90 24.07.90 33078 24.07.90 25.07.90 33079 25.07.90 26.07.90 33080 26.07.90 27.07.90 33081 27.07.90 28.07.90 33082 28.07.90 29.07.90 33083 29.07.90 30.07.90 33084 30.07.90 31.07.90 33085 31.07.90 01.08.90 33086 01.08.90 02.08.90 33087 02.08.90 But when changed the year to 1790, the familiar issue is back (column A is text, column B is date in format dd.mm.yy and column C is =int(B)): A B C 23.07.1790 22.07.90 -39971 24.07.1790 23.07.90 -39970 25.07.1790 24.07.90 -39969 26.07.1790 25.07.90 -39968 27.07.1790 26.07.90 -39967 28.07.1790 28.07.90 -39966 29.07.1790 29.07.90 -39965 30.07.1790 30.07.90 -39964 31.07.1790 31.07.90 -39963 01.08.1790 01.08.90 -39962 02.07.1790 01.07.90 -39992 So something is definetely wrong in July 1790. But is it OO or the PC, that's the problem. Now every date seems to be --'d when formatting... --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
