To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103302 Issue #|103302 Summary|Absolute references to other sheets are updated as if |relative on referenced cell move Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|grugnog
------- Additional comments from grug...@openoffice.org Fri Jul 3 03:19:09 +0000 2009 ------- If you have an absolute reference in cell B1 to "=$A$1" and cut and paste A1 and place it in A2, B1 will continue to reference A1, because it is absolute. This is the correct, expected and observed behavior. For the test case, say you have an absolute reference in cell B1 on Sheet 2, to absolute reference the same cell A1 in Sheet 1 as "=$Sheet1.$A$1", and perform the exact same cut and paste on Sheet 1 of A1 down to A2. Expected behavior is that cell B1 on Sheet 2 will continue to reference cell A1 on Sheet 1 - the reference is absolute and hence should be maintained. Actual behavior is that the formula in cell B1 on Sheet 2 is updated to reference cell A2 on Sheet 1. This is the behavior you would expect if a relative reference had been used (i.e. "=$Sheet1.A1") and hence means that absolute references are non-functional in this context. I will attach a file demonstrating this. Practically this makes it impossible to build reliable multi-sheet spreadsheets unless you can train all users to never ever cut and paste, which is a practical impossibility given that many users do this almost sub-consciously. --------------------------------------------------------------------- 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