To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766
------- Additional comments from [EMAIL PROTECTED] Thu Dec 6 16:12:07 +0000 2007 ------- It does not work with Ooo 2.3.1 It seems to me that not everyone understands what the problem is, so try this: If a1 = $b$1 + b2 Double click on it to edit formula Drag the b1 reference (drag the colored cell) to c1 and confirm edit You should have a1 = $c$1 + b2, but have a1 = $c$1:c1 + b2 Although the answer is still correct, if the cell gets copied, say to a2, it will become a2 = $c$1:c2 + b3 which is equal to c2 + b3, instead of the correct a2 = $c$1 + b3 What happens is that the absolute reference becomes a range when dragged in "editing mode". If it was not an absolute reference, there is no problem. BTY, it did work on Ooo 2.2, and it is a very useful feature. Hopefully it the OOO team would reconsider the target milestone. If Ooo is slow, we can do with it, but what is not reasonable is to have wrong results. --------------------------------------------------------------------- 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]
