[Solved] Inline functions/macros inside a cell?

Discuss the spreadsheet application

[Solved] Inline functions/macros inside a cell?

Postby CaveDweller » Fri Feb 14, 2020 3:35 am

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
CaveDweller
 
Posts: 7
Joined: Sun Jul 15, 2018 8:18 am

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

Postby robleyd » Fri Feb 14, 2020 7:24 am

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 6 times
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3197
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby CaveDweller » Fri Feb 14, 2020 10:19 pm

That's good enough! Thank you!
OpenOffice 4.1.5
Windows 10
CaveDweller
 
Posts: 7
Joined: Sun Jul 15, 2018 8:18 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 23 guests