Ask Your Question

Can I autofill formulas in a column down to each new row added?

asked 2015-03-13 15:49:15 +0200

gordon071 gravatar image

Columns appear for Item, Quantity, Cost, Extension. Item, Quantity and Cost and entered by the user. At any time, they will add additional rows as more items are sold. Extension has the formula: =Quantity*Cost I know that one may click the + in the bottom right of the formula cell and drag it down to the last row. One may also copy it down in several other manners. However, in Excel, you simply select all cells and declare the range to be a Table and provide a table name (i.e. Table1) Then, whenever a new row is added, the formula will be automatically carried down to this new row. Can LibreOffice performs this function as well. I will never!! be able to rely on users to do a fill, copy, etc. of formulas down the rows and guarantee to management they did not make a mistake, miss a row, do something else wrong, etc. Please help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-03-13 18:13:06 +0200

pierre-yves samyn gravatar image


Calc does not offer the same functionality. However, I know two possibilities:

  • Ctrl+D to copy the contents of the cell above. You can select the "new" row before typing Ctrl+D. The previous line is duplicated, including the formula and it remains to replace data "variable".
  • Start cell edit with content of cell above. See release notes
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-03-13 15:49:15 +0200

Seen: 1,917 times

Last updated: Mar 13 '15