To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103302
User grugnog changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from grug...@openoffice.org Fri Jul 3 07:03:15
+0000 2009 -------
OK, so experimentation reveals that this behavior is consistent within sheets,
versions and matches Excel. Absolute and relative formulas are indeed treated
identically when their destination cells are moved - references are always
updated if it is a single cell move, and are updated for horizontal/vertical
moves for cell ranges. They are not updated for non horizontal/vertical moves
for cell ranges.
I will look around and see if there are proposed solutions for allowing more
fine grained control over this behavior, such that you can move cells without
updating formulas.
One option that occurred to me is that perhaps references in cells within
locked/protected sheets could be left alone rather than updated when their
targets are cut and pasted. This would appear to fix the user experience issue
to a wide range of template worksheet use cases.
---------------------------------------------------------------------
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
