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.

 

APPS-914

Import tables in the pdf file.

Import PDF Tables app can be used to import tables in the pdf file.

Download Import PDF Tables app from the page and install the app.

This app requires embedded Python in Origin, Media Feature Pack from Microsoft and Ghostscript.

Operation:

  1. Select a PDF file and open the dialog.

  2. Enter the page(s) from which you want to extract.

  3. Click OK button. And tables will be imported into Origin.

ORG-22026

Better support of *.dat file with CSV Connector

Drag and drop of *.dat files will use CSV Connector if no Import filter is checked for Drag and drop of that file type.

Drag and drop *.dat file will use CSV Connector if no Import filter is checked for Drag and drop

ORG-14442

Matlab DC supports opaque variable like date time in v6/v7 version files

Matlab DC supports opaque variable such as date, time, duration, or table in Matlab v6/v7 version files.

import opaque type variables:

Date, Time, Duration, Table, etc.

ORG-22040

new TDMS Connector

A new NI TDMS Connector has been created.

can contact us to get the app to try

import NI TDMS file using connector app

ORG-21550, ORG-21211

import Bruker DQL/RAW files

A new DC DC to import Bruker DQL/RAW files has been created.

Add DIFFRAC Connector app to import Bruker DQL/RAW files

ORG-21338

Data; Connect Multiple Files improvement

Data: Connect Multiple Files… a Source drop-down list has been added that allows for Specified Files or all Files in Specified Folder.

Menu Data: Connect Multiple Files… adds a Source drop-down list that allows Specified Files or all Files in Specified Folder.

ORG-21528

Re-import Web DC should re-download the data

Re-import of Web DC now re-downloads the data based on the value of the @CFDT System Variable.

  1. Added system variable @CFDT = 900(number of seconds per 100K), if cache file is older than @CFDT, then delete it and re-get data from web.

  2.  Remember URL-to-File mapping across sessions. the cache file can be used by multiple Origin applications, then do not need to re-download if the file is not older than @CFDT.

  3.  Add LT cmd to delete URL-to-File mapping cache, for example:

delete -web "http://www.sidc.be/silso/INFO/snmtotcsv.php";

ORG-22211

Move Legacy Import menu to bottom

Legacy Import from File menu moved to lower position in the Data menu.

Push the "Import from File..." menu item to be after the DC menu items under Data menu.

ORG-22179

MATLAB connector supports Tables

MATLAB connector supports importing tables from .MAT files.

MATLAB Connector supports importing tables from .mat files.

ORG-22334

CSV Connector allows Append Rows

CSV Connector now permits appending rows to columns.

Set wks.DC.flags=256 for CSV Connector, subsequent import will append. From now on, every data source change or re-import will keep appending new rows to the end of existing data.

ORG-22252

DC Connected Sheet remembers customized sheet name

A DC-connected worksheet now remembers a customized sheet name and does not change its name.

Added LT access User-Sheet-Name property wks.USN=0(default), if the sheet is renamed from double-click or Name and Comments dialog, then will set wks.USN=1, and Data Connector import will no longer rename the sheet.

This applies only to those connectors that are using the Tree framework, so besides Matlab, it will affect JSON, netCDF, etc.

ORG-22087

Clone Import for Data Connector

Clone Import for Data Connector-based imports is now supported.

Support Clone Import for Data Connectors.

ORG-13146

Yokogawa Binary WDF File Connector

New Yokogawa Binary WDF File DC has been created.

  1. Support more oscilloscopes models for WDF. "DL350", "DL850", "DL850E", "XVWDF", "SL1000", "DLM2000", "DLM3000", "DLM4000", "DLM6000", "PX8000".

  2. Add a checkbox "Import All Traces to Same Worksheet" to import all data in a same sheet on Browser dialog.

ORG-21026

Import Menu Customization - Make it easier to find more Import Apps

Import Menu Customization via Customize… menu- makes it easier to find more DC Apps

Added "Customize..." item under “Data: Connect to File“ menu.

ORG-22481

@ISC=0 did not work

@ISC=0 System Variable fixed and a wks level control “wks.isc“ has been added.

Added a wks level control “wks.isc“.

default = 1 means it will follow @ISC, and if =0, it means do not resize column width after import.

ORG-22708

ISO Date-Time Format More Issues

CSV Data Connector now supports Zulu Time (UTC).

CSV Connector Supports Zulu Time (UTC), the 2020-10-21T19:32:52.300Z date format will be detected, and set as 2020-10-21 19:32:52.300 after import.

Worksheet

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-22399

Mini toolbar for label rows in worksheet

Easier way to turn on rich text , insert user-parameter, hide label row, move up and down, etc.

When right click a label row, mini toolbar shows for quick access of some userful operations, such as turn on rich text so user can type superscript, subscript, greek letters, etc.

