Origin 2021 Features
Data Handling
Column/Cell Value Formula
JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|
Excel like Formula bar | Excel like formula bar is added on the top part for easier view column/cell formula and long cell contents |
| |
Save and Load Formula Improvements in Set Column Values | Some button and context menu added to easily save and load formula for a column |
| |
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 | |
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 |
Data Connector
JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|
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. |
| |
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. |
| |
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:
| |
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 | |
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. | |
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 | |
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 | |
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. | |
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. |
| |
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. | |
MATLAB connector supports Tables | MATLAB connector supports importing tables from .MAT files. | MATLAB Connector supports importing tables from .mat files. | |
CSV Connector allows Append Rows | CSV Connector now permits appending rows to columns. | Set | |
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 This applies only to those connectors that are using the Tree framework, so besides Matlab, it will affect JSON, netCDF, etc. | |
Clone Import for Data Connector | Clone Import for Data Connector-based imports is now supported. | Support Clone Import for Data Connectors. | |
Yokogawa Binary WDF File Connector | New Yokogawa Binary WDF File DC has been created. |
| |
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. | |
@ISC=0 did not work | @ISC=0 System Variable fixed and a wks level control “ | Added a wks level control “ default = 1 means it will follow @ISC, and if =0, it means do not resize column width after import. | |
ISO Date-Time Format More Issues | CSV Data Connector now supports Zulu Time (UTC). | CSV Connector Supports Zulu Time (UTC), the |
Worksheet
JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|
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. | |
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.
| |
Change Column (Cell) Format on Pasting Date Time Data | Check if copied data is date and time and paste accordingly |
| |
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.
| |
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. | |
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.
| |
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.
| |
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 | |
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 | |
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 = 0/0 //turn the feature off This property is saved with the column. | |
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?
| |
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
| |
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. | |
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 |
---|---|---|---|
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
| |
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.
Following palette files are supported.
| |
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. 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 |
|
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 |
---|---|---|---|
Browser Graph Improvements |
|
Plot: Browser: Stack… to plot stacked graph in Browser graph | |
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. | |
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. | |
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. | |
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. | |
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 |
|
Mini Toolbar for multi-layer/object selection | Mini toolbar can effect multiple layers/objects that be selected at the same time |
| |
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 | |
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.
| |
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 | |
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:
| |
Keyword for Beginning and Ending Plot Special Point and Labels | The Beginning and ending special point on a plot may be named | The Beginning and ending special point on a plot may be named Also the data label “specified Index” setting supports | |
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. | |
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: | |
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. |
| |
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:
| |
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. | |
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:
| |
ORG-21835 | Layer Background Image to be behind layer background | Layer Background Image can be behind the layer background color now |
|
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:
|
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. |
|
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 |
---|---|---|---|
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. |
| |
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:
| |
Unicode Symbol for scatter plot | Enter unicode number to show unicode symbols in scatter plots | Enter Unicode for symbol in Plot Details dialog | |
Lollipop Plot | Lollipop Plot added to connect corresponding rows vertically or horizontally |
| |
Browser Graph -> Stack |