To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90127
User er changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Resolution| |INVALID -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Mon Jul 14 12:50:43 +0000 2008 ------- Sheet1.A1 is a relative reference, including the sheet reference being relative. If on Sheet2, it points to "one sheet before" and when copying it it still points to "one sheet before". Use an absolute sheet reference instead, i.e. $Sheet1.A1; the difference to Excel is that Excel does not know relative sheet references at all and treats all sheet references as absolute references. --------------------------------------------------------------------- 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]