Hi,
I have a table within a text document which contains a calculation in the last column. Since the table has many rows, I would prefer to have the calculation in the first cell of that column copied (and adjusted) to the cells underneath, like can be done in Calc. Is there a way to do this? I tried to find a solution, but didn't. I'm pretty sure that I am not the only one wanting to do this, so I guess the answer is out there. Hence a pointer (link) would suffice.
Thank you for your patience and help!
[Solved] Copy/adjust formulas in table
-
- Posts: 14
- Joined: Tue Dec 24, 2013 8:31 am
[Solved] Copy/adjust formulas in table
Last edited by MrProgrammer on Sat Jun 03, 2023 4:18 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Manjaro stable (up-to-date), 64bit
Re: Fill calculations in table column automatically
Unfortunately, Writer doesn't have the same cell auto-fill feature as Calc, but there is a workaround using formulas. You can copy the formula from the first cell and paste it into the remaining cells in the column. When pasted, the formula will adjust relative to the new row.
Here's the process:
Click on the cell with the formula.
Press Ctrl+C to copy.
Select the cells where you want to paste the formula.
Press Ctrl+V to paste.
Here's the process:
Click on the cell with the formula.
Press Ctrl+C to copy.
Select the cells where you want to paste the formula.
Press Ctrl+V to paste.
OpenOffice 4.1.14
OS
OS
-
- Posts: 14
- Joined: Tue Dec 24, 2013 8:31 am
Re: Fill calculations in table column automatically
Thanks for your reply, but that doesn't work. It fills the other cells with the value that is in the first cell, not with the formula.
Manjaro stable (up-to-date), 64bit
Re: Fill calculations in table column automatically
Works for me.
⠀
⠀
OpenOffice 1.1.5 – 4.1.15
LibreOffice 6.4.7 – 7.6.5
Windows 7,10,11 64-bit
LibreOffice 6.4.7 – 7.6.5
Windows 7,10,11 64-bit
-
- Posts: 14
- Joined: Tue Dec 24, 2013 8:31 am
Re: Fill calculations in table column automatically
Ah, I see. My mistake was that I selected only the numbers, not the entire cell. Thank you! This way it works!
Manjaro stable (up-to-date), 64bit