On 06/22/09 17:10, Regina Henschel wrote:
Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702.
So OOo drops "=MULTIPLE.OPERATIONS(A3;A6;A4)"? OOo acts as if the
formula in A5 is "=A3".
All references to A6 in A3's formula are replaced with A4. There are
none, so the result is A3, unchanged.
OFFSET doesn't mix well with MULTIPLE.OPERATIONS because it's one of
the functions that cause the cell to be recalculated on any change,
like RAND or NOW. So the changed formula depends on the special
"ALWAYS" range, not on A2. That's a matter of implementation, and
could probably be changed, but it doesn't look like a high-priority
issue.
That means, that it is another problem and a real bug and the result
should be 18 in both cases? [18= 11 (content of one position after A4)+7
(content of A4)]
"OOo Later" would be OK for me.
A bug or a limitation, whatever one might call it, but certainly
different from the other case.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
