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

Stacked Browser to plot stacked graphs based on grouping information in column label rows with interactive buttons on the left manipulate plots

  • Plot: Browser: Stack… menu to plot stack graph grouped by metadata, e.g. Long name, units, etc.

  • Select plots on browser panel will select plots with same name in each layer

 

 

 

ORG-22072

Flip through sets of plots

In Browser Graph user can now defined subset and flipping through

  • Add Filp Through dialog to display a set of n plots at a time.

 

ORG-16883

Specialized - > Compass Plot, Polar Vector

Two graph types added: Polar Vector and Compass Plot.

vector plot in polar coordinates

Plot: Specialized: Polar vector, Compass Plot.

ORG-22000

Chord Diagram

Plot: Categorical: Chord Diagram

Plot: Categorical: Chord Diagram, Chord Diagram with Ratio Layout after Alluvial, in Plot menu: Categorical tab.

ORG-22114

Improvements on Row-wise Plot

Row-wise Plot can now follow categorical order and the data can be filtered

  • Plot Order control to follow categorical order in source data

  • Get Filter information from source data

ORG-22262

Sankey Node Order follow Data Order

Nodes in Sankey plot can now follow Data Order

We add Order by Data checkbox in Node tab, put it in Position group, on the right of alignment option. Select it should just use node order in data to decide node order.
1. when there is no Name column (input is 2 or 3 columns), we use link order in first 2 column to decide node order
2. when there is Name column(input is 4 columns), we use data order in 4th column, If this name column is set as categorical, then we could use categorical order.

ORG-21621

Easier layer reordering for Double-Y graph

the layers in a Double-Y graph can be reordered without breaking linking.

In older vserions layer reordering usually broke the linking but starting with 2021, the layers in a Double-Y graph can be reordered without breaking linking.

Text Labels & Legends

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-20629

Improvement mini toolbar for legend and related and tables on graph

More options in text object (including special objects like legend, colorbar, etc.) mini toolbar

  • Mini toolbar for legend related features, move legend to each plot

  • Mini toolbar for legend symbols

  • Mini toolbar for color scale

  • Mini toolbar for bubble scale

 

Table on graph (e.g. fitting table)

 

ORG-22020

Applying Formatting to button for data label mini toolbar

Many options added so for common editing, user doesn’t need to go to Labels tab of Plot Details dialog to customize.

Support Apply Formatting to This Layer/Window for data label

ORG-21885

Support Different Label Source for Each Plot of Grouped 3D plot

User can specify different label to use for different plots in grouped 3d graph

Implemented in Origin 2021.

User can specify different label to use for different plots in grouped 3d graph

ORG-5076

Tick Label Alignment support

Alignment dropdown list is added on Tick Labels: Format tab

User can align Tick Labels by Alignment dropdown list

 

ORG-21646

Mini toolbar for Tick Label Table on Graph

Tick label table specific mini toolbar is added.

ORG-21646

Mini toolbar button to flip colormap

Flip colormap button added on colormap mini toolbar

ORG-21646

Mini toolbar for Parallel Plot Axis

Mini toolbar for Parallel Plot Axis

 

ORG-22043

System Variable for increment steps on Mini toolbar

See the status bar about how to use system variable to adjust increment step when clicking on mini toolbar’s increase/descrease buttons.

ORG-21651

MT button for data label leader line control

Click the leader Lines button on data label mini toolbar to control it

  • Add Data Label Leader Lines button for data label mini toolbar

  • The precision of the gap has been improved, before Origin 2021, we can only input integer, now we can input value with two decimal places

ORG-21470

Wrap Text button on Legend, Text, Axis title MT and related issues

Support wrap text for text object, legend, text label on worksheet, tick label.

Support wrap text for text object, legend, text label on worksheet, tick label.

ORG-21874

Support legend substitution in data labels

The old syntax is hard to understand and customize. So we used similar syntax as legend in Origin 2021 to customize data labels.

