To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82959
User kavol changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Oct 30 06:52:52 +0000
2007 -------
I am afraid you missed the point ...
> No, you do not expect that the value for C1 changes to C2, at least
> you should not. C1 is not influenced in any way with this row insertion,
> so nothing has to be changed in this case.
there are relative and absolute references
if I would be interested in C1 contents, then why the heck I would not use
$C$1?
I am interested in Cx contents to be calculated using C[x-1] ... if I would
need Cx calculated from C1, then I really do not see any reason to write C1
instead of $C$1
isn't it a bit strange that there are two posibilities how to reach one result
but no possibility to reach another result? wouldn't it be logical if one way
of addressing would lead to one result and the other to the second?
I understand your logic - what has been moved will be renumbered in
references, what stayed in place will not be renumbered
but this would be true for absolute addresses - then I am interested in some
concrete cell and I want to follow it when it moves (not when its content
moves) ... to be exact, using the example, if I replace C2: =C1+A$2+B2 then
after row insertion I'll still get C3: =C1+A$3+B3
but using relative adresses, I am not interested whether the target cells
moved but rather in their distances from the result cell - if I am using a
cell (in row 2) to calculate something from the preceeding row (1) and then
cut&paste that cell one row lower (to row 3) then it still calculates result
from the preceeding row (i.e. row 2), but if I move the result cell not by c&p
but by inserting row then it will not calculate from the preceeding row but
rather still from the same row as if it would be addressed absolutely? - where
is the logic in THIS?
I have a real world use case: I need to somehow check finances received from
two subjects, so that I use a table with four columns - date, input1,
input2, "stockpile" ... because stockpile is sometimes "corrected", I cannot
simply sum input1 and input2 from the begining, but rather use the
calculation "take stockpile from previous row and add input1 and input2" (the
example =C1+A2+B2) ... sometimes, something is forgotten, so I need to insert
rows - and then I have to manually renumber reference in the stockpile field
after the insertion
so, please tell me, what should I do to prevent the need of manual corrections
if you think that the behaviour of not renumbering relative addresses is ok
(and do not tell me that I have to make special column for the _very
ocassional_ corrections, so that I can use simple sum on stockpile)
> Compare it with other Spreadsheets, all of them act the same way Calc
> do and therefore this Issue is invalid.
oh yeah, and do not forget to mention that all browsers should behave just
like Microsoft Internet Explorer ...
> I'm sure there are some duplicates though.
then mark this as duplicate; I was unable to find any
---------------------------------------------------------------------
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]
