Hello, I checked nearly everywhere, but I cannot find the proper script command to do what does "right click on a column -> set as -> X", so that any further plot of columns to the right of that one, would use the selected column as X. The "is X" property is part of the column properties, under the subgroup "options", but neither in the "set" nor in the "wproperties" commands can you set this "is X" out of nowhere (no copying the format from another sheet, I just want to change this precise parameter), as far as I know. Could anyone help me with this please? Thanks Jean-Pierre Origin Ver. 8 and Service Release 0 Operating System: XP pro
great, I did not look deep enough! Thanks. As a subsidiary question, would you know how to replace "Book1_B" in "layer -i Book1_B" by a variable that would point to the current worksheet instead (thus making the script suitable for automation: everytime you open a new sheet, it could work with no change)? I found a workaround for my "set as X" problem earlier (but your answer is a lot more simple of course), but for this latter problem, I still don't see any... Thanks again!
Set as X by script
Posted - 05/30/2011 : 06:30:39 AM
