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 isaacmar...@openoffice.org Fri Apr 17 19:13:11
+0000 2009 -------
This bug has more than a Year!!!
I am writing this in an effort to help developers better understand of how
important this is.
«Background»
Edit the contents of a cell is the most basic and, by large, the most common
task any user performs in a worksheet. Anything that needs to be changed is done
by a "editing a cell". Many Calc users just look at the graphs, or read the
results of a worksheet, but any "power user" would do some sort of change in the
worksheet. For those users, any mistake on the edit process could have far
reaching effects.
«The problem»
This specific problem is related to how a cell reference is interpreted by the
application. It could be said that a direct cell reference (i.e. D6), an
absolute cell reference (i.e. $D$6) and a range of "one cell" (i.e. D6:D6 direct
or absolute) point to the same cell. And any of those references would give the
same result when used in a cell. While yes, that's correct, this is not what
this Issue is really about.
The problem becomes a real issue when those references are copied to other
cells. That's a common procedure to make formulas in several cells do the right
thing. Edit once, copy many, is what I like to call this concept.
«An example of the problem»
1.- Open the attached File. On cells C10:D19 there is an empty RED space to
work the example. There are some more cells bellow to help understand
what happens.
2.- Fill down (copy cells C10:D10 down) up to cells C19:D19. There will
be a mistake on cells D13, D16 and D19. The correct result should be
what is in cells C23:D32.
3.- Edit cell D10. The reference to AE5 is incorrect. While editing
cell D10 move the reference (with the mouse) to cell AE2. The
reference should change to $AE$2:AE2.
4.- Fill down C10:D10. A different error is in cells D13, D16, and D19.
e.g. The referenced cell $AE$2:AE2 changes to $AE$2:AE5 at cell D13.
That breaks the "edit once, copy many" sequence!!!!!!!!!!
The cell D10 needs to be re-edited to erase the incorrectly added part AE2.
The correct formula has been set up in C23:D23 for you to try how it should work
correctly.
Any user that depends on copying formulas to several cells would have problems
with this bug. Any power user would be bitten by this bug.
Hope this helps.
---------------------------------------------------------------------
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
