OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

4.6.1.2 The (Column Properties)Properties Tab


The Properties tab of the Workbook Column Properties dialog allows you to customize the basic properties of a particular column.

The Column Properties Properties Tab 2.png

Short Name,Long Name,Units and Comments

Short Name

Specify the column short name. For more information, see Worksheet, Column and Cell Range Naming Conventions. This is editable only when Spreadsheet Cell Notation is unchecked in the Properties tab of the Window Properties dialog.

Long Name

Specify the column long name. For more information, see Worksheet, Column and Cell Range Naming Conventions.

Units

Specify the units for the column. Units are for reference only and are not used by any analysis.

Comments

Specify the comments for the column. Comments can include multiple rows.

Width

Column Width

Enter the width for a column in this text box.

Apply to All

If you want to apply the width specified by the Column Width text box to all columns in the worksheet, select the Apply to all check box.

Options

Plot Designation

A column's Plot Designation determines how the selected data will be handled by default plotting and analysis operations. The Plot Designation drop-down list includes X, Y, Z, X Error, Y Error, Label, Group or Subject (used in ANOVA and some statistical tests), and Disregard. After clicking OK, the column heading displays the new designation in parentheses after the column Short Name. Disregarded data displays only the column Short Name.

Note: Interactive data selection controls in the Plot Setup dialog and many analysis dialogs allow you to ignore default the Plot Designations from worksheet columns.

Format

Numeric

Accepts only numeric values.

Text

Accepts any alphanumeric characters. Values in a text column are treated as text, and can not be used in calculations, except in some circumstances, when additionally setting a column as Categorical.

Time

Origin stores Time data internally as days where the fractional part of a number represents the fraction of a day. The display of this data in a column is controlled by the Display control setting. Input of data to a Time column or conversion of Text data to Time should match the formatting in the Display control.

Date

Origin stores Date data internally as days since January 1, 4713 BCE where the fractional part of a number represents the fraction of a day. The display of this data in a column is controlled by the Display control setting. Input of data to a Date column or conversion of Text data to Date should match the formatting in the Display control. Direct entry of Dates may use Window's Short Date and Long Date formats with some flexibility - e.g. 1/28/86, 1-28-1986, 1.28.1986, Jan 28 86, Tuesday January 28 1986 are all accepted. Origin will also resolve ambiguities using the current date - e.g. enter Jan and Origin would use the current day and year to complete the entry.

Month

Accepts only month values. You can enter months as numeric values (1 - 12) or text values. The text may be abbreviated as long as the character(s) represents a unique month. For example, N for November, but Jun for June to differentiate from Jul for July.

Day of week

Accepts only days of the week. Enter day as numerical value (0 - 6) or text values. The text may be abbreviated as long as the character(s) represents a unique day. For example, M for Monday, but Tu for Tuesday to differentiate from Th' for Thursday.

Text & Numeric

This is the default data type for all column designations except for "label". Accepts any alphanumeric characters. However, the text values are treated as missing values for all worksheet operations (such as plotting data points and performing mathematical operations), except where cell values are retrieved as text (such as plotting a data label).

Notes:

  • The default column type in post-Origin 6.0 worksheets is Text & Numeric, whereas the default column type in previous versions was Numeric with an internal data type of Double(8).
  • To ensure that all columns in all new worksheets are Numeric type instead of Text & Numeric, select the Use Numeric as Preferred Column Type box in the Options dialog box (Tools: Options: Miscellaneous).

Do not convert text to numeric during data entry

This checkbox is available only when Format is Text&Numeric. When it is checked, the Text & Numeric datasets will show numeric values as text elements, otherwise, numeric values will be shown with scientific notation. For example, if you type in a string "001315472" in Column Cell with "Do not convert text to numeric during data entry" unchecked, the string will be shown as 1.31573E6. However, if you check this checkbox and type again, the string will be shown as 001315472. Note that changing this setting will not affect the display of previously-entered data.

If you want to import digits strings by using Import Single/Multiple ASCII and show them as text by check on Do not convert text to numeric during data entry, the Keep Target Column Format in Miscellaneous Group should be checked in the impASC dialog.

Display

Determines how the data in the column is displayed. The available options vary depending on the selection in the Format drop-down list.

If Format = Numeric or Text & Numeric, available options include:

Decimal:1000

(1, 1000, 1E6, 1E9)

Note: The threshold for conversion to scientific notation is controlled on the Numeric Format tab of the Options dialog box (Tools: Options).

Scientific:1E3

