|
ScriptQuestions
Germany
4 Posts |
 Posted - 03/02/2022 : 04:36:40 AM
|
Hello.
I am currently trying to execute a script made in the Code Builder similar to this:
mathtool -r 2 iy1:=[Book1]"Sheet1"!(A"Temperature",F"Value") operator:=sub iy2:=[Book2]"Sheet1"!(A"Temperature",I"DifferentValue1") oy:=[Book1]"Sheet1"!(A"Temperature",G"FirstResult");
//these are options that i tried to achieve my goal, but did not work so far.
run -auf 1 0;
doc -uw;
second -poc 3;
save;
mathtool -r 2 iy1:=[Book1]"Sheet1"!(A"Temperature",H"FirstResultAltered") iy2:=[Book2]"Sheet1"!(A"Temperature",I"DifferentValue2") oy:=[Book1]"Sheet1"!(A"Temperature",M"FinalResult");
This is a simplified version of my script. The difference between FirstResult and FirstResultAltered is that the content of FirstResultAltered is gained by a formula dependent on the column FirstResult.
For example, Col("FirstResultAltered")[O]$= Col("FirstResult")^2.
My current problem is that the script finishes before recalculation was done, resulting in the second mathtool operation to put out empty lines filled with "--".
I tried running the script both with run ScriptName.ogs, and run.file(Scriptname.ogs), but in both cases it does the same thing.
So my question is: How do I make the script wait for recalculation to finish before performing a second mathtool operation?
|
|
Chaining mathtool commands
