Description: I have several columns with numbers, the fourth column Sums the 3 to the left and the 4th column cell above. =SUM(B6:D6)+E5 I needed another row so I inserted above, but it did not include the formula in the 4th row. I drug the 4th row cell from the above row down to the new row 4th cell. It copied the formula relative EXCEPT that the extra (+E5 in this case) remained static (did not change with the rest of the formula). I believe it should have a $E$5 in order to remain static else it should be relative, though i could be missing something. I will attach the file, there is nothing sensitive. Row 6 is the one i inserted (by right clicking 7 'insert row above') 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 Actual Results: the cell:cell portion of the formula copies relative, the additional +othercell does not. Expected Results: All cell references in the formula should be relative as it has no static markers (i'm prob using all the wrong lingo) Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: I'm not seeing how to submit the file as an example here. Let me know if you want it.
Created attachment 176011 [details] TestCase145388 Correction, the new row cell whose formula that i drug down from E5 worked fine, it's the former E6 which is now E7 that did not update correctly when i inserted the new row.
(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.