Hi Julia,
Referring to columns in another book with syntax such as W2_c works as long as you are referring to first created sheet in that book (perhaps all your books have only one sheet?)
But if there are more than one sheet in a given book, then the notation such as W2_c gets complicated as if the column c is in say third created sheet, it needs to be referred to as W2_c@3 in this "old" notation.
That is why we introduced range notation and variables which you came across in help files, that can be used to point to cols in multiple sheets in a flexible way
For example:
// point to col c of sheet 2 of book1
range rc = [book1]sheet2!col(c);
// point to column with long name "system pressure" located in
// sheet with name "my sheet" in book1
range rPressure = [book1]"my sheet"!col(System Pressure);
// Point to col d of currently active sheet
// book and sheet name left out
// this variable then points to col d of whichever sheet is active
range r = !col(d);
r = sqrt(rPressure);
r = sin(rc);
If you find yourself making computations such as this repeatedly maybe it is beneficial to make an OGS script file, or put such computation into the columns themselves using "set values" dialog? With the new set values dialog, you can define variables in lower "before formula" panel and use them in your formual for setting column values
If you need more help you could send your opj to tech and ask for specific help with your scripting
Easwar
OriginLab
Calculation in Origin 8
Posted - 12/12/2007 : 03:57:13 AM
