[Solved] Inline functions/macros inside a cell?
-
- Posts: 7
- Joined: Sun Jul 15, 2018 8:18 am
[Solved] Inline functions/macros inside a cell?
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]
Reason: Tagged [Solved]
OpenOffice 4.1.5
Windows 10
Windows 10
Re: 3) Is it possible to inline functions/macros inside a ce
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.
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
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
-
- Posts: 7
- Joined: Sun Jul 15, 2018 8:18 am
Re: Is it possible to inline functions/macros inside a cell?
That's good enough! Thank you!
OpenOffice 4.1.5
Windows 10
Windows 10