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...
Calculation from sheet to another one ?
Posted - 01/12/2010 : 12:50:59 PM
