3.6.4.9 ClrX

ClrX-macro

A global control for disabling spreadsheet cell notation in all Origin workbooks. This macro also adds system variable @RCN to the Set System Variables dialog box, and sets its value = 0, thereby disabling spreadsheet cell notation in any subsequently added workbook.

Note that if you want to restore use of spreadsheet cell notation, you must open Set System Variables and change the value of @RCN = 3; or delete the @RCN variable entirely and restart Origin.

Definition:

Def ClrX {
   doc -e WW {page.xlcolname=0;};
   run -oc add_sys_vars RCN 0;
};

Example:

The following script disables worksheet cell notation in existing and future workbooks.

ClrX;