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

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 close merge delete

Sort by » oldest newest most voted

Hi

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
more