[Solved] Store formula result in different cell

Discuss the spreadsheet application
Locked
DWDun
Posts: 111
Joined: Thu Aug 29, 2019 11:08 pm
Location: OK

[Solved] Store formula result in different cell

Post by DWDun »

Looking for a way to have a Formula / Function return its results to a cell other than the one from which it was called. Is such a thing even possible?
Last edited by MrProgrammer on Tue Dec 10, 2024 6:32 pm, edited 3 times in total.
Reason: Marked [Solved] by DWDun on 22 Nov 2024; Add ✓
Open Office 4.1.15, Windows 11
FJCC
Moderator
Posts: 9623
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Cell referencing

Post by FJCC »

That is not possible. What are you trying to accomplish that requires doing that?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
DWDun
Posts: 111
Joined: Thu Aug 29, 2019 11:08 pm
Location: OK

Re: Store formula result in different cell

Post by DWDun »

Nothing requires it, simply tring to find out more about Calc.
Open Office 4.1.15, Windows 11
User avatar
RoryOF
Moderator
Posts: 35210
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Store formula result in different cell

Post by RoryOF »

Try the Calc sections of Andrew Pitonyak's works, which can be downloaded from
https://www.pitonyak.org/oo.php
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Locked