Worksheet Columns

A worksheet dataset is a one-dimensional array that can accommodate various types of text, numeric, or date and time data. Each column of worksheet values comprises a dataset and each column may be separately configured to control how the contained data display and how Origin handles the data with regard to graphing and analysis operations.

Each dataset has a unique name formed by combining the workbook name, the worksheet name ("!" indicates that the following cell range = the entire column) and the column name:

[BookName]SheetName!ColumnName

By default, Origin assigns column Short Names alphabetically in the order in which columns are created, beginning with the leftmost column in the worksheet. Thus, for a workbook with default book, sheet, and column Short Names, datasets in the active sheet would be named something like this:

[Book1]Sheet1!A
[Book1]Sheet1!B
[Book1]Sheet1!C

Both Column Long Names and Short Names can be customized. If a column Long Name exists and you have selected Use Long Names when available (Tools: Options: Miscellaneous), the Long Name will be used in place of the Short Name. Dataset references using Long Names would be similar to those above, but Long Names must be protected with quotation marks:

[Book1]Sheet1!"Col A Long Name"
[Book1]Sheet1!"Col B Long Name"
[Book1]Sheet1!"Col C Long Name"