ORG-21112

Data Display Format buttons on Column Mini toolbar

Use mini toolbar to customize date and time display or numeric digits

Add new mini toolbars for easily customize the number of digits, date, and time format.

 

ORG-21113

Change Column (Cell) Format on Pasting Date Time Data

Check if copied data is date and time and paste accordingly

  • Copy Date/Time data from Excel or other places and paste it into Origin worksheet cells. Column/cell will be auto formatted as Date/Time.

  • Insert info variable and select date from file info list, the cell gets correctly formatted as date

ORG-21701

Better Handling of Time Data that Wrap Around Midnight

Mini toolbar buttons is added to handle date/time data what wrap around midnight

User sometimes has time data that missing day info. When plotting with such data as X range, the plot may jumps back to beginning of axis at midnight.
Now Origin provides a new mini toolbar to deal with such problem. When click it, Origin will check and detect, then ask if can go ahead to add days to the data.


Also, for axis tick label, DDD info will not be added anymore for time HH format. E.g, 25:00 will be shown as 01:00 instead.

ORG-21720

Redo Worksheet Transpose Tool

There were many issues when using transposed data as input of further analysis.

In the past, output of wtranspose maybe problematic when directly use as anlaysis input. Now, this should not be a problem anymore.

ORG-22137

Support Color Column in Worksheet

New column type is added to support HTML color code. User can save the colors in the column as a color list or palette for other uses. User can use it to color plots.

In Column Properties dialog, set column format as Color.

  • support HTML color code. Cell background will be colored accordingly.

  • Mini toolbar to set color

  • Mini toolbar of column to save Color List or palette (system variable @MPS is the threshold to save as palette. E.g. default is 20. So if there are more than 20 colors in the column, it will be saved as palette. If less than 20 colors, it will be saved as color list.)

  • Set column as Color to show calculated color based on R, G and B values.

  • Add Display Color Value checkbox under Format in column property dialog if column format is Color.

  • Add Create Color List from Column… in Custom dropdown list under Color fly-out single tab.

     

ORG-22146

Allow setting HTML color code in colors popup.

Entering HTML color code to create color

In Color Popup, add HTML edit box allowing copying/pasting HTML color code.

 

ORG-22376

Support mask column based on Outlier by IQR

Support mask column based on Outlier by IQR

Select Column: Mask Cells by Condition… menu.

Outliers by IQR is added in Condition dropdown

ORG-21957

Alt+Enter for new line

We used to use Ctrl+Enter for new line. Changed to Alt+Enter to be consistent with other softwares

Use Alt+Enter for new line instead of old Ctrl+Enter.

System variable @FCA =1 to roll back to old way.

This also applies to adding mult-line text in graph and script window

ORG-22435

Missing Value NANUM for numeric column which is not double(8)

When data type isn’t double(8), we used to show 0 as missing values. Now user can specify what value to show as missing value --

When column format is set to Numeric and Data Type is set to other options e.g. Real(4) instead of the default Double(8), user can assign a custom value as missing value, such as:
wks.col1.missing = -99; //-99 will show as missing value --
wks.col2.missing = 0; //0 will show as missing value --

wks.col1.missing = 0/0 //turn the feature off

This property is saved with the column.

ORG-22469

Aligning on decimal character in column

Numbers are usally right aligned. Now you can align numbers by decimal points in a column

In Column Properties dialog, set Numeric Custom Display as e.g. .3?

 

ORG-22465

Paste space separated text into one column in worksheet

By default, space separated text will be pasted into multiple columns. A context menu Paste (Keep Spaces) is added to pasted text into one column

It will paste space separated text in one column

 

ORG-22574

Easier way to select highlighted columns in worksheet in Worksheet Query dialog

Newly added checkbox Check all Selected Columns Extract to quickly select highlighted columns only

By default when opening Worksheet Query dialog. All columns are checked so when extracting data, all columns will be extracted.

A new context menu Check all Selected Columns Extract is added. Check it, only columns highlighted in worksheet will be checked and extracted.

ORG-20123

paste report sheet table will set 1st row to long name

origin will set 1st row as long name when paste report sheet table since Origin2021, it will provide better format style look, also can easily change table style will mini toolbar.

 

Graphing

Colors

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-21898

New Color Manager

A new color manager tool to load palette from website or file from other software, create and edit color list/palettes, and customize which color list/palettes to show in color GUIs

Tools: Color Manager… (hotkey Ctrl+Shift+O) to manage color lists and palettes

  • Import color list or palettes from web.

  • Import color list or palettes from downloaded color list or palette files.

  • Create your own color list/palette

  • Control which color list or palette will show from GUI, such as color related control on toolbars and dialogs.

  • Default Plot Colors button for quick access to System Color Lists tab of Theme Organizer.

  • More… context menu from color list and palette related toolbars to open Color Manager.

  • Improved Build Colors dialog for ordering colors, interpolate and save color list/palette.

  • System variable @ecd to decide what dialog opens to edit palette. 0 - Build Color dialog, 1 - Palette Editor dialog, 2 - Simplified Palette Editor.

