| T O P I C R E V I E W |
| ScriptQuestions |
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?
|
| 1 L A T E S T R E P L I E S (Newest First) |
| ScriptQuestions |
Posted - 03/02/2022 : 05:21:43 AM
Found the solution:
run -p au;
before the second calculation causes the program to wait for recalculation. |
|
|
