To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113028 Issue #|113028 Summary|Date bug Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|formatting Assigned to|spreadsheet Reported by|lisko
------- Additional comments from li...@openoffice.org Thu Jul 8 06:55:01 +0000 2010 ------- Hi! My mother-in-law does a research in her family roots. She found this bug from OpenOffice Spreadsheet / Calc application while feeding in 18st century dates from some other source. This is the data she put in, the first two sections are dates in Finnish format and others are birthplaces and person names: 03.12.1755 15.12.1755 Saresmäki Isaac Pussinen Anna Kerätär Carin 07.09.1758 18.09.1758 Saresmäki Isaac Pussinen Anna Kerätär Isaac 12.04.1760 19.04.1760 Saaresmäk Isaac Pussinen Anna Kerätär Andreas 24.05.1763 20.06.1763 Saaresm. J. 53 No 6 Sivola Isaac Pussinen Ann. Kerätär Anna 27.03.1764 18.06.1764 Saaresm. J. 53 No 6 Sivola Isaac Pussinen Ann Kerätär Christina (nd.) 21.03.1766 11.04.1766 Saresm. J. 53 No 6 Sivola Isaac Pussinen Anna Kerätär Anna 19.04.1773 01.07.1773 Saresmäki Isaac Pustinen Anna Kerätär Sara (conf.) So everything is fine as long as the cells are not formatted. But when she changed the format of the first columns to be dates, all those dates were changed - 1 day, for example teh dates in first row changed to be 02.12.1755 and 14.12.1755. No matter if this same data is copy-pasted or hand-written, the same thing happens. She studied this a bit and discovered that the prolem is in dates 25.07.1790 and 26.07.1790. These both have same values: date value() 23.07.1790 -39970 24.07.1790 -39969 25.07.1790 -39968 25.07.1790 -39968 (input 26.7.1790 into the cell manually) 26.07.1790 -39967 (input 27.7.1790 into the cell manually) 28.07.1790 -39966 29.07.1790 -39965 Seems that it is impossible to write 26.07.1790 as it is being changed to 25.07.1790 and all dates since that are wrong. She did not find out if this problem vanishes after some other year. I'm not really sure about the exact version she has, it is 3.1 something with Finnish language pack. It was the latest version that was available in May 2010 when we installed it to her new laptop. BR, Hannu --------------------------------------------------------------------- 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