[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 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 to ot her sheets are updated as if relative on refer enced cell move
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 + 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
[sc-issues] [Issue 103302] Absolute references to ot her sheets are updated as if relative on refer enced 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 grug...@openoffice.org Fri Jul 3 03:30:45 + 2009 --- Created an attachment (id=63340) Cross sheet absolute cell reference updating test case 1 - 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 to ot her sheets are updated as if relative on refer enced 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|RESOLVED |UNCONFIRMED Keywords|oooqa | Resolution|INVALID | Subcomponent|editing |code --- Additional comments from grug...@openoffice.org Fri Jul 3 05:40:47 + 2009 --- Please note that the behavior is inconsistent *within* OpenOffice itself - absolute references are handled correctly on cut-paste within the current sheet, but cells absolutely referencing cells on another sheet are updated as if they were relative - this is not a feature! I think you are confused about what absolute references do - there is (and should be) no difference between relative and absolute references if you *copy*-paste the target cells. The difference in function only occurs when the target cells are moved - normally by a *cut*-paste operation. In this case relative axis (Sheetname/X/Y) should be updated in line with the motion of the target, whereas absolute axis should be maintained at their original value. The above paragraph matches OpenOffice (correct) behavior exactly when within a single sheet, and also the description in the documentation - absolute references are treated as absolute. The issue I am reporting here is that OpenOffice appears to treat all cross-sheet references as relative (in terms of updating references on cut-paste), even when when they are actually absolute. The correct behavior is that it should treat relative references as relative, and absolute references as absolute - the same way it does in a single sheet situation. Perhaps there is some technical reason why this behavior can not function as it should across sheets, however I could find no previous issue or documentation describing this. Also, it seems unlikely because the cell references are already getting updated on all sheets, it just happens that the logic is not correct for intersheet references and absolute axis are treated as relative. I hope this makes the issue clearer. If you like I would be happy to create a test case showing correct behavior within a single sheet, for comparison - or point you to further documentation on the matter. - 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