Hi,
If you want to set the new sheet Column 1 filling with row number, you can add a script (csetvalue formula:="i" col:=1; ) to the above script:
get col(A) -e numpoints; // get number of the row in the dataset
aa=1;
//loop script with decision structures
for(ii=1; ii<=numpoints; ii++)
{
jj=ii+1;
if (Col(B)[ii]==0 && Col(B)[jj]==0)
{
wrcopy iw:=[book1]sheet1! r1:=aa r2:=ii ow:=<new>;
csetvalue formula:="i" col:=1; //Fill the column 1 with row number
aa=jj;
}
page.active = 1;
}
Thanks
Jacqueline
OriginLab