All Forums  Origin Forum for Programming  LabTalk Forum  colcopy in for loop yields empty cols

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by JokerOne[/i] [br]Origin Ver. 9.1 and Service Release 3 (Select Help-->About Origin): Operating System:Win 7 Hello everybody, I found a strange behavior in the following code. I am trying to copy a worksheet colum-wise (in a particular) manner to a second worksheet. The colum order in the second worksheet is suppose to be 1 2 1 3 1 4 1 5,... where number indicate the colum numbers of the original worksheet. newbook name:=Book2; // newbook name:= Book2 sheet:=0; // using these two line, the script works as intended // newsheet col :=0; win - o Book1 { int tmp_n_cols = wks.ncols; for (loop_id=2; loop_id<=tmp_n_cols; loop_id++) { int target_col_first = (loop_id-1)*2-1; int target_col_second = (loop_id-1)*2; type $(target_col_first); type $(target_col_second); colcopy irng:=[Book1]Sheet1!Col(1) orng:=[Book2]Sheet1!Col($(tartget_col_first)); colcopy irng:=[Book1]Sheet1!Col($(loop_id)) orng:=[Book2]Sheet1!Col($(tartget_col_second)); }; } The script basically works ok, however in the resulting workbook (Book2) the first two colums remain empty, which I cannot really tell why, as the variables type $(target_col_first); type $(target_col_second); are clerly given out as 1 and 2? When I start with a workbook without any colums (see commented code), I do not have this issue. What is the reason behind this behaviour? Is this intended to be so or it is a bug potentially? Thanks [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.