Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 22 May 2013 11:10:09 +0200automatic formula when add row?https://ask.libreoffice.org/en/question/17859/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. uti_nuncWed, 22 May 2013 11:10:09 +0200https://ask.libreoffice.org/en/question/17859/