First time here? Check out the FAQ!

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? |

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

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.