To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99090 Issue #|99090 Summary|Adjust absolute references: option for Paste Special Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|dmcilroy
------- Additional comments from [email protected] Tue Feb 10 19:24:20 +0000 2009 ------- Absolute references between cells of a copied area will generally misbehave unless the paste-to address agrees with the copy-from address in row, column, or both. An Adjust option in Paste Special would adjust all absolute references that point from one cell in the area to another cell in an area. (The adjustment is like what happens today to absolute references that are affected by insertion of rows or columns.) While this enhancement is not a panacaea for absolute-reference problems, it covers the important special case of copying an area that contains all the cells upon which any cell in the area depends. --------------------------------------------------------------------- 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]
