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 [email protected] Fri Jul 3 05:40:47
+0000 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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
