Hi Fremebondo,
If you want to call values of report sheets in Set Column Values window, maybe there are some LabTalk scripts needed. You can write the LabTalk scripts in the Before Formula Scripts text field. These scripts will be executed before setting column values.
The results in report sheets are stored in tree nodes, so it is necessary to get the results to a tree variable (using the X-Function named getresults). Then put the values in the tree nodes to a dataset variable. The dataset variable is used to Set Column Values.
Suppose there are the descriptive statistics results for five columns in Book1. Now, the means for these five columns need to store in Book2.
The scripts are:
// get the results to a tree tt
getresults tr:=tt iw:=[book1]DescStatsOnCols1!;
dataset mean_result; // define a dataset mean_result
mean_result.SetSize(5); // set dataset's size, according to the result number
// define a temporary book and temporary column
newbook result:=newname$;
range tem_book=[newname$];
range tem_col=[newname$]sheet1!col(a);
// loop all means and store them in tem_col
for(ii=1;ii<=mean_result.GetSize();ii++)
{
tem_col[$(ii)]=tt.Statistics.C$(ii).Mean;
}
mean_result=tem_col; // assign mean_result by tem_col
delete tem_book; // delete the temporary book
For more information about the X-Function getresults, please refer to the following web page:
http://www.originlab.com/www/helponline/Origin8/en/mergedProjects/X-Function/X-Function.htm#X-Function/Getresults.html
There is another easy way with only one LabTalk script, though there is a new worksheet created. Right-click on the corresponding tree node in the report sheet and select Create Copy As New Sheet. Then a new worksheet is created with the results in this tree node. The new worksheet is a common sheet, so it is much easier to get the results.
Penn
OriginLab Technical Services
[Newbie] Sum between a column and a variable
Posted - 09/28/2009 : 12:20:27 PM