(1E0, 1E3, 1E6, 1E9)
Note: A Labtalk system variable (@ete) can be used to hide the leading zero in scientific notation. By default it is set as 0, the values display as (1E+00, 1E+03, 1E+06, 1E+09). Setting @ete=1 to hide the leading zero in scientific notation, then the values display as (1E+0, 1E+3, 1E+6, 1E+9). Select Tools: System Variables to change @ete value.

Engineering:1k

(1.0, 1.0k, 1.0M, 1.0G)

See ** below for the supported Engineering data suffixes.

Note: A LabTalk system variable (@EF) is provided to enter engineering notation in a non-engineering column. If you set @EF = 1, and then enter engineering notation in a non-engineering column, Origin will treat the entry as numeric. Otherwise (@EF = 0), Origin will treat the entry as text (default). To learn more about LabTalk system variables, see the LabTalk Help file.

Decimal:1,000

(1, 1,000, 1E6, 1E9)

Note: The threshold for conversion to scientific notation is controlled on the Numeric Format tab of the Options dialog box (Tools: Options).

Custom

When you choose Format = Custom, you have more options as to how you display your data in the worksheet. See the next section Origin Custom Display Options for more information.

Note: Any custom format is saved in your project and should display the same regardless of who is logged in or what computer is in use.


When Format = Time:

Time Choose from one of the built-in time options or choose Custom Display.
ColProperties Display Time.png

If no suitable built-in time option exists, you can construct a Custom Display option by setting Display to Custom Display and constructing a custom time option (see Origin Custom Display Formats, below). For information on the Origin's date and time syntax, see Date and Time Format Specifiers.


When Format = Date:

Date Choose from one of the built-in date options or choose Custom Display.
ColProperties Display Date.png

If no suitable built-in date option exists, you can construct a Custom Display option by setting Display to Custom Display and constructing a custom date option (see Origin Custom Display Formats, below). For information on the Origin's date and time syntax, see Date and Time Format Specifiers.


When Format = Month:

Month Choose from one of three month display options.
ColProperties Display Month.png

For information on the Origin's date and time syntax, see Date and Time Format Specifiers.


When Format = Day of Week:

Day of Week Choose from one of three day of the week display options.
ColProperties Display Day.png

For information on the Origin's date and time syntax, see Date and Time Format Specifiers.

Origin Custom Display Formats

When the worksheet column format is set to Text & Numeric, Numeric, or Date or Time, you can specify a custom format for displaying data in the worksheet. You may want to do this for such reasons as:

  • Displaying data in a user-friendly form (e.g. as "12%" vs. "0.12")
  • Displaying data such as date-time data, in your own custom format and have Origin recognize the data as date-time data and not merely text data.


This illustration shows the same numeric values (column A(X)) with various numeric custom formats applied.

ColProperties Custom Formats.png

The following table summarizes custom display format by Format type, when Display has been set to Custom or Custom Display, including links to reference tables listing all formatting options.

Format Display > Custom Display
Text & Numeric, Numeric Text values are stored and displayed literally in the worksheet. Numeric values are stored in the worksheet as 64-bit double-precision binary numbers but the way in which they display is decided by the user.

The following is a list of commonly-used custom display formats for numeric data. For all options, see Origin Formats.

*n Display n significant digits
.n Display n decimal places
S.n Display n decimal places, in scientific notation of the form 1E3.
E.n Display n decimal places, in engineering format
<prefix>##<sep>###<suffix> Display a number by specifying a separator (<sep>) between digits and optionally add prefix(<prefix>) and/or suffix (<suffix>). One # symbol indicates one digit. The last # in this expression always refers to the unit digit. The numbers of # in both first and second parts can be varied.
#[.00]% Display a number as percentage of 100 followed by the percent sign "%". #% displays percentage as integer, while #.0% displays percentage as 1 decimal place and #.00% displays 2 decimal places.
#<space>##/## Display a number as fraction. The first # indicates the integer part of the mixed number and the rest part after space indicates the remainder. In the reminder part, a forward slash / separates numerator and denominator. The numbers of # in both can be varied, indicating the number of digits of remainder. For example, # #/# displays remainder with up to 1 digit, # ##/## displays remainder with up to 2 digits, and so on. Note that improper fraction is not supported.
# #/n Round and display a number as a fraction with specified n as denominator. The numerator and denominator are separated by a forward slash /. The number of digits of numerator is adjusted accordingly.
D[<space>]M[S][F][n] Display a degree number in the format of Degree° Minute' Second", where 1 degree = 60 minutes, and 1 minute = 60 seconds. Space can be inserted to separate each part. n indicates decimal places for fractions. F displays degree number without symbols and inserting spaces as separator.
Note: The Custom Display drop-down list is pre-populated with a number of examples of custom formats. Understand that these may be specific rather than general (i.e. *.3 is listed instead of *.n) and that you can, for instance, enter *.5 directly into the Custom Display box.