ORG-21970

Drag and drop Palette files into Origin to install them

Drag and drop color palette files of other softwares to install it in Origin

The installed palette will be accessible from Palette dropdown list.

  • If the file is MS PAL, it’s copied to User Files Folder\Palettes\

  1. if not, the file is converted to pal file and put to User Files Folder\Palettes\

  2. If the filename already existed, the file name will enumerate.

Following palette files are supported.

  • Office Color Table (.soc)

  • Adobe Color (.aco)

  • Adobe Color Table (.act)

  • Adobe Swatch Exchange (.ase)

  • JASC PaintShopPro (.pal)

ORG-21560

Image Plot Can't Set Color Beyond Min/Max

Customize color below min and above max in Image plot

Make image plot from random data in matrix.
==> Under Colormap tab in PD, we can change color for any level but not for level <min and >max.

Implemented in Origin2021.

ORG-21629

More obvious way to define custom colors

In custom color pop up add a plus mark in the cell to add custom color

In custom color pop up add a plus mark in the cell which can add custom color

ORG-22306

Color Scale Mini Toolbar Issues Reported by Beta Tester

Update colormap graph when changing color scale on mini toolbar, delete color scale title by Delete key

  • We can update colormap for the plot which is related to selected color scale by mini toolbar.

  • We can delete color scale title with delete key.

ORG-21927

Improve color list popup GUI

It is dynamic now, can be expand to show more items.

Change color list and palette list popup to be dynamic.

General

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-21662

Browser Graph Improvements

  • User can now use minitoolbar to turn a regular graph into browser one.

  • User can set up flipping pattern in browser graph to exam their data more easily

  • Mini toolbar to turn browser panel on for regular graph

  • Flip Through tool in Browser graph. Click Down arrow button on left panel to find the menu

Plot: Browser: Stack… to plot stacked graph in Browser graph

ORG-21602

Graph Export should automatically save a theme in page

When user exports a graph, the settings should be remembered in the graph itself, so next time, they should be able to pick as a theme to refill the dialog.

When user exports a graph, the settings should be remembered in the graph itself, so next time, they should be able to pick as a theme to refill the dialog.

ORG-21923

More display format for scientific notation

More display format option for scientific 103 notation

It applies to axis tick labels, bubble scale label, and color scale labels.

ORG-20753

Zero tick label display options default changes on Axis tab of Preference: Options dialog

Tailing zero is back by default

To show trailing zeros in axis tick labels by default, No Tailing Zero and Zero is ‘0' checkbox are default unchecked in Preference: Options dialog.

ORG-21937

Support Mask tool for 3D OpenGL graph

User can mask data points on 3D scatter now

The left side toobar masking tool is now available for 3D OpenGL graphs. Masks data on source worksheet and points are masked on graph.

ORG-22006

Offset Overlapped Points Vertically

User can offset overlapped points Vertically now

For overlapped points, we used to support arrange horizontally only.

 

ORG-22097

Page level mini toolbar improvements

More buttons added on page level mini toolbar

  • Center Layer in the Page

  • Set Active Layer by Layer Icon Only

  • Show Active Layer Only

  • Toggle data point or data plot tooltip

ORG-21977

Mini Toolbar for multi-layer/object selection

Mini toolbar can effect multiple layers/objects that be selected at the same time

  • Use Shift key to select multiple layers, pop up mini toolbar

  • Use Shift key to select layer and graph object, pop up mini toolbar

ORG-21936

Support dragging Layer/Object in Line when holding SHIFT key

Support Shift key+Mouse to move vertically or horizontally only for Graph Layer/Object

Support Shift key+Mouse to move vertically or horizontally only for Graph Layer/Object

ORG-21586

Strip Format Codes from Object Manager Plot Listings

Strip Format Codes from Object Manager Plot Listings

ORG-21308

Batch Plotting support inexact matched data

User can uncheck newly added Exact checkbox in Duplicate (Batch Plotting) dialog to plot multiple book/sheets with some mismatch in columns.

When Batch Plot with = Book/Sheet, a Exact checkbox is shown after Batch Plot with option.

  1. Select it should match column&sheet&Modifier exactly with current graph(Same as before).

  2. Unselect it, origin will show book/sheet if at least one column match.

  3. only group plot support exact

 

ORG-22295

Undo when using CTRL+W to switch to Column List View

User accidentally hits CTRL+W switching to Column List View. He thinks he deleted data and tries to hit CTRL+Z to undo which used to do nothing. Now it switches back out of Column List View

User accidentally hits CTRL+W switching to Column List View. He thinks he deleted data and tries to hit CTRL+Z to undo which used to do nothing. Now it switches back out of Column List View

ORG-22368

Changed default plot mask mode

Changed default plot mask mode from X range to ROI coverage

When using the masking tool on a plot, the default way points are masked has changed. See below:

 

ORG-21868

ORG-21910

Keyword for Beginning and Ending Plot Special Point and Labels

The Beginning and ending special point on a plot may be named begin or end

The Beginning and ending special point on a plot may be named begin or end to specify that they should always be the first and last point regardless of the “index” name of other points.

Also the data label “specified Index” setting supports begin and end.

ORG-21705

Independent Control of Head and Tail of Color Scale

Color scale head and tail can now be configured independently.

Color scale head and tail can now be configured independently.

ORG-22265

Support Rescale type for Ternary Coordinates

Set axis rescale type to Fixed, Normal, Auto etc. in Tneray diagram

Scale for Ternary Diagrams can now be controlled by a Type. For example: Fixed,Normal,Autoetc.

ORG-22378

Scatter Matrix plot: Set histogram binning on each layer independently

With newly added Independent Binning Control checkbox selected, user can set different binning for each histogram in scatter matrix plot.

 

ORG-22375

Group Plot in Object Manager should keep plot properties

Improvements on how plot properties are kept when grouping plots in Object Manager

In Object Manager, when user set group by Set as Group Begin/End, we could generate increment list for each properties like switch edit mode from independent to dependent:

  • For a plot property, if any plot(in later group) use different setting, then Increment is by one, increment list is created according to each plot.

  • If all plots share same setting, then increment is none.

ORG-21576

Tick Labels of Polar Plot support Radial rotation

Add Radial option in axis dialog tick label tab’s Rotate for Polar graph.

Add Radial option in axis dialog tick label tab’s Rotate for Polar graph.

ORG-21859

More output parameters for Bland-Altman plot

Mean of Pairwise Means and Bland-Altman Ratio are introduced in Bland-Altman plot

The following quantities are introduced in the Bland-Altman plot:

  • Mean of Pairwise Means

  • Bland-Altman Ratio

ORG-21835

Layer Background Image to be behind layer background

Layer Background Image can be behind the layer background color now

  1. Support control background image drawing before layer fill.

  2. In mini toolbar, there is button to set layer background color

  3. If layer background is enabled, change transparency from mini toolbar

ORG-22331

Colored Brackets in More Places

Plot Details and Axis dialoges can also show colored brackets when entering expression

We support color brackets in set column value for following places:

  1. At Axis Value option for reference line

  2. Scatter Size Formula option

ORG-21704

Column Plot Supports Connect Across Axis Break

In the past when there is axis break in column/bar plot, the gap shows in column/bar. In Origin 2021, user can check the newly added checkbox so the column/bar still shows as a whole bar.

  • Add Connect Column/Bar across Axis Break button on mini toolbar

  • Add checkbox “Connect Column/Bar across Axis Break under Plot Detail page level, Display tab

ORG-22088

Move Plot to other layer should also move the related error bar plot

Move Plot to other layer also move the related error bar plot

In Object Manager, move the plot with error bar to other layer, the error bar keep

Graph Types

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

APPS-918

Create taylor diagram for facilitating the comparative assessment of different models.

Taylor Diagram app is capable of creating taylor diagram for facilitating the comparative assessment of different models.

  • Download Taylor Diagram app from the page and install the app.

  • Activate a worksheet with reference data selected, then click the app icon in the Apps gallery window, then a dialog will be brought up, and then choose test data, and set correlation coefficient range, and click OK button to create Taylor diagram.

 

APPS-931

Create 3D polar strain map plot.

3D Polar Strain Map app can be used to create 3D polar strain map graph.

Download 3D Polar Strain Map app from the page and install the app.

This app requires four input columns: time, angle, depth and strain. And groups for time, angle and depth must be balanced.

Operation:

  1. Select columns for Time, Angle, Depth, and Strain.

  2. In the Settings branch, set Numbers of Depths to Plot, adjust Minimum and Maximum in Strain Range in Colormap, and set Transparency.

  3. Click OK button. A 3D polar graph will be created.

ORG-21934

Unicode Symbol for scatter plot

Enter unicode number to show unicode symbols in scatter plots

Enter Unicode for symbol in Plot Details dialog

ORG-21293

Lollipop Plot

Lollipop Plot added to connect corresponding rows vertically or horizontally

  • Plot → Basic 2D → Lollipop Plot

  • In Plot Details → Drop lines, tab, Drop to Next Data Plot

  • The line color can be customize to change depending if it’s above or below baseline.

 

ORG-21325, ORG-21345, ORG-21204

Browser Graph -> Stack