[Solved] Set value of a cell to value in current cell

Discuss the spreadsheet application
Post Reply
MAM593
Posts: 1
Joined: Sat Jul 31, 2021 2:52 am

[Solved] Set value of a cell to value in current cell

Post by MAM593 »

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]
OpenOffice 4.1.5
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Function to set value of a cell to value in current cell

Post by Zizi64 »

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:

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.
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Function to set value of a cell to value in current cell

Post by MrProgrammer »

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?
This is the method:
• 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).
Post Reply