Over time, your Custom Display list may become overly-long and cumbersome to work with. When this happens, you can (a) manually and selectively edit the [Column Custom Format List] section of your \User Files\Origin.ini or (b) reset to the default list by opening the Script Window (Window: Script Window), typing del -fc , then pressing Enter.

Time

Time values are typically imported or pasted into the worksheet. Note that, by default, Origin will treat such data as text. You must use the Column Properties dialog to configure the column to recognize the data as time data. If you do not find a suitable built-in Display option for your time data, you can specify your own Custom Display option:

Date

Date or combination date-time values are typically imported or pasted into the worksheet. Note that, by default, Origin will treat such data as text. You must use the Column Properties dialog to configure the column to recognize the data as date-time data. If you do not find a suitable built-in Display option for your time data, you can specify your own Custom Display option:

Digits

This drop-down list is available only when Format is either Text & Numeric or Numeric.

Default Decimal Digits

Display all digits in a worksheet cell as determined by the Number of Decimal Digits combination box value on the Numeric Format tab of the Options dialog box (Tools: Options).

Set Decimal Places =

The number of digits that display after the decimal place (overrides the Number of Decimal Digits setting on the Numeric Format tab of the Options dialog box).

Type the decimal place value (n) in the associated text box. This value = the maximum number of digits displayed after the decimal point. If the field is blank, the default value is used (value = 5 for Double (8) internal data types).

Significant Digits =

The number of digits displayed. Type the value in the associated text box.

Data Type

This drop-down list is available only when Format is Numeric. It determines the bytes of storage space that is allocated to each value.

Double(8)

Allocates eight bytes of storage space to each value. Range of values is ±1.7E±308 (15 digits).

Real(4)

Allocates 4 bytes of storage space to each value. Range of values is ±3.4E±38 (7 digits).

Short(2)

Allocates 2 bytes of storage space to each value. Range of values is -32,768 to 32,767.

Long(4)

Allocates 4 bytes of storage space to each value. Range of values is -2,147,483,648 to 2,147,483,647.

Char(1)

Allocates 1 byte of storage space to each value. Range of values is -128 to 127.

Byte(1)

Allocates 1 byte of storage space to each value. Range of values is 0 to 255.

uShort(2)

Allocates 2 bytes of storage space to each value. Range of values is 0 to 65,535.

uLong(4)

Allocates 4 bytes of storage space to each value. Range of values is 0 to 4,294,967,295.

Complex(16)

Allocates 16 bytes of storage space to each value, where 8 bytes is for the real part and the other 8 bytes is for the imagenary part. Range of values is ±1.7E±308 (15 digits).

Notes:
  • Data Types of less than Double(8) may cause problems with various math operations. For the same reason, you should verify the column Data Type before you enter or import data into a worksheet column. If the Data Type is not appropriate to the data, you risk losing precision in your numbers.
  • Double(8) is the only data type that supports missing values.

Other controls

Custom Display

This combination box is available only when Format is Text&Numeric or Numeric and Display is set to Custom or Format is Date or Time and Display is set to Custom Display. You can enter the custom display format in this box or select from the drop-down list. This setting can be saved with the project. Therefore, when the project is opened by other people, they can see the same display. More details, please see the Origin Formats table and Custom Date Format page.

Apply to All Columns to The Right

If you want to apply the settings in the Options group to all columns to the right of the current column in the worksheet, select this check box.

*The IRIG (Inter-Range Instrumentation Group) time format is used in government, military, and commercial fields. The most common version of the IRIG Time Format is IRIG-B, which sends day of year (0 - 365/366), hour, minute, seconds/fractional seconds data on a 1000 Hz carrier with an update rate of one second. See also, Dates and Times in Origin.

**Origin supports the following Engineering data suffixes:

suffix equivalent quantity

k

kilo

10^3

M

mega

10^6

G

giga

10^9

T

tera

10^12

P

peta

10^15

m

milli

10^-3

u

micro

10^-6

n

nano

10^-9

p

pico

10^-12

f

femto

10^-15

Note: "u" is Origin's universal notation for micron. The only exception is graph axes tick labels, which support "mu". Note also that Origin 7 does not support "E" and "a" as suffixes.

 

© OriginLab Corporation. All rights reserved.