Legend might be using %(1,@L) and this currently cannot be used in data label, we should allow it in the form of %(?,@L) similar to axis titles. For example:

%(1), %(?), %(?, @LM)

ORG-22472

Show button feedback on 3D graph when clicked

For text and rectangle objects, show click feedback when clicked same as in 2d graph.

For text and rectangle objects, show click feedback when clicked same as in 2d graph.

ORG-10287

Add System variable to turn off area legend

Set @LLAB=0, then when plotting fill area plot, only line legend shows.

Set @LLAB=0, then when plotting fill area plot, only line legend shows.

ORG-21881

MT button for data label source

Label Source button added on data label mini toolbar.

  1. Better Label Source for single label

  2. Better Label Source for Stacked Columns Plot

ORG-22421

Support C-Language formats for minor tick label display format

Support C-Language formats for minor tick label display format

 

Programming

Labtalk

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-20778

Excel like pi product function

Add product Labtalk function which returns the product of a dataset

double product(vector vd)

E.g. column A is filled with 2, 3, 4, 5

In B1 cell, enter = product(A) will get 120, which is 2*3*4*5.

ORG-21992

Excel like LET function

Add LET Labtalk function which pairs values and names and calculates the expression using the names

Easier to write complex formulas, by making it possible to declare and assign values to variables inside a formula

LET(name1, exp1, [name2…], [exp2…], calculation)

exp1 is resolved and assigned to name1, exp2 is resolved and assigned to name2, then assign names to calculation for result. 

LET(x, 1, x+1) -> 2

LET(sum, total(A), n, count(A), sum/n)

ORG-13898

Command Window improvement

Command Window now supports Zoom in/out and auto code complete

support mouse wheel zoom, more support on auto complete

ORG-21926

Introduce new LabTalk command to update pending locks

Improve Labtalk command run -p to update pending locks for active book/sheet.

run -p aub;//active book run -p auw;//active sheet run -p aubd;//active book and all its descendants run -p auwd;//active sheet and all its descendants

ORG-21587

LabTalk Access to Dash Definition at Plot Level

Labtalk command set supports setting line dash property.

Syntax: set name -ldf value

set %c -ldf "5 20 10";

ORG-19233

GetN supports dataset elements

GetN Box now supports to assign dataset values.

E.g.

dataset values;
values.setsize(3);
getn (Value 1) values[1] (Value 2) values[2] (Value 3) values[3];

ORG-22214

LT Labtalk control of Box Plots

Add more Labtalk controls to customize Box Plot properties such as statistical lines, labels, etc

layer.plot1.boxchart.line=1,2,3; //show lines in box chart, 1=median,2=mean or 3 both

layer.plot1.boxchart.label=1,2,3;//show label of line, 1=median,2=mean or 3 both

layer.plot.label.font=1; //label font

layer.plot1.label.fsize=20; //label font size

layer.plot1.label.color=2; //label color based on color list, e.g. 1=black, 2=red, etc.

ORG-18101

Sort columns by Long name, etc.

Added Labtalk worksheet method SortCols() to sort columns by Long names

wks.SortCols(L,d);//sort LongName decending

ORG-21874

ORG-22418

ORG-22525

ORG-22838

ORG-22127

Labtalk access to more plot properties

Add more Labtalk controls to customize plot properties such as symbol overlaps, label properties, plot color, etc

layer.plot.label.Spec$="0";//to show label at end of plot layer.plot.label.Spec$="";//turn off show label at specific indices checkbox layer.plot.label.fsize layer.plot.label.color layer.plot.label.form$ layer.plot.symbol.offset = 1; // Symbol Overlapped Arrangement: 0=disable, 1=horizontal, 2=vertical layer.plot.symbol.oct = 1; // Symbol Overlapped offset center type layer.plot.contlines = 1; // Enable Contours for surface plot layer.plot.contmat //specify the index of matrix use for contour line, 0 = self set/get %c -ccl name //set/get the matrix use for contour line layer.plot.color layer.plot.colorlist$ //support individual and group plot layer.plot.shapelist$ //support individual and group plot, only write access layer.plot.symbol.size layer.plot.symbol.kind

