To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84748
User cloph changed the following: What |Old value |New value ================================================================================ Status|NEW |RESOLVED -------------------------------------------------------------------------------- Resolution| |INVALID -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Wed Dec 19 12:55:26 +0000 2007 ------- invalid. The colored one is interpreted as text. Strong hint for that is that it is left-aligned, not right aligned. If you want be sure, just check with the formula =ISTTEXT(E1) Text is treated as 0 and according to the interval settings in tools|Options → OOo → General "Interpret two digit years as ..." will be treated as 2000 If you change the interval to go from e.g. 1850, the combined date will be treated as 1900. Solution: Convert the date to a number first (encapsulate it as WERT(E1)) --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]