# automatic formula when add row? [closed]

I have a little problem with Calc. What I want is when I add a row, the formula from previous row is automatically applied to the new row. Let say that I have three rows and three columns. In the third column, I enter formula: =A+B. And then copy that formula for the rest two C column. In the fourth row, I put a total from all numbers in column C. Now I want to add a row on the top of the fourth column, and I want formula for column C (=A+B) automatically applied. In excel this can be easily done by add an additional row between the total row and those rows above it. And then I just need to add another additional row on top of the total row, and then put numbers on the first empty rows for column A and B, and column C will automatically filled. But it seems that I can't to this in Calc. How can I solve this problem? Thanks.

@ROSt52: I don't meant that there is a button/ option to add row and have the formula automatically copied. I add the the row by clicking add row button/ from menu, then the formula automatically copied. It just like the link that @mahfiaz gave.

@ROSt52: version 2007. Sorry I can't attach the file. My karma is only 1 (they need > 3 to allow me to attach the file). But If I'm not wrong this trick works fine in previous version.

@ROSt52: Try to follow this step: (1) make column C is addition from column A and B. (2) fill any number from A1 and B1 until A3 and B3. (3) Copy formula from C1 to C2:C4. (4) Add formula "=sum(C1:C4) at C5. (5) add a row above row 5. (6) try to fill number at A4 and B4. (7) Repeat step 5 and 6 as many as you want.

@uti_nunc - you should now have enough karma. Please try to upload. I will make a test according your description and come back

@ROSt52. Thanks. But, the site disallow me to attach excel file.