Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2015-04-08 10:56:02 +0100

ROSt52 gravatar image

In your example with B2, B3 etc and your example wiht B147, B148 etc, Calc works correct.

If you cut B2 and move it somewhere else Calc corrects the formula to where you move your B2. If you don't want the change in the formula b2->b1, than copy b2 into b1. The formula in A1 remains b1+b2

In the case of a new row inserted in between 146 and 147, Calc again keeps the formula protected because you told Calc that B147 = B146 +C147 and when you insert a row above 147, B147 becomes B148 and C147 becomes C148. However B146 remains unchanged as Calc shifts rows down when you insert a row. Thus the formular changes correctly to be B146+C148 in cell B148

I recommend to have a look at the free guides, which you can download from and study about copying and moving cells and using absolute cell references. Should you still have questions, please feel free to post it.