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] Tue Jun 10 16:57:06 +0000 2008 ------- I searched for this issue, but didn't find it, and wrote another. Fortunately, someone marked it as a dupe, and pointed me here. I had written a complete description: If you edit (F2) a cell containing absolute cell references (either partially or fully absolute), and use drag & drop to move these cell references, single cell references become ranges. This causes problems if this cell is later moved. Since the end of range is relative, if you copy the cell, you will create a range where once there was a single cell. This can sometimes create an error (if the reference doesn't allow ranges), or will produce incorrect results. Example: In Cell A1, put the formula =B1+$B2+B$3+$B$4. Now edit cell A1 and use drag & drop to move the references from column B to column C. You will end up with the formula: =C1+$C2:C2+C$3:C3+$C$4:C4. This still produces the expected result, but then copy cell A1 and paste it to A2. You will get the formula: =C2+$C3:C3+$C3:C4+$C$4:C5. This will produce #VALUE because ranges aren't allowed. If you repeat the process with SUM(), the formula will provide an answer, but it probably isn't what the user would expect, as the ranges will expand when the cell is copied/pasted. I agree, this bug is nasty, and if I can get a development system set up, I will work on fixing it. Based on my testing, it looks pretty simple. When you MOVE a cell reference, something is flagging the END OF RANGE as relative. If you take a relative range (let's say =SUM(A1:A2) and edit it, and SHRINK the range back to one cell, it doesn't produce SUM(A1:A1), it produces SUM(A1). However, if you try to shrink a "mixed absolute" range, it will never produce a single cell. In order to shrink to a single cell, the absolute-ness of both the start and end must agree. So, $A1:$A2 will shrink, but $A1:A$2 won't, because the two terms don't agree in absolute-ness. That's where I think the problem lies - moving a single cell seems to get flagged as being "relative" for the ending term (when you STRETCH a single absolute cell, it will create a range, the ending term is relative). Excel (which doesn't have this bug), makes sure when it creates a range from a single cell, the absolute-ness of the ending term MATCHES the absoluteness of the existing term. If Calc did this, I believe the bug would go away. Now, who can find that part of the code before I do? --------------------------------------------------------------------- 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]
