https://bugs.documentfoundation.org/show_bug.cgi?id=145388
Aron Budea <ba...@caesar.elte.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ba...@caesar.elte.hu,
| |er...@redhat.com
Hardware|x86-64 (AMD64) |All
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
OS|Windows (All) |All
--- Comment #2 from Aron Budea <ba...@caesar.elte.hu> ---
(In reply to BrianB from comment #0)
> Steps to Reproduce:
> 1.Create relative formula in several rows (sum cell:cell +othercell)
> 2.slect a middle row and rt click Insert row above
> 3.drag above row cell down to copy formula
I don't understand why the 3rd step is here, it isn't mentioned in the
description, and as I understand it's the "fixing" method, isn't it?
My understanding of the phenomenon is that Calc keeps the references to the
existing cells. Ie. if you add a new 5th row, E4 didn't change, so the
reference to it stays the same, while B5:D5 moved down a row, so they have to
change in the formula. If they referenced a cell in row 5, they'd change as
well.
This is different from when using fill down, when you're extending a formula to
previously uncovered ranges.
Therefore I'm closing this as NOTABUG, Eike, please correct me if there's a
flaw in the above reasoning.
--
You are receiving this mail because:
You are the assignee for the bug.
