| T O P I C R E V I E W |
| CaptFlake |
Posted - 04/29/2015 : 10:22:07 AM
Origin Ver. and Service Release (Select Help-->About Origin): 9 (32 bit)
Operating System: Windows 7
Hello,
I am currently working on my master thesis and I use Origin to evaluate my data. For this I regularly use the "Before Formula Scripts" to do some calculations, programm loops and so on.
Now I wonder, is there a possibility to see all the used scripts/the written code at once? Because when I access an older file I do not want to click through every sheet and press STRG+Q to see what I have done there.
Thanks in advance
(I have already found many solutions in this forum to problems I had, but not for this problem.. And I do not know how to use google properly to find a solution since unfortunately EAs Origin dominates my results in this case :/ )
..And it came to me then that every plan is a tiny prayer to father time.. |
| 2 L A T E S T R E P L I E S (Newest First) |
| CaptFlake |
Posted - 04/30/2015 : 04:10:41 AM
Wow thank you :)
It does exactly what I wanted and will help me a lot :) |
| JRoby |
Posted - 04/29/2015 : 3:13:21 PM
This should do it:
// For all workbooks
doc -e W
{
// For each worksheet in the workbook
loop(sh,1,page.nlayers)
{
page.active = sh;
// For all columns in the worksheet
loop(icol,1,wks.ncols)
{
// Get the Before Formual Script
str1$ = wks.col$(icol).FORMULA$;
// Get the Expression
str2$ = wks.col$(icol).SCRIPT$;
if(str1.GetLength() || str2.GetLength())
{
type \x5b%H\x5d%(layer.name$)!$(icol);
if(str2.GetLength()) type Before Formula Script: %(str2$);
if(str1.GetLength()) type Expression: %(str1$);
type;
}
}
}
}
|
|
|
