[Solved] Inline functions/macros inside a cell?

Discuss the spreadsheet application
Post Reply
CaveDweller
Posts: 7
Joined: Sun Jul 15, 2018 8:18 am

[Solved] Inline functions/macros inside a cell?

Post by CaveDweller »

I have some cells in my document that aremade out of merged cells, their texts being long descriptions. During such descriptions, I would like to inline a function or macro call. Let's say I have a cell with a text description, mentioning the parameters of an experiment of some sort, the expected result of the experiment and the empirical measured result of the experiment. Let's say all those numbers are stored in cells in this same spread-sheet. I want the following behaviour, if I change one of the numbers in the separate cells, the change cascades through all cells that use that number in text descriptions. So, for example, for simplicity sake, let's imagine one of the parameters is an integer and it appears in the description multiplied by 5. Must I alter the text contents of the description cell every time I change that parameter? Or is there another way?
Last edited by robleyd on Fri Feb 14, 2020 11:49 pm, edited 1 time in total.
Reason: Tagged [Solved]
OpenOffice 4.1.5
Windows 10
User avatar
robleyd
Moderator
Posts: 5083
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: 3) Is it possible to inline functions/macros inside a ce

Post by robleyd »

You could reference the result cells in the description cell by concatenating the description and the target cell references.
See the attached file for a very simplistic example.
Attachments
fruitbasket.ods
(8.2 KiB) Downloaded 120 times
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
CaveDweller
Posts: 7
Joined: Sun Jul 15, 2018 8:18 am

Re: Is it possible to inline functions/macros inside a cell?

Post by CaveDweller »

That's good enough! Thank you!
OpenOffice 4.1.5
Windows 10
Post Reply