The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Access used/written scripts/codes
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

CaptFlake

Germany
3 Posts

Posted - 04/29/2015 :  10:22:07 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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..

JRoby

USA
6 Posts

Posted - 04/29/2015 :  3:13:21 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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;
}
}
}
}
Go to Top of Page

CaptFlake

Germany
3 Posts

Posted - 04/30/2015 :  04:10:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Wow thank you :)
It does exactly what I wanted and will help me a lot :)
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000