To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114020
------- Additional comments from ohal...@openoffice.org Sun Aug 22 01:37:29 +0000 2010 ------- Hi Rainer No I don't use (never used), anything other than the default for dates. The file dates-ohallot.ods just above was created by selecting dates-rainerbielefeld.ods first spreadsheet and copying & pasting into dates-ohallot.ods first spreadsheet. So, I did not paid enough attention to this: When pasting data into the new spreadsheet, it looks like that the value inserted into the cell is actually the value displayed. Since "VERDADEIRO" means "TRUE", the results inclumn C means that column B does not match function DATE(YYYY;MM;DD), because DD=16. But now please find attached the spreadsheet with manual input data and dates, and with the default setting, and images I have here. Data in column A was input manually. Data in column B was typed manually as 16/01/<YEAR>, (1900,1901,1902,...) Column C shows that dates in column B are equal with the results of the function DATE(YYYY;MM;DD). Looks like the serial number for the date is OK. Column D has this incredible result... =A2 with special 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