| Author |
 Topic  |
|
|
bakaimi
8 Posts |
 Posted - 03/05/2012 : 05:39:00 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):8.0
Operating System: Win7
Hi
I can't use the option "set column values", I haven't changed anythung but when I use that option I get a window f "set values" which doesn't work if i try to set values in a new column!
Anyone knows how to go back to normal/default choice of setting column values?
thanks
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 03/05/2012 : 10:47:49 AM
|
Hi bakaimi,
I suspect that some syntactical problem occurred in your formula in the Set Column Value tool. Could you copy-and-post your formula here?
--Hideo Fujii
OriginLab |
 |
|
|
bakaimi
8 Posts |
Posted - 03/05/2012 : 11:30:57 AM
|
quote:
Originally posted by Hideo Fujii
Hi bakaimi,
I suspect that some syntactical problem occurred in your formula in the Set Column Value tool. Could you copy-and-post your formula here?
--Hideo Fujii
OriginLab
Hi Hideo,
thanks for reply,
How do I find which the syntax formula behind the set column Value Tool?I choose the column, then I go to column then Set column values and what I get is a window which has the submenus : Formula, WCol(1), Col(A) F(x)..If that helps..
|
|
|
|
greg
USA
1378 Posts |
Posted - 03/05/2012 : 12:36:16 PM
|
We have had reports where the Set Values dialog has sized incorrectly. To fix the problem:
Select any column and press Ctrl+Q to open Set Values.
If the button to the right of the OK button is pointing 'up', click it.
Drag the bottom edge of the dialog down to reveal the Row selection, the navigation buttons and the text entry box.
Click the button to the right of OK to restore the Before Formula Scripts text entry box.
|
|
|
|
bakaimi
8 Posts |
Posted - 03/05/2012 : 12:47:03 PM
|
quote:
Originally posted by greg
We have had reports where the Set Values dialog has sized incorrectly. To fix the problem:
Select any column and press Ctrl+Q to open Set Values.
If the button to the right of the OK button is pointing 'up', click it.
Drag the bottom edge of the dialog down to reveal the Row selection, the navigation buttons and the text entry box.
Click the button to the right of OK to restore the Before Formula Scripts text entry box.
Hi Greg
Thaks, It doesn't seem that it is a problem of rezising. I did what you recommended but I had no improvemnet.It doesn't perform calculation between to columns like for instance the simple Col(B)=Col(A)*2.
|
|
|
|
greg
USA
1378 Posts |
Posted - 03/05/2012 : 1:36:08 PM
|
So you have values in column A and all you enter in the Upper text box is
col(A)*2
correct? If that does not work then you must have reset the size of column B somehow. You can correct that by entering from and to row numbers and using
col(A)[i]*2
or by selecting the last row of the worksheet and choosing Edit : Set as End. |
|
|
|
bakaimi
8 Posts |
Posted - 03/05/2012 : 1:50:03 PM
|
quote:
Originally posted by greg
So you have values in column A and all you enter in the Upper text box is
col(A)*2
correct? If that does not work then you must have reset the size of column B somehow. You can correct that by entering from and to row numbers and using
col(A)[i]*2
or by selecting the last row of the worksheet and choosing Edit : Set as End.
Greg,right, this is what I am trying to do. I tried also what you just recommended but no luck.. I get the error message: " Failed to create operation for col(C) due to error in set column scripts"and what I get in the entire column is -------- |
|
|
| |
Topic |
|
Set Column Values