Origin 2021 Features

Origin 2021 Features

Data Handling

Column/Cell Value Formula

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-21873

Excel like Formula bar

Excel like formula bar is added on the top part for easier view column/cell formula and long cell contents

  • Toggle view by View: Cell Formula Bar.

  • Read current cell contents. Useful for cell with long text.

  • Enter column and cell formula

  • When editing formula, hunt to define a column, a cell or a range of cells

  • Fx button to search and insert funtion

  • Font size control by system variable @fbfs. E.g. @fbfs=200

 

ORG-22323

Save and Load Formula Improvements in Set Column Values

Some button and context menu added to easily save and load formula for a column

  • In Set Column Values dialog, a Save Formula button is added before Search and Insert Functions button.

  • Fill with User Formula context menu is added when right clicking a column

ORG-22322

Improved Sample Formula

New sample formula are added and out of date ones are removed

See updated sample formulas under Formula: Load Samples menu of Set Column Values dialog

ORG-22331

Support color-blind safe color-matched code braces in more places

In places where user needs to enter expression, formula, use color blind safe colors for matching ()

Locations for color brace matching:

Formula Bar
Custom Scale option Direct Formula&Inverse Formula
At Axis Value option for reference line
Scatter Size Formula option

Data Connector

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

APPS-927

Connect to NI TDMS file.

TDMS Connector App is not pre-installed with Origin. To install, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button beside TDMS Connector to install the App.

  • Download TDMS Connector app from the page and install the app.

  • Basic Usage

  1. With a worksheet or matrixsheet active, click on the Data menu.

  2. To connect to a local file, click Data: Connect to File: TDMS and select the file. To connect to web data, click Data: Connect to Web and enter the URL. 

  3. In the Data Connector Browser, you can add worksheets to import or remove worksheets from the connector, and if you want to import all selected groups data into the same worksheet, you can check Import All Groups to Same Worksheet, then click OK to connect to the selected ones.

  4. Once a connector is added, click the connector icon in the upper-left corner of the book to open a popup menu with various commands.

  5. By default, connector-imported data are NOT saved with the project file. To save a book's data with the project file, click the connector icon in the upper-left corner for that book and uncheck Exclude Imported When Saving. Note that each book has its own Exclude setting.

 

APPS-857

Connect to a Yokogawa WDF file.

Yokogawa WDF Connector App connects the Origin project to Yokogawa WDF files. Yokogawa WDF Connector App is not pre-installed with Origin. To install, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button beside Yokogawa WDF Connector to install the App.

  • Download Yokogawa WDF Connector app from the page and install the app.

  • Basic Usage

  1. With a worksheet active, click on the Data menu.

  2. To connect to a local file, click Data: Connect to File: Yokogawa WDF and select the file. To connect to web data, click Data: Connect to Web and enter the URL. 

  3. In the Data Connector Browser, you can add traces to import or remove traces from the connector, then click OK to connect to the selected ones. Check Import All Traces to Same Worksheet to import selected traces to same worksheet instead of separate worksheets.

  4. Once a connector is added, click the connector icon in the upper-left corner of the book to open a popup menu with various commands.

  5. By default, connector-imported data are NOT saved with the project file. To save a book's data with the project file, click the connector icon in the upper-left corner for that book and uncheck Exclude Imported When Saving. Note that each book has its own Exclude setting.