To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70077
User delorea changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Keywords|needhelp, oooqa |oooqa -------------------------------------------------------------------------------- Resolution| |INVALID -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Tue Oct 10 02:30:23 -0700 2006 ------- Well. This is not a bug. As discussed with fst, from a mail: He copied a date into the clipboard and ordered Calc to Paste just numbers and Strings. As the clipboard does not contain a number or a string but a date, the range is pasted empty. This is exactly what the User told Calc to do. If he tags the Date&Time and the format option in the Paste Special dialog, he get's what he expects. This is how the Paste Special dialog is designed and intended to work. As workaround to obtain the expected result, you must use the TEXT function like =TEXT(A1;"MMMM") Bye Ambrogio --------------------------------------------------------------------- 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]