27.7.3.6 The (Options) Numeric Format Tab


These settings control how Origin displays and interprets numeric data.

Numeric.png

Convert to Scientific Notation Group

Upper Threshold Power

Type or select the upper threshold for conversion from decimal to scientific notation from the Upper Threshold Power combination box. When a numeric value is greater than this value it will display in Scientific Notation (e.g. when the Upper Threshold Power is set to 6, 9999999 displays as "9999999" but 10000000 displays as "1E7").

Lower Threshold Power

Type or select the lower threshold for conversion from decimal to scientific notation from the Lower Threshold Power combination box. When a numeric value is less than or equal to this value it will display in Scientific Notation (e.g. when the Lower Threshold Power is set to -3, 0.001 displays as "0.001" but 0.0009 displays as "9E-4").

Angular Unit Group

Angular Unit

The angular unit setting affects all trigonometric functions computed using LabTalk. Function that take angle values as arguments treat those values as if they are in the selected unit. This affects calculations performed in OGS files, the Script Window, Set Column Values and the Label Control dialog boxes.

Available options include Radian (default), Degree, and Gradian.

Note: This setting does not affect computations in Origin C; Origin C always uses radians.

Digits Group

This group controls the default digits of numeric data (the digits of worksheet numeric data when Default Decimal Digits is selected from the Digits drop-down list in the the Column Properties dialog box and the digits of matrix data when Default Decimal Digits is selected from the Digits drop-down list in the the Matrix Properties dialog box).

Decimal Digits

Select this radio button, if you want to specify the default digits by specifying the number of decimal digits.

Significant Digits

Select this radio button, if you want to specify the default digits by specifying the number of significant digits.

Number of Digits

This combination box value controls the number of decimal digits (if the Decimal Digits radio button is selected) or the number of significant digits (if the Significant Digits radio button is selected) for Origin's default numeric display. If Significant Digits is selected and this value is greater than the Upper Threshold Power then this number determines Upper Threshold Power.

Digits in Report Group

This group controls the default digits of numeric data in the analysis report sheets.

Decimal Digits

Select this radio button, if you want to specify the default digits for the analysis report sheets by specifying the number of decimal digits.

Significant Digits

Select this radio button, if you want to specify the default digits for the analysis report sheets by specifying the number of significant digits.

Number of Digits

This combination box value controls the number of decimal digits (if the Decimal Digits radio button is selected) or the number of significant digits (if the Significant Digits radio button is selected) for the default numeric display in analysis report sheets.

You can set the digit display for any individual report table in a report sheet. Please see the details in this page.

Separator Drop-Down Lists

Separators

Sets up use of alternate digit grouping symbols and decimal symbols for numeric values in worksheets and graphs. The default, Windows Settings, uses Windows Region settings.

  • The selected decimal symbol will display by default in the worksheet, and in data labels in plots of the worksheet data.
  • To make use of digit grouping symbols in the worksheet or in plots of worksheet data (e.g. data labels), change the worksheet column Display (Column Properties, Properties tab) from Decimal:1000 (default) to Decimal:1,000. Further, to make use of digit grouping symbols in graph axis tick labels, go to the Axis dialog Tick Labels > Display sub-tab and set the Display drop-down.


Notes:

  • Users of German Origin or users who have set Separators = 1.000,0 should see this FAQ.
  • The Separators setting can be saved with the project.
  • In order greater precedence: Global separators (this Options dialog setting) < Project-level separators < Graph-level separators.
Separator for ASCII Import

Select the default separator for ASCII import. This affects the selection in the Numeric Separator drop-down list in the Data Columns page of Import Wizards and the Numeric Separator drop-down list in the ImpASC dialog.

If Windows Settings is selected here, separator specified in Window's Regional Settings will be used.

Date Format for Database Import Select a desired format to display the date when import the database.
Use English in Reports and Graphs It is available only in non-English language Origin. Check this checkbox to use English (including Date and Time format) in analysis reports and graphs. It functions the same as Use English in Reports and Graphs checkbox in the Change Language dialog.