I would like to costumise a button. Pressing it, every second column in the multi-column worksheet should be designated az X. So I wrote a small script:
[eveSecColIsX]
for (i=1;i<=100;i++){ if( mod(i,2) != 0) { wks.col$(i).type=4 } }
and saved it as "but_eveSecColIsX.ogs" file. I do the following now:
- view > Toolbars > Button Groups > User Defined - when window is opened I choose one button and press Setting - Under "File Name" I browse to "but_eveSecColIsX.ogs" file which contain the script - under "Section Name" I put [eveSecColIsX] - Under other filds I did not know what to put so I press OK and pull-out the button to Origin
Of course it does not work :) What I did wrong here? The help is poor in explaining how to accomplish this properly so I ask for help