Copying a formula from one cell to another (with increment) in Open Office
Solved
sciuro
Posted messages
290
Registration date
Status
Member
Last intervention
-
PapyLuc51 Posted messages 4569 Registration date Status Member Last intervention -
PapyLuc51 Posted messages 4569 Registration date Status Member Last intervention -
Hello,
In a calculation table in Open Office, I would like to transfer a formula from one cell to an adjacent cell by dragging, with the latter retaining the calculation while adapting it. For example: column A, row 10 = "col A1+A2 -(A4+A5)" to be transferred
to column B, row 10 = "col B1+B2 -(B4+B4)" and so on for all the cells in row 10 of the following columns.
In Excel, you would select the cell to duplicate A10 (Shift or Ctrl key - I’m not sure) and while holding down that key, you would drag A10 to B10, which would take the formula from A10 while adapting it to the contents of its own column cells (B).
Can you tell me how to do the same thing with Open Office?
Configuration: Windows / Edge 18.17763
In a calculation table in Open Office, I would like to transfer a formula from one cell to an adjacent cell by dragging, with the latter retaining the calculation while adapting it. For example: column A, row 10 = "col A1+A2 -(A4+A5)" to be transferred
to column B, row 10 = "col B1+B2 -(B4+B4)" and so on for all the cells in row 10 of the following columns.
In Excel, you would select the cell to duplicate A10 (Shift or Ctrl key - I’m not sure) and while holding down that key, you would drag A10 to B10, which would take the formula from A10 while adapting it to the contents of its own column cells (B).
Can you tell me how to do the same thing with Open Office?
Configuration: Windows / Edge 18.17763
