To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87143 Issue #|87143 Summary|Formatting a cell as YYYY doesn't allow entry in that |format Component|Spreadsheet Version|OOo 2.4 RC5 Platform|All URL|https://bugs.edge.launchpad.net/ubuntu/+source/openoff |ice.org/+bug/160446 OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|ccheney
------- Additional comments from [EMAIL PROTECTED] Mon Mar 17 18:18:39 +0000 2008 ------- This might not actually be a bug but is annoying nonetheless. When formatting a cell as date type with format code of YYYY if a year is entered instead of a full date it shows up as a date based from 1900 in what is displayed, eg enter '2005' and it shows up as '1905'. The preferred behavior would be to know a year is being entered due to the format code and fixup the internal representation to make it eg January 1, 2005 as needed. --------------------------------------------------------------------- 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]
