[Solved] Set value of a cell to value in current cell
[Solved] Set value of a cell to value in current cell
Is there a function or method to set the value of another cell in the spreadsheet to the value of the current cell?
Last edited by MrProgrammer on Sun Aug 08, 2021 6:38 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.5
Re: Function to set value of a cell to value in current cell
The Cell functions can modify the result only in the cell, where they was called from.
This means one cell for "normal" functions or more cells for array functions.
If you want repeat a value of a specific cell (A1) in an another cell (B1) then use a simple reference in the another cell:
This means one cell for "normal" functions or more cells for array functions.
If you want repeat a value of a specific cell (A1) in an another cell (B1) then use a simple reference in the another cell:
Code: Select all
=A1
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
- MrProgrammer
- Moderator
- Posts: 4906
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Function to set value of a cell to value in current cell
This is the method:MAM593 wrote:Is there a function or method to set the value of another cell in the spreadsheet to the value of the current cell?
• Edit → Copy (in current cell)
• Select another cell
• Edit → Paste Special → Options: Link
• These choices are probably already set: Selection: Paste All → Operations: None → Shift Cells: Don't
• OK
You can record a macro to perform the last three steps.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).