ORG-22127

LT labtalk Color() function supports specify mapping column

Improve Color() function to set plot color by column

Syntax: m=colormap, n=indexing, r=RGB

ORG-22475

GetNBox focus issue

Increase default GetNBox entry focus time

Changed the default value of @ETG to 1700.

ORG-22313

Skip none-accessible objects in doc looping

doc -e G will skip none-accessible objects in looping graph objects.

When use doc -e G command to loop for all labels and other named objects in the active graph layer, the objects that not accessible from LabTalk will be skipped now.

ORG-21997

Plot Hide Show events from Labtalk

Add a new event “Plot Hide Show” in Object Properties

Open Object Properties dialog, in Programming tab, a new event is added in the Script Run After drop-down list. Choose it and then script will be execution when plot hide/show.

ORG-22606

LT Labtalk Accessing Cells from Another Book

Improve LabTalk accessing cells notation from another book.

  • Support col(A) notation. E.g., =[book1]1!col(A)[1]

  • Book Name support resolving string varaible. E.g., Fill A1 cell with “Book1”, the cell formula =[A1$]1!A1 can refer to A1 cell in the 1st sheet of Book1

  • Support A0 notation. E.g., =[A1$]1!B0

 

Origin C

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-21941

Functions to download color palette from the internet

Added OC functions to download color palette: int download_palette(LPCSTR lpcszURL, LPCSTR lpcszPALfilename)

Added following OC functions to download color palette. If file name arg is NULL or empty then the downloaded palette is installed.

int download_palette(LPCSTR lpcszURL, LPCSTR lpcszPALfilename)

At this time it can convert the following:

  • Scribus (.xml) (XML)

  • Office Color Table (.soc) (XML)

  • CorelDraw and Corel PhotoPaint (.xml) (XML)

  • Adobe Color (.aco) (Binary)

  • Adobe Color Table (.act) (Binary)

  • Adobe Swatch Exchange (.ase) (binary)

  • JASC PaintShopPro (.pal) (Text)

ORG-21693

OC functions to get modifiers from graph

Two OC functions to get modifiers are added.: DataPlot.GetModifiers & GroupPlot.GetModifiers

Added two OC functions to get modifiers.

ORG-22289

OC function to get logical coordinates from xyz

Improve GraphLayer.WorldToView() and GraphLayer.ViewToWorld() to support 3D graph.

Improve GraphLayer.WorldToView() and GraphLayer.ViewToWorld() to support 3D graph.

 

Code Builder

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-22100

Improved shortcuts in Code Builder

update some Code Builder Shortcut Keys: e.g. Tools: Customize(Ctrl+K, Ctrl+T)

 

Update some Code Builder Shortcut Keys:

  1.  Tools: Customize(Ctrl+K, Ctrl+T)

  2. Debug: Execute Current Section(Ctrl+K, Ctrl+S)

  3. Debug: Execute Selected Lines(Ctrl+K, Ctrl+L)

  4. Edit: Comment(Ctrl+K,Ctrl+C)

  5. Edit-Uncomment(Ctrl+K,Ctrl+U)

  6. Edit: Go to Matching Brace(Ctrl+K,Ctrl+B)

ORG-22023

Support debug Python file

support adding break point in the code, support running code line by line, checking variable values in debug mode, etc

Support debug Python file

Miscellaneous

General

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-20942

Main Menu Rework

Social menu is added before Help menu, Help menu reorganization

  1. App Center menu is moved under Tools main menu.

  2. Training Videos, Graph Gallery and Open Folder: Sample Folder are added under Help main menu.

  3. Help: View Origin Info menu is removed.

  4. Social main menu is added:

ORG-21600

HTML Report Ease of Use

Some menus added related to HTML report

  1. Added “Add HTML Report“ to worksheet tab context menu.

  2. Added a number of shortcut menu items under the HTML menu

     

ORG-22434

Copy Notes Window within or across sessions

Copy Notes Window within or across sessions

  • Right click a Notes window title bar and choose Copy

  • Right click Notes window in Project Explorer and Copy.

Then in another running instance of Origin, Ctrl+V to paste such Notes window in current folder.

Labtalk command

note.copy();// copy the active Note window to clipboard

win -n notes __clip__ //create a new Note window from the content of the clipboard

ORG-12329

Set Project Protection in Save Project As dialog

Protect Project… button in Save Project As dialog

In the past, user had to use Tools: Protection: Protect Project… to set password.

Then save project to

In Origin 2021, user can set protection password from File: Save Project As… dialog.

 

Apps

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-21851

Let Customers to choose download new app xml

Manually click Download now button to get new apps information

In origin2020b, origin will download new app xml when open App center dialog if new app info comes. it is not friendly since it takes more or less 15s to finish downloading.

In origin2021, origin provide a Download Now button in app center dialog when new app info comes, customer can choose download new app info manually as he want. therefore, user does not need waiting when open App Center dialog.

once downloading is finished, new app info will be updated in App Center dialog instantly.

ORG-22326

App Bar order based on previously used or frequency

In app Bar context menu: Sort Apps->Recently Used is added

Option is now available to sort App icons in App Bar by usage. In app Bar context menu: Sort Apps->Recently Used..

Analysis

General

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS


Group data according to periodic date/time range using specified statistical value.

Periodic Report app is capable of grouping data according to periodic date/time range using specified statistical value.

  • Download Periodic Report app from the page and install the app.

  • With a worksheet window activated, click the app icon to bring up the dialog.

    1. Choose Input columns for grouping, and date/time column for periodic calculation.

    2. Select how to merge the input columns, including 1st point, last point, mean, sd, mean and sd, min, max, sum, and count.

    3. Change a start and end date/time accordingly, leave them Auto if you want to cover all the data.

    4. Consider the period for grouping you want, including second, minute, hour, day, month, quarter and year.

    5. For day period, you can also specify how many days as a period.

    6. If you have included prior periods, the result will not be merged for the same period in different "parent". For example, the period you choose is month, if not include prior periods, then all data in each month, Jan. for example, will be merged, but it does not care about the years. If include prior periods, Jan.'s data is merged by year, but not all years together.

    7. If there are some other columns need specific consideration, you can include other columns to handle them.

    8. Specify where to output the result, and then click OK button.

 

 

APPS-936

Perform neural network fitting using Python.

Neural Network Regression App fits data with neural network backpropagation.

  • Download Neural Network Regression app from the page and install the app.

  • Operation

  1. Activate a worksheet or a graph. Click the App icon to bring up the dialog.

  2. On Input Data tab, select single or multiple datasets for Independent Variables and specify Dependent Variable by selecting a single dataset.

  3. On Options tab, change settings to fit a neural network.

  4. On Quantities and Plots tab, choose which quantities and plots to output.

  5. On Prediction tab, you can select a range of independent data to predict the response with the fitted neural network.

  6. Click OK to output reports.

 

APPS-917

Perform detrended correspondence analysis.

Detrended Correspondence Analysis App can be used to perform detrended correspondence analysis (DCA). It is a multivariate method that corrects for the major problems (the arch effect and compression of the ends of the gradient) of Correspondence Analysis.

  • Download Detrended Correspondence Analysis app from the page and install the app.

  • Operation

  1. Click App icon to open the dialog.

  2. Select data for sites and species.

  3. Customize DCA parameters.

  4. Click OK to output report sheets.

 

APPS-566

Use the apparent values for integration according to the current axis scales.

Apparent Integration App calculates apparent integral in Cartesian and polar coordinates according to the current axis scales.

  • Download Apparent Integration app from the page and install the app.

  • Operation

  1. Activate a graph window. Click the App icon to open the dialog.

  2. Choose area type from Mathematical Area and Absolute Area.

  3. Click OK.

 

APPS-726

Find solutions that minimize or maximize a function defined in a worksheet's cell.

Optimization Solver app can be used to find solutions that minimize or maximize a function defined in a worksheet's cell. It can also be used for curve fitting by defining the residual sum of squares as the target function for minimization.

Download Optimization Solver app from the page and install the app.

Operation:

  1. Highlight the Objective Function cell in the worksheet. Launch the app.

  2. Drag and drop columns for Initial Values and Solution.

  3. In the Settings branch, choose target, method, bounds and iteration options.

  4. Click OK button. Results in the worksheet and graph will be updated.

APPS-788

Rank multiple fitting functions by their fit reports.

Rank Models by Fit Reports app can be used to rank fitting functions by fit reports. It can find the optimal model by AIC, BIC, Adj. R-Square, Reduced Chi-Sqr or Residual Sum of Squares.

Download Rank Models by Fit Reports app from the page and install the app.
Operation:

  1. Choose Number of Models to Compare. Click OK button.

  2. In the pop-up Choose Fit Reports dialog, click Browse button on the right of each Report edit box. Click OK button.

  3. A summary report will be created. The optimal model by BIC is marked in red color. You can also select another column and sort worksheet to find the best model by other methods.

APPS-896

HTML Report Assistant

HTML Report Assistant app

  • Download HTML Report Assistant app from the page and install the app.

  • This propose of HTML Report Assistant app is to to help you edit a report according to HTML syntax in Notes window. You can get a nice table without touching the CSS part.

ORG-22170

Moving Average Functions NANUM (Missing value) Ignore or Zero Issues

Moving Average Functions NANUM (Missing value) Ignore or Zero Issues

Support different ways to treat missing value in the following functions: movavg, tmovavg and movcoef.

New option “missing“ is introduced:

  • 0: omit missing values from the calculation by default which is same as before

  • 1. include missing values in the calculation

  • 2. omit missing values from the calculation, but keep missing in the output

ORG-21947

Improvement on Operation Lock tooltip

Improved info. shows when mousing over the green lock

  • Shows input data range.

  • Shows with better data range info.

  • Shows main range info instead for secondary lock.

  • Change background color of tooltip for locks on worksheet for better visualizing.

  • For Set Column Value operation, shows formula and input range info in tooltip. And when user select the F(x) cell, the before formula script will be shown in the status bar if exists.

ORG-21848, ORG-3958

Range String Builder dialog updates

Makes it easier to build output range

Clearer labels and contexts, update menu entry name as Custom...

ORG-21642

Average Multiple Curves with Different X Ranges Issue

No extrapolation added when averaging multiple curves

Adding new option “No Extrapolation”:

  1. Only available when Averaged X is set to Full X RangeCustom, and Follow Curve Trace.

    1. Determines whether to extrapolate the curves when the input curves have different X ranges.

ORG-22287

Set Sampling Interval in average multiple curves result

If all input Y has same sampling interval, no seperate X column will be created

If source data's sampling interval is all the same (including name and unit), then result column will set with sampling interval instead of output an X column.

ORG-19877

Support set sampling interval on locked columns

Support set sampling interval on locked columns

Allow set sampling interval on locked column now.

ORG-21964

Peak Analyzer default theme setting changes

Enable Linear Constraints Status and Constraints are checked by default

2 choices Enable Linear Constraints Status and Constraints change to check by default

ORG-22091

GCAS function has no abs

abs in the GCAS function is not necessary and so it’s removed now.

abs in the GCAS function is not necessary and so it’s removed now.

ORG-17275

Support Open Book(s) buttons from Summary Sheet when Data Source is set to Use Existing Data

Buttons on summary sheet will also work if the Data source is Use Existing Data in batch processing

There were Open Book, Reprocess and Update buttons in summary sheet created by Batch Processing only if Data Source was Import from Files in the past. Now there are also such buttons if Data Source is set to Use Existing Data.

ORG-22119

Vertical Cursor supports side by side layers

In the past, Vertical cursor only worked for layers stacked vertically in same graph. Now it will work for layers even on the left or right side

Linked Cursor for Each Layer button is added in Vertical Cursor tool to add vertical cursor at same X position for all layers in current graph.

ORG-22218

Pre-ship Fitting Function Library App and show it in appropriate tools

In Fitting Function Builder and NLFit dialog, there is Fitting Function Library link to download extra fitting functions provided by our website.

Choose Tools: Fitting Function Builder… menu. There is link to open the App

  • Click Search button in Nonlinear Curve Fit dialog and search some non-existing function e.g. crossWLF. It will show hint to open Fitting Function Library App for more functions.

ORG-22216

Need consistent way for date time data in grouping variable

Improved tools that support group column with date time data so the output will be sorted by meaningful week, month, quarter, etc. order.

  • When display julian date as Month format, date value with same Month will be considered as same group.

  • Support sort result column by a internal order depends on Date format.

    • 10 (the 5th one, day): 1 to 31

    • Fri (the 6th one, day of week ): Monday to Sunday, Mon Tue Wed Thu Fri Sat Sun

    • Jul (the 17th one, month display): January to December, Jan, Feb,...,Dec

    • Q3 (the 19th one, quarter display), Q1 to Q4

    • 2020 (the 8th one, year display): year ascending

  • Set user-defined label in output result worksheet with correct date/time format setting.

Above rules will be applied in following tools,

  • Pivot Table

  • Unstack Columns

  • plot_gindexed

  • plot_gboxindexed

  • plot_bygroup

ORG-21086

Support import data to embedded matrix sheet with data connector when batch processing

Allow importing data directly into embedded matrix imported by data connector in worksheet during batch processing

origin support importing data to embedded matrix sheet since Origin2018b, but not support if matrix data is imported by data connector. we improve this to make it more applicable.

note: drag and drop data or image to opened analysis template is also improved.

Statistics

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

 

 

 

 

ORG-21828

Statistics on Rows support multiple sheets as input

In Data Range box, user can enter (1:10)!A:B to do rowwise statistics of column A to B on sheets 1 to 10.

Origin 2021 added this support in Statistics on Rows dialog.

In Data Range box, user can enter (1:10)!A:B to do rowwise statistics of column A to B on sheets 1 to 10.

ORG-22406

Significance Label for ANOVA Result Worksheet

ANOVA Result Worksheet adds Grouping Letters Table in Means Comparison

ANOVA Result Worksheet adds Grouping Letters Table in Means Comparison

Installation and Licensing

JIRA

SUMMARY

Description

DETAILS

JIRA

SUMMARY

Description

DETAILS

ORG-22318

Support uninstall previous version on install new version

Customize config.ini to uninstall previous versions while installing new Origin.

Setup can uninstall previous versions from among 2019, 2019b, 2020, and 2020b,
Add to config.ini in the setup folder:

[Setup]
UNINSTALL=2019
or
UNINSTALL=2019,2019b,2020,2020b
or
UNINSTALL=ALL (same as =2019,2019b,2020,2020b)

ORG-21031

Customized Installation improvements

How to customization Origin during batch installation

  1. If you put a folder named UpdateUserFile in the Origin 2021 setup folder (with setup.exe or msi), it will be copied to the Origin 2021 install folder. When Origin 2021 runs, it is copied to the UFF folder.

  2. If you put opx/opk containing like system variables, templates, fitting functions etc to a folder named Auto Install in the Origin 2021 setup folder (with setup.exe or msi), it will be copied to the Origin 2021 install folder. When Origin 2021 runs, the opx/opk can be auto installed.