Ask Your Question

uti_nunc's profile - activity

2013-12-25 07:17:11 +0200 received badge  Famous Question (source)
2013-12-25 07:17:11 +0200 received badge  Notable Question (source)
2013-12-25 07:17:11 +0200 received badge  Popular Question (source)
2013-05-26 04:12:16 +0200 commented question automatic formula when add row?

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

2013-05-24 07:07:42 +0200 received badge  Student (source)
2013-05-24 05:55:05 +0200 commented question automatic formula when add row?

@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.

2013-05-24 05:46:35 +0200 commented question automatic formula when add row?

@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.

2013-05-23 05:20:45 +0200 commented question automatic formula when add row?

@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.

2013-05-22 11:10:09 +0200 asked a question automatic formula when add row?

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.