All Forums  Origin Forum for Programming  LabTalk Forum  Calculation from sheet to another one ?

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 tbarrou[/i] [br]Origin Ver. and Service Release (8.1 SR0): Operating System: XP I have 2 sheets in one workbook. the first one has 40 column with value in dB. I'd like to get 40 column of linear values in the second sheet. I did the (very) small labtalk program below : [Main] int ii=0; range Source = [Brute]LuceraPhaseCritique!; range Feuille = [Brute]Lineaire!; for (ii=2;ii<=2;ii++) // will be changed to calculate over all columns... { range r1 = Source.col$(ii); range r2 = Feuille.col$(ii); r2=10^(r1/1e4); } It creates a blank new column but doesn't compute anything... after hours reading help and testing many syntaxes, I surrender ! I don't understand how reference a worksheet, a column... and why properties and methods of objects (Source, Feuille as wks, r1,r2 as wks.col)are not efficient in this case... I obviously didn't get the rationale of Labtalk. but this calculation is so simple... Thanks for help. [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.