4.3.4 Column Short Name Restriction
Since version 2017, the Origin workbook has supported a simplified Spreadsheet Cell Notation (SCN), similar to that used in MS Excel. For users of older versions of Origin, there are a few things to know:
- The purpose of SCN is to allow for creation of column formulas with a simpler, easier-to-read syntax.
- SCN is turned ON in all new books, by default.
- When SCN is turned ON, column Short Names are not editable and cannot be reordered, contrary to what users may remember from older versions of the software.
- When SCN is enabled (default), column Short Names are ordered alphabetically according to column index as follows:
- A, B, …, Z, AA, BB, …, ZZ, .etc
If you insert or move columns within the worksheet, you will see that column Short Names are reassigned alphabetically.
When writing column formulas with the new syntax:
- A can be used to refer to column with Short Name "A", replacing the old col(A) syntax.
- A1 can be used to refer to the first cell in column A, equal to the old syntax col(A).
- [Book2]Sheet1!A can be used to refer to the first column of Book2, Sheet1, even though it is not the current worksheet. This is supported only when Spreadsheet Cell Notation is turned on.
Note that the "old" col/wcol syntax is still usable, though some of the advantages afforded by the new syntax are not supported. For instance, if you insert a worksheet column ahead of a column of values derived from an F(x)= or Set Values formula that uses the old syntax, the column formula is not automatically updated to reflect the new column arrangement.
When referring to a column by its Short Name in the column formula:
- The Short Name must be limited to no more than 3 characters. Otherwise such column reference cannot be recognized. When Short Name exceeds 3 characters, use col() or wcol() references.
- If you use functions with string parameter, such as Token, you should use double quotes instead of single quotes.
Type the following Excel-like formula in F(x) column label row:
to calculate column A minus the absolute values of column B.
Type following formula in the Set Values dialog:
to calculate column B plus the second cell in column A.
In the first column of Book1, sheet1, type following formula in F(x) column label row:
to set values by data in another workbook, [Book2]Sheet1.
To reiterate, when Spreadsheet Cell Notation (SCN) is turned on, the column Short Name cannot be edited.
Workbooks and Projects that use the simplified notation do not work in pre-2017 versions of Origin.
For more on column naming as it relates to worksheet calculations in Origin, see these topics: