[sc-issues] [Issue 103302] Absolute references updat ed as if relative on referenced cell move
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 Summary|Absolute references to oth|Absolute references update |er sheets are updated as i|d as if relative on refere |f relative on referenced c|nced cell move |ell move | --- Additional comments from grug...@openoffice.org Fri Jul 3 06:04:57 + 2009 --- Upon further examination it appears that handling of absolute/relative reference updating is completely broken in OpenOffice 3.x. I am pretty certain this worked at least partially in 2.x, but don't have an install to hand to test. I will try and confirm this is a regression and post an updated test case. For confirmation on the intended function, here is a quote from the manual: Absolute references are used when a calculation refers to one specific cell in your sheet. If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute. There is a shortcut guide to cell references at: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=2443 - 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
[sc-issues] [Issue 103302] Absolute references updat ed as if relative on referenced cell move
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103302 --- Additional comments from rainerbielef...@openoffice.org Fri Jul 3 06:19:26 + 2009 --- ... would be happy to create a ... Please do so! I can't see any relation between your HELP quote and your report, HELP is concerning COPY/PASTE formulas with references, your report concerning MOVING (cut/past) the referenced cells. - 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
[sc-issues] [Issue 103302] Absolute references updat ed as if relative on referenced cell move
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 + 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
[sc-issues] [Issue 103302] Absolute references updat ed as if relative on referenced cell move
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103302 User rainerbielefeld changed the following: What|Old value |New value Status|RESOLVED |CLOSED Keywords| |oooqa --- Additional comments from rainerbielef...@openoffice.org Fri Jul 3 15:25:14 + 2009 --- @grugnog: Thank you for your additional tests! - 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