Origin 2020b Features

1508

ORG-21336

Reprocess button on Batch Processing summary sheet

Reprocess button on batch processing summary sheet to allow changes to template or Input Data

After doing batch process, use may want to modify template and do the batch process again, or data file has been modified and user wants to batch process again.

In Origin 2020b, a Reprocess button is added on summary book. Use can click it to update the result based on modified template or data.

1509

ORG-21482

Update button on Batch Processing Summary sheet

Update button on batch processing summary sheet to allow changes on input data

User can edit/mask data in Intermediate workbook created by batch process. Then select corresponding row(s) and click Update button on Summary sheet to get recalculated result.

1572

APPS-836

Fit Adsorption Isotherm

Fit Adsorption Isotherm app provides a convenient way to transform your raw data related to adsorption isotherm into a linear dataset with various types of the model provided, and perform linear fitting with the new dataset

• Download Fit Adsorption Isotherm app from the page and install the app.

• This App provides a convenient way to transform your raw data related to adsorption isotherm into a linear dataset with various types of the model provided, and perform linear fitting with the new dataset.

1571

APPS-795

Linear Mixed Effects Model

Linear Mixed Effects Model app fits a linear mixed effects model for data collected in groups

• Download Linear Mixed Effects Model app from the page and install the app.

• Linear Mixed Effects Model App fits a linear mixed effects model for data collected in groups. A mixed effects model consists of fixed effects and random effects. Fixed effects are conventional linear regression. Random effects have linear coefficients that vary with respect to one or more grouping variables.

1569

APPS-810

Linear Regression with Marginal Distribution

Linear Regression with Marginal Distribution app can create a report of linear regression, including a graph with marginal distribution.

• Download Linear Regression with Marginal Distribution app from the page and install the app.

• Linear Regression with Marginal Distribution app can create a report of linear regression, including a graph with marginal distribution.

1570

APPS-841

Standard Curve Analysis

Standard Curve Analysis app fits a standard curve like Concentration vs Absorbance

• Download Standard Curve Analysis app from the page and install the app.

• This app fits a standard curve like Concentration vs Absorbance. Such a curve can be used to determine concentrations in "unknown" samples with their measured absorbance. This method is commonly used to analyze RIA or ELISA Data.

• Support HTML report output.

1517

ORG-21489

Add EC90 and EC10 output for built-in functions and Sigmoidal Gadget

EC80 and EC20 are added as output of Dose Response functions and Sigmoidal Gadget

We only output EC80 and EC20 in built-in Fitting Functions in the past. EC90 and EC10 are added in the following fitting functions and Sigmoidal Gadget.

• Boltzmann

• DoseResp

• Hill

• Hill1

• Logistic

• MichaelisMenten

1518

ORG-19163

Support better way to handle large x in polynomial fit

If X values are large, Mean is subtracted from X before fitting in polynomial fit

Mean is subtracted from X before fitting. Not works if Fix Intercept option is checked.

1519

ORG-12333

System variable for number of iteration of fixed center in fitting

@FCI is added to control the number of iteration in fitting

System variable @FCI is added in Origin 2020b.

When @PFFC is not set as 0, set @FCI to set the the number of iterations of fixed center in fitting.

1506

ORG-21147

Output Gadget results to source data workbook

Support to output Gadget results to source data workbook

In the past, user could only output gadget results to new workbook.

In Origin 2020b, user can specify [<input>]Sheet2 to output results to new sheet Sheet2 in source data book.

1516

ORG-21250

Put more useful information in analysis that output to matrix

If the result of analysis is matrix, source data’s info will be put to result’s matrix.

The source data's info should be putted to  the result matrix object's metadata, such as sheet name, long name, unit, comment and so on

1507

ORG-21274

Support Multiple Dataset Identifier in analysis result

Support identifier from multiple datasets in analysis results

User can specify more than 1 Dataset Identifiers, e.g. In Statistics on Columns, Fitting, Peak Analysis, etc.

1577

APPS-813

Direct Linear Transformation

Direct Linear Transformation app can be used to perform direct linear transformation to do camera calibration and reconstruct 3D coordinates of points by 2D coordinates.

• Download Direct Linear Transformation app from the page and install the app.

• Direct Linear Transformation app can be used to perform direct linear transformation to do camera calibration and reconstruct 3D coordinates of points by 2D coordinates.

1514

ORG-21059

Batch Peak Analysis improvements

Batch Peak Analysis Improvements: Recalculation Support, Sort Output Sheet by Peak Index, Auto Picks All Plots in an Active Graph Window

• Speed improvement of batch peak analysis

• Recalculation support of Batch PA

• All Columns option in Input node

• Sort Output Sheet by Peak Index checkbox to show peaks by peak index. E.g. peak 1 of all spectra show together, then peak2 of all spectra, and so on.

• Further speed up to open Batch Peak Analysis dialog when input has many XY datasets

• Better error message on Messages log so user knows which data failed during batch processing.

• Batch PA picks all plots in page if starting from Graph window

• Put Dataset ID in user-defined parameter row when appending results by Columns

1512

ORG-21218

Customize Peak Filtering Method with script

Peaks can be filtered by script in Peak Analyzer

New Filter Condition box added on Find Peaks page of Peak Analyzer to set some condition of found peaks

E.g. write n<=3 AND hp>=20 so find no more than 3 peaks found peak height must be no less than 20% of maximum height.

1511

ORG-21205

Option to use data in x axis range when doing PA from zoomed in graph window

Peak Analyzer provides option to use data in x axis range when doing PA from zoomed in graph window

1513

ORG-21225

Peak analysis on plot with Y error bars

When there is Y Error bar in plot and open Peak Analyzer, the Y Error will be included in Input data and using weighting method to control peak fitting

When there is Y Error bar in plot and open Peak Analyzer, the Y Error will be included in Input data on first page. Weighting method is still controlled on Fit Peaks page. User can save PA theme with Y error bar and use on new plot with error bar.

1510

ORG-21228

Sort Peaks in Peak Properties sheet

Peaks can be sorted in Peak Properties sheet in Peak Analyzer

Sort worksheet wasn’t supported in Peak Properties sheet before Origin 2020b.

1576

APPS-860

Modified Short-Time Fourier Transform

Modified Short-Time Fourier Transform app can be used to perform short-time Fourier transform with the window size fixed in the frequency domain

• Download Modified Short-Time Fourier Transform app from the page and install the app.

• Modified Short-Time Fourier Transform app can be used to perform short-time Fourier transform with the window size fixed in the frequency domain, that is to use the concept of the short-time Fourier transform, but fix the window size in the frequency domain instead of in the time domain.

1573

APPS-714

Canonical Correlation Analysis

Canonical Correlation Analysis app can be used to measure the correlation between two multidimensional variables.

• Download Canonical Correlation Analysis app from the page and install the app.

• Canonical Correlation Analysis app is used to measure the correlation between two multidimensional variables. It transforms them into two combinations of canonical variates by finding a set of linear coefficients. The coefficients are chosen so that they maximize the correlation between the two combinations of canonical variates. The number of canonical variates equals the smaller dimension of the two source variables.

1574

APPS-822

Nonmetric Multidimensional Scaling

Non-metric multidimensional scaling (nMDS) app can be used to transform multidimensional data into lower dimensional representation. Bray-Curtis matrix is used as dissimilarity matrix

• Download Nonmetric Multidimensional Scaling app from the page and install the app.

• Non-metric multidimensional scaling (nMDS) is used to transform multidimensional data into lower dimensional representation. Bray-Curtis matrix is used as dissimilarity matrix.

1575

APPS-561

SVM Classification

SVM Classification app can be used to perform the support vector machine algorithm for classification.

• Download SVM Classification app from the page and install the app.

• SVM Classification app can be used to perform the support vector machine algorithm for classification.

1523

ORG-21366

ANOVA support ordinary numeric data as Factor

To display the X axis of interaction plot in two way ANOVA to be numeric instead of text, Origin 2020b improved Group designation to support such requirement.

To display the X axis of interaction plot in two way ANOVA to be numeric instead of text, Origin 2020b improved Group designation to support such requirement.

1522

ORG-20798

Easy way to select data for ANOVA

Enable user to select data from worksheet in RAW data mode for ANOVA tools

ANOVA Tools dialog Add a ▶ button next to the Data node for Raw data

1525

ORG-18845

Request for pairwise group comparison in survival analysis

Options to perform Pairwise Comparisons in Kaplan-Merer Estimator tool.

Origin 2020b supports Pairwise Comparisons in survival analysis tools.

1521

ORG-21407

Statsxy X-Function to get statistics by binning

Calculate statistics on Y based on X Binning

Calculate statistics on Y based on X Binning. Multiple quantities can be calculated.

1524

ORG-8509

Support 3D plot in Principal Component Analysis

Support 3D Loading Plot , Score Plot and Biplot for Principal Component Analysis

Origin 2020b add 3D Loading Plot , Score Plot and Biplot for Principal Component Analysis.

1520

ORG-8015

Support Mean Comparison in 3 Nonparametric analysis tools

Support Nonparametirc Mean Comparison in 3 Nonparametric ANOVA tools

Support multiple mean comparison for Kruskal-Wallis ANOVA, Moods Median Test and Friedman ANOVA.

1505

ORG-20943

Database import supports importing images

Database import now supports importing images into images in worksheet cells. Tested with MySQL and SQL Server only.

Database import now supports importing images into images in worksheet cells. Tested with MySQL and SQL Server only.

1504

ORG-20953

Database now supports ODBC-based connection strings.

Can now specify ODBC settings in a connections string.

Can now specify ODBC settings in a connections string. For example:

1503

ORG-19571

Slow database queries can now be aborted.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.

1478

ORG-21440

Image slider

When there are multiple images in same matrix sheet, user can drag the image slider to quickly view images.

When there are multiple images in same matrix sheet, user can drag the image slider to quickly view images. User can toggle between image slider or thumbnail with matrix mini toolbar.

1500

ORG-20712

Origin C++ code to import MDF4

Origin C support for MDF4 Connector App for MDF4 files import.

Origin C support for MDF4 Connector App for MDF4 files import.

1493

ORG-21424

Add workbook level properties related to data connector

Add workbook level properties related to data connector on multiple sheets

• wbook.dc.mfiles=0 //if current book support multiple data source 0: not supported, 1: supported. Set it to 1 to have different data source on different sheet

* wbook.dc.nConns= // ready only, number of connected sheets. if it’s bigger than 1, and wbook.dc.mfiles=0, then changing source on one sheet will change the source for all connected sheets

1482

ORG-21338

Connect Multiple Files

Connect to multiple data files at one time. This is only supported for some data types such as CSV, HDF, Excel, Matlab, NetCDF.

Connect to multiple data files at one time. This is only supported for some data types such as CSV, HDF, Excel, Matlab, NetCDF.

1484

ORG-21759

Data Connector related toolbar buttons

3 new buttons for Import toolbar： Import all Connected Data, Connect to data from web and Connect Multiple Files

3 buttons added at the end of Import toolbar

• Import all connected books in project – it will reimport data in all books with data connection

• Connect to data from web…

• Connect Multiple Files…

1488

ORG-21540

Data Connector to support child matrix book

Certain data connectors (NetCDF and HDF5) supports importing matrix data into matrixbooks embedded in workbooks.

Certain data connectors (NetCDF and HDF5) supports importing matrix data into matrixbooks embedded in workbooks.

1485

ORG-21283

Data Navigator

Data Navigator shows on the left side of workbook/matrix book for applicable data connectors, e.g. Excel, Origin Project, Matlab, NetCDF, etc.

Data Navigator shows on the left side of workbook/matrix book for applicable data connectors, e.g. Excel, Origin Project, Matlab, NetCDF, etc.

User click right click sheet(s), datasets there to import into new sheet, same sheet, remove, etc.

1487

ORG-19709

Drag and drop data with Data connector Improvements

Importing data, data connector will be used by default. When dragging and drop a file into an analysis template with data import settings saved, it will use the old import method.

• For data type that can be imported by both data connector and old import method, data connector will be used by default.

• When dragging and drop a file into an analysis template with data import settings saved, it will use the old import method.

You can alter this default behavior with a new 2020b system variable, @DDC, which stands for Disable DC (for drag and drop)

1489

ORG-21494

Support worksheet comments via Origin Connector

Origin DC can now retrieve worksheet comments when using a query.

Origin DC can now retrieve worksheet comments when using a query. for example:

Select Column From Project Where Sheet_Comments like "Sheet1" and Book_Comments like "Book1"

1567

APPS-875

BioLogic Connector

BioLogic Connector app can connect the Origin project to BioLogic MPR (*.mpr) files.

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

• BioLogic Connector app can connect the Origin project to BioLogic MPR (*.mpr) files.

1566

APPS-838

MetroPro Connector

MetroPro Connector app can connect the Origin project to MetroPro binary data file (*.dat).

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

• MetroPro Connector app can connect the Origin project to MetroPro binary data file (*.dat).

1565

APPS-845

 Minitab Connector

Minitab Connector app can connect the Origin project to Minitab 19 projects (.mpx) and worksheets (.mwx).

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

• Minitab Connector app can connect the Origin project to Minitab 19 projects (.mpx) and worksheets (.mwx).

1568

APPS-916

MDF4 Connector

MDF4 Connector app can connect the Origin project to MDF4 (*.mf4) files.

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

• MDF4 Connector app can connect the Origin project to MDF4 (*.mf4) files.

0

APPS-915

NetCDF Connector

NetCDF Connector app can connect the Origin project to NetCDF (*.nc, *.cdf) files.

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

• NetCDF Connector app can connect the Origin project to NetCDF (*.nc, *.cdf) files.

1486

ORG-21284

CSV Data Connector supports wildcard in defining Data Block Marker.

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).

1494

ORG-21684

HTML DC Improvements

Added new Options item to HTML Connector sub menu, and system variable @DCW to initialize the options in Options dialog.

Added new Options item to HTML Connector sub menu, and system variable @DCW to initialize the options in Options dialog.

@DCW = 0 (default), Cache result of HTTP request and use specified in raw HTML source.

@DCW = 1, Do not cache result of HTTP request.

@DCW = 2, Run javascripts associated with HTML. May provide altered table content.

@DCW = 3, Both above.

1483

ORG-21384

Import multi-sheets with Excel Connector

In Origin 2020b, after connect to an Excel file, all sheets are listed in the Data Navigator on the left of workbook window.

Before Origin 2020b, user could only connect to one sheet of Excel file at a time. In Origin 2020b, after connect to an Excel file, all sheets are listed in the Data Navigator on the left of workbook window. User can select sheet(s) there to import.

1501

ORG-20719

Make Database Consistent with Data Connector

Database Connector supports Auto Import and Graph Import Icon.

• Added Auto Import for Database Connector: Added Auto Import menu item to Database Connector submenu for auto import when open the project with Database Connector.

• Added Graph Import Icon for Database Connector: When make a plot using data from database connector, save the project and reopen, will show an import icon on the Graph page

1496

ORG-21411

MATLAB and HDF Data Connector Improvements

For MATLAB and HDF connector that import into matrix, added system variable @MSS=10.

For MATLAB and HDF connector that import into matrix, added system variable @MSS=10.
If number of matrix > @MSS, then show thumbnail area using slider.

1491

ORG-21176

MATLAB Connector transpose imports 1*N mat data

MATLAB 1 dim matrices shall be transposed in order to fit into a worksheet column.

MATLAB 1 dim matrices shall be transposed in order to fit into a worksheet column.

1492

ORG-20224

NetCDF Connector available from menu

NetCDF Connector app supports importing netCDF 4 dimensions one slice as 3D data into Matrixpage.

Added NetCDF Connector app for netCDF file import, which can be accessed from menu Data: Connect to File: NetCDF

NetCDF Connector supports importing netCDF 4 dimensions one slice as 3D data into Matrixpage, for example:

When a netCDF file have a 4D variable e, give it a selected path: NetCDF/e[x][y][z][1],NetCDF/e[z][1][y][x]etc

1497

ORG-19299

New support for Web Connector

Web Connector supports HTTP Post Requests, Self-signed SSL Certificates and improve auto detect for JSON files

•  Support HTTP Post Requests.

• Improve auto detect for JSON files.

• Support Self-signed SSL Certificates.

1499

ORG-20993

Pipe bar delimited ASCII

CSV Connector supports import pipe bar delimited ASCII file.

CSV Connector supports import pipe bar delimited ASCII file.

1498

ORG-20789

Support Import newer IMC Famos File Format

impFamos supports importing the new imc3 format.

impFamos supports importing the new imc3 format.

1480

ORG-234

Apply same color palette to all matrix objects if image slider is on

When image slider is on, user can use the color palette toolbar button to apply same color palette to all matrix objects in same sheet.

When image slider is on, user can use the color palette toolbar button to apply same color palette to all matrix objects in same sheet.

1404

ORG-21258

Change data type, display, digits, etc. of multiple matrix objects in same matrix sheet together

Apply to matrices to the right checkbox is added to apply same format to all matrix objects in current matrix sheet.

Apply to matrices to the right checkbox is added to apply same format to all matrix objects in current matrix sheet.

1407

ORG-21251

Edit Matrix/Virtual Matrix Z Title in OM

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.

1481

ORG-20944

More shrink methods in Matrix Shrink dialog

In Origin 2020b, more shrinking methods are provided such as sum, max, min, sd, keep first cell, keep last cell.

Before Origin 2020b, user could only reduce the number of rows and columns in matrix by averaging. In Origin 2020b, more shrinking methods are provided such as sum, max, min, sd, keep first cell, keep last cell.

1476

ORG-21624

SCV data copying and referencing improvements

Can now use offsets from i when copying column data using Set Column Values.

Can now use offsets from i when copying column data using Set Column Values. Define range to a subset of data in the Before Formual Scripts section, then applit an i=based offset in the Formula. See illustration below.

Last value in column may now be references as A[0] or A[end]. Range to end is A[5:0] or A[5:end].

1477

ORG-20808

Support cell formula update when copy and paste

When copy and paste a cell formula to other cell, the formula will automatically update.

Example I: Enter formula “=A1/B1” in C1 cell, copy it and paste to C2 cell, formula will automatically update to “=A2/B2”.

Example II: Enter formula “=total(A)” in C1 cell, copy it and paset to D1 cell, formula will automatically update to “=total(B)”.

1554

1. ORG-21703

Show Cell Contents similar to ExcelShow Cell Contents similar to Excel

For text and numbers, show whatever can fit instead of showing ####

Instead of showing #### when text or numbers are too long,

• For text, show beginning characters that fit in the cell

• For numbers, round numbers to show whatever can fit in the cell

• System variable @WPE=1 to turn off the feature

1467

ORG-21150

Allow more characters for Text format cell

Increase the limitation for a Text format cell, now you can enter up to 799 characters in a cell. For a Text & Numeric format cell, you can enter up to 3799 characters.

Increase the limitation for a Text format cell, now you can enter up to 799 characters in a cell. (In previous version, the limit is only 252 characters)

If you want to enter more, just use the default Text & Numeric format. For a Text & Numeric format cell, you can enter up to 3799 characters.

1474

ORG-21548

Copy Column Improvement

Copy Column supports to sort output worksheet.

• Add option to sort output worksheet.

1383

ORG-21107

Copy data (columns or range) from worksheet or matrix and paste as plot in existing graph window.

In column/range level mini toolbar, Copy for plotting button can use to copy data from plot. Labtalk command also supports script for it.

• Copy for plotting button in column/range level mini toolbar to copy data and then Ctrl+V to paste as a plot in an existing graph window

• LabTalk command to Copy (worksheet must be active, with some selection):

  worksheet -cp; paste what was copied above (graph must be active):

  layer -pcp; //paste, CANNOT undo

  layer -pcpu; //paste, CAN undo

   

1401

ORG-20833

Easy way to go to corresponding graph from result sheet

When user click green lock in result sheet, Go to Graph context menu is added to easily go back to the graph.

When user click green lock in result sheet, Go to Graph context menu is added to easily go back to the graph.

1473

ORG-18694

Highlight entire row by condition

Add option Apply Coloring to Sheet to Conditional Formatting tools, include wcolor, wheatmap, and wcolordup XF.

Add option Apply Coloring to Sheet to Conditional Formatting tools, include wcolor, wheatmap, and wcolordup XF.
Select it, so you can apply the color to entire row.

1475

ORG-21691

Join Worksheets Improvements

Origin has X-Function to join worksheets by column or label but no menu for it.

• Origin has X-Function to join worksheets by column or label but no menu for it. They are added under Worksheet menu now:

  • Join worksheet by Column

  • Join worksheet by Label

• More options

  • Simpler syntax. When joining sheets with column A, older syntax [Book1]Sheet1!A=[Book2]Sheet1!A. New syntax: A or Time is time is the long name

  • Sort Output ascending and descending

1466

ORG-20855

Support keyword "This" for workbook with Spreadsheet cell notation off

Support keyword "This" for workbook with Spreadsheet cell notation off

E.g. Enter This+1 to F(x) cell.

Enter mean(This) in user-defined parameter row or bottom of the column.

1468

ORG-19975

Worksheet name improvement

• Change Sheet Long Name to be called Sheet Label.

• Add system variable @SSL to control sheet display name. Default @SSL = 2, Short Name will be shown.

• When loading project previous Origin 2020b, sheet name will be auto rename to original Long Name if name is like "SheetN", and Long Name will be removed.

1551

ORG-20873

ASCII Export Speed Improvement

The ASCII Export has been improve a lot, and the elapsed time can be 6 times faster.

The ASCII Export has been improve a lot.
Suppose to export a worksheet with 10 columns and 100,000 rows of data, the elapsed time can be 6 times faster.

1552

ORG-21006

Export XML from Worksheet

Provide X-function, expxml, to enable user to export worksheet as XML files

Provide X-function, expxml, to enable user to export worksheet as XML files

1556

ORG-21387

Copy as Image on EMF cell mini toolbar

Mini toolbar button on image cell in worksheet to copy image to clipboard and paste to other application

If it’s an EMF image cell, there will be copy and copy as image button on mini toolbar. Use Copy as Image button to copy the image and paste to other application.

1515

ORG-20579

Speed improvements of Unstack Columns

Using multi-threaded for Unstack Columns calculation, so the speed should be much faster now.

Using multi-threaded for Unstack Columns calculation, so the speed should be much faster now.

For example, unstacks 4M points of data to about 2000 groups, the speed is about 6 times faster.

1472

ORG-21413

Append Worksheet Improvement

Append Worksheet tool supports adding Dataset Identifier and skip hidden column in result sheet.

Add Dataset Identifier in result sheet. E.g. if appending worksheets row wise, new column will be added in result sheet to indicate which sheet the rows are from.

Besides, hidden column will be skipped in result sheet.

1469

ORG-20651

Better support drag to autofill

Using Alt + Enter to auto fill multiple worksheet cells. And support autofill to left or up direction.

• Alt + Enter to auto fill multiple worksheet cells. Highlight block of cells, type something in the first selected cell, then press Alt +Enter will fill all selected cells with same text.

• Support autofill to left or up direction.

1383

ORG-21087, ORG-21221

Mini toolbar for worksheet and Matrix

Support Mini toolbar for worksheet and Matrix

• Quick access to common operations on cell, column, row and worksheet

• Toggle display of cell formula, categorical index, column list view, or worksheet organizer

• Toggle matrix view, image slider, or X/Y coordinates in matrix

• Customize Mini Toolbar buttons

• Shift key (Hotkey) to bring up mini toolbar again

1470

ORG-20648

Remove/Combine Duplicated Rows Tool Improvements

In Remove/Combine Duplicated Rows Tool, supports Multiple Reference Columns and Duplication Tolerance.

• Support Multiple Reference Columns. Values in all reference columns must match to treat as duplicates

• Support Duplication Tolerance. Set duplication tolerance to treat close by values to be duplciates

1471

ORG-21041

Split Worksheet Improvements

Split Worksheet by Reference Column Value speed has been improved by a factor of 10 or more. Support more split options when splitting worksheet by Reference column.

• Split Worksheet by Reference Column Value speed has been improved by a factor of 10 or more.

Tested with a worksheet with 1.8million rows and 5 columns with a reference column of two categories. The split speed improved from 158 sec in Origin 2020 to 12 sec in Origin 2020b.

• More split options when splitting worksheet by Reference column, such as direction change, direction reset, reference value change. E.g. if X value increase, then decrease, and then increase again, user can split worksheet into 3 sheets so each x part is monotonic.

1448

ORG-21093

3D Vector tab should be always visible

3D Vector tab of Plot Details should be always visible even there is no error

If there is no error enable in any direction, then 3D Vector tab should still show.

When Enable 3D Vector is selected but any one of X/Y/Z End is set to none, it means there is no vector, so error bar tab do not

1435

ORG-21375

Zoom and Rescale Hotkeys in 3D graphs

Zoom and Rescale Hotkeys in 3D graphs

• D key + mouse wheel --- zoom in Z direction

• Z key + mouse wheel --- zoom in X direction

• Shift+Z keys + mouse wheel -- zoom in Y direction

Note: Enable clipping on Miscellaneous tab of Layer level of Plot Details dialog will hide plots outside the axis frame.

1400

ORG-20964

Axis mini dialog improvements

Axis mini dialog improvements, such as Change direction, More button and Log scale checkbox

• Change direction: X or Y axis switch in mini dialogs: such as axis scale, grid line style, reference lines, etc.

• More… button to open corresponding tab in Axis dialog

• Log checkbox in Axis Scale dialog

1460

ORG-21129

Axis Reference Line Fill Improvements

Axis Reference Line Fill Improvements, such as fill color between any two reference lines

To add multiple reference line and fill adjacent areas with different color, duplicate reference lines are needed.

E.g. if user wanted to fill from y=0 10 with one color, y=10 to 20 another color, user needed to enter two y=10 reference lines.

It’s improved in Origin 2020b so user can specify fill color between any two reference lines.

1461

ORG-21310

First Tick in Axis dialog and Color Scale Control dialog is renamed as Anchor Tick

First Tick in Axis dialog and Color Scale Control dialog is renamed as Anchor Tick

The name First Tick is misleading. It’s actually an anchor location tick must pass. E.g. if axis is from -2.36 to 3.789. Set Anchor Tick as 0 and Increment as 0.5. The major ticks will show at -2, -1.5, -1, … 0, 0.5, 1, …. 2.5

Same for color scale object. By default we only show ticks on major levels. User can set Levels to Custom Levels. And set Anchor Tick as 0 to make sure level 0 shows.

1464

ORG-17619

plot break marker at the axis breaker region

plot break marker at the axis breaker region, controlled by LabTalk or mini toolbar

Support a control to plot break symbol for line plot and bar plot.
We can use labtalk to control. For GUI, we only support mini toolbar.

1438

ORG-20838

Skew Plots by adjusting Angles between Axes

Skew Plots in Skew Coordinate by adjusting Angles between Axes.

Skew Coordinates controls on Display/Speed tab of Layer level in Plot Details dialog.

1422

ORG-4523

Support negative value in log plot

Support negative value in log plot

When Scale Type is Log10, Ln, Log2, Following options will show in Axis dialog Scale tab under Type:

• Symmetrical Log Scale

• Linear Range Threshold

• Linear Range Length

1463

ORG-19878

Tick Label related improvements

Tick Label: Auto rotate tick labels to avoid overlapping and Auto Hide Overlapped Labels

• Set Rotate (deg.): Auto to auto rotate tick labels to avoid overlapping. Set system varaible @ART=0 to roll back to old way.

• Check Auto Hide Overlapped Labels checkbox when there are many tick labels.

1462

ORG-20753

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

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

• add No Trailing Zero checkbox to remove the trailing zero in axis tick label(such as 5.0-->5)

• add Zero is ‘0' checkbox to always show zero value as '0'(such as 0.0E+0 -->0)

• system variable control @tlc (default 3) so both are checked.

  • @tlc & 1: Zero is '0'

  • @tlc & 2: No Trailing Zero

1428

ORG-21321

Box Chart Improvements

Box Chart: Plus only/Minus only Whisker and mean and median symbol for grouped box chart

• Support Plus only, Minus only Whisker in box chart.

• Mean and median symbol for grouped box chart

1433

ORG-21499

Mask data points in Box Chart

Mask data points in Box Chart

For box chart with data points, user can use Mask tool to mask data points. The masked point will not be used in drawing box chart so the box, mean, median, etc. will be changed.

1429

ORG-21052

More box chart improvements.

Draw Whisker/Error Bar on Top of Data

Draw Whisker/Error Bar on Top of Data checkbox is added on Box tab in Plot Details

1434

ORG-20650

Support Connect Line for 2d and 3D XYY bars

Support Connect Line for 2D and 3D XYY bars

Display tab is added on Plot level to turn on connect line, symbol and dropline for 2d and 3d XYY bar plots.

1423

ORG-19651

Support turning off column/bar baseline

Support turning off column/bar baseline

Origin uses the Additional Y= line on Grids tab of Axis dialog to control where column/bar is plotted from. In the past, the baseline can not be hidden. Origin 2020b supports uncheck the checkbox to hide it but still use it as baseline.

1436

ORG-21363

Heatmap improve to support triangular part and labels follow colormap

Heatmap improve to support triangular part and labels follow colormap

• Fill Display Setting to show triangular part of blocks only.

• Label Display setting to show triangular part of labels only.

• Label color set to auto:

  • If there is fill display. show black or white color according to fill color.

  • If there is no fill, follow fill color.

1430

ORG-21064

Colormap Contour and Worksheet Conditional Format: Heatmap: Allow specifying Middle level value in in 3 color limited mixing

Allow specifying Middle level value in 3 color limited mixing for color fill

By default when using 3-color mixing for contour plots, the middle color falls on the mid point value of From and To value.

In Origin 2020b, user can specify mid color by Value, Percent or Percentile.

1426

ORG-21358

Transparency for Fill color only

Transparency for Fill color only, excluding the edge

In previous versions, transparency was applied to both fill color and edge. Now transparency can be applied to fill only.

1427

ORG-20765

Create Plot with label column designation

Create Plot with label column designation

In very old version, user needed to set a column as Label to show label of a plot. The label is actually a separate plot entry if you open Plot Details dialog.

We hid it now since in newer versions, after plotting data, user can use mini toolbar or Plot Details to set any column as the plot’s label. See Labels tab of plot level. in Plot Details dialog.

But some user may still use the old way to set a column as Label. In Origin 2020b, even if user set a column as L, we plot it as a property of plot so Labels tab is updated with it.

1425

ORG-21477

Show Label at Specified Points with new syntax

Show Label at Specified Points with new syntax just like showing drop lines

• Same syntax as Show Drop Lines at specified points only. e.g. x= 2.5 3.5, etc. If corresponding x value doesn’t exist, the label will not show.

• Show labels at drop lines only

1447

ORG-21320

Support Label each plot of group differently

Support Label each plot of group differently

Show label for each plot differently is now supported.

1446

ORG-20553

Rescale should consider reference line

Rescale should consider the reference lines

Rescale button will consider reference line.

1424

ORG-20695

Show Drop lines at specified points only

Show Drop lines at specified points only with five different syntaxes

The following syntaxes are supported:

1. 1 3 5 – show at specified row indices.

2. 2:0:5 – starting from 2nd row to end, show 1, skip 5.

3. x=3.5 7.8 – show at specified X

4. [book1]sheet2!col(A) – show at specified rows values read from specified column

5. x=[book1]sheet2!col(A) – show at specified X values read from specified column

1454

ORG-21314

System variables to attach text, rectangle and circle objects to Layer & Scale by default

System variables to attach text, rectangle and circle objects to Layer & Scale by default

If text or graphic object is attached to Layer&Frame, the position will stay with axis scale position. If it’s attached to Layer Frame, it will stay where it is even if axis scale changes.

@arx //text object attachment. 1: layer & scale. 0: layer frame (old behavior)

@arr //rectangle & circle attachment 1: layer & scale. 0: layer frame (old behavior)

We already have @ar for line and arrow objects

1398

ORG-20663

Add Fill Color button for Area Plot button to plot mini toolbar

Add Fill Color button for Area Plot button to plot’s mini toolbar

Add new Fill Color button for Area plot, Line plot (Fill Color Under Curve is checked)

1397

ORG-21396

Add Rescale Mini toolbar button to axis .

Add Rescale Mini toolbar button to axis .

Axis mini toolbar now has Rescale button

1396

ORG-21398

Add Rotation Mini Toolbar button for label

Add Rotation Mini Toolbar button for label

Support single/multiple text label(s) rotation.

1456

ORG-21734

Display Filter from Source

Add label to display the filter in source worksheet

User can add label in graph with %(1, @LF, A) to refer to filter condition in source worksheet’s column A.

If user copy columns from source sheet to new book by Copy Columns To tool and plot from the new book, user can use %(1, @LF1) to refer to 1st row of filter condition if there are multiple filter conditions.

1385

ORG-20169

Layer mini toolbar Improvements

More buttons added and rearranged into Layer mini toolbar

• Layer mini toolbar Improvements: Add Rescale button to show all, Add statistics reference lines, Add plot buttons.

• Move Add plot, Show data plot, Clip data to frame and Layer dialog to 2nd line. Move Rescale button to 1st button of 1st line

1391

ORG-21255

Mini toolbar button for data points of box chart

Mini toolbar button for data points of box chart

Mini toolbar button for data point control of box chart (Box type: Data)

1395

ORG-21581

Mini toolbar buttons to rotate polar plot

Mini toolbar buttons to rotate polar plot

Mini toolbar buttons to rotate polar plot.

1405

ORG-21242

More plot type is added under Insert: Plot to Layer sub menu.

More plot type is added under Insert: Plot to Layer sub-menu.

Based on active graph window type and last activated worksheet/matrix, applicable plot types show under menu Insert: Plot to Layer sub menus.

E.g. if user plot a 2D graph and then activate a matrix window then go back to Graph window.

Choose Insert: Plot to Layer, contour, image, histogram types show.

1399

ORG-9298

New Axis break mini toolbar

New Axis break mini toolbar

Customize axis break with axis break mini toolbar.

1431

ORG-21666

Improved color list selection for plot

Once a color list is chosen, it will be used. No need to choose luminescence level

When selecting a color list for a grouped plot, you used to have to select both a color list and a luminescence level. Now you just need to select the color list. You can optionally change the luminescence level separately.

1384

ORG-21169

Page mini toolbar Improvements

More buttons added for Page mini toolbar

Add Window/Page view toggle button (single layer or linked+superimposed layers (e.g double-Y) only), add Fit page to layers button, add Update Page Dimension buttons:

1386

ORG-21110

Plot mini toolbar Improvements

More buttons for Plot mini toolbar

• Add Change Plot To and Edit Range mini toolbar for plot.

• Add Ungroup mini toolbar button for group plot

1439

ORG-20972

Refresh Issue of OpenGL graph

new system variable added to control the refresh Issue of OpenGL graph

A new system variable @RUGT is added to control whether a graph should redraw when uncover. @RUGT is in milliseconds, if a graph spends less than that time to finish drawing, then it will redraw itself when being uncovered (regardless of the @NPP). Otherwise, the @NPP would still be effective.

1442

ORG-19513

Rescale Margin General Improvement

new system variable added to control general rescale Margin

Add system variable to control whether layer should round to tick, @RRT
For plot which is not controlled by rescalemargin, we make it not control by @RRT

1390

ORG-20171

Special Point Mini Toolbar support

Add mini toolbar for special point for customization, hiding, labeling.

Add mini toolbar for special point for customization, hiding, labeling.

1408

ORG-19779

Support Data Highlighter in 3D graph

Support Data Highlighter in 3D graph

E.g. plot 3D scatter graph. Click Data Highlighter toolbar button and drag rectangle to select a region. Corresponding data in worksheet and other graphs are highlighted.

1393

ORG-21200

Support Mini toolbar for data selector

Support Mini toolbar for data selector

Mini toolbar for data selector

1394

ORG-20911

Support Mini Toolbar for graph objects

Support Mini Toolbar for graph objects

• Mini toolbar for graphic object (Line and Arrow, Rectangle and Other Shape, X/Y Scale, Axis scroll bar, Analysis Marker, select Multiple Objects)

• Mini toolbar to customize multiple objects together

1432

ORG-20927

Transparency option for vector plot

Transparency option for vector plot

1555

ORG-21621

Easier to change layer order in Double-Y graph

Drag layer in Object to change layer order will keep the link between layers

In the past, drag layer2 before layer1 will prompt message that the linking will be broken. In Origin 2020b, it will keep the linking.

1562

APPS-812

3D Antenna Radiation Pattern

3D Antenna Radiation Pattern app

• Download 3D Antenna Radiation Pattern app from the page and install the app.

• This propose of 3D Antenna Radiation Pattern app is to help user to plot 3D antenna radiation pattern from a virtual matrix. In addition, this app can also help user to prepare virtual matrix from the raw data.

• Use can use this app to create a 3d antenna radiation pattern, like:

1561

APPS-890

Correlation Plot

Correlation Plot app

• Download Correlation Plot app from the page and install the app.

• Highlight columns in the worksheet. Click the Correlation Plot icon in the Apps Gallery window to open the dialog.

• Custom settings in the dialog, and click OK button.

1563

APPS-784

X-Ray Diffraction Analysis

X-Ray Diffraction Analysis app

• Download X-Ray Diffraction Analysis app from the page and install the app.

• This app can help to do simple X-Ray diffraction analysis in Origin.

• Activate the graph with a diffraction pattern of material, and select the desired reference patterns and the color assignments, click OK button to add it to the graph.

1564

APPS-884

Zoomed Inset Plus

Zoomed Inset Plus app

• Download Zoomed Inset Plus app from the page and install the app.

• Zoomed Inset Plus app can add a rectangle to 2D Cartesian graph with Cartesian coordinate system (line, scatter, and line+symbol plot), so for zooming in the part of plot covered by this rectangle, which is put into an inset layer.

1414

ORG-18848

Beeswarm Plot

Beeswarm Plot

Basically, Beeswarm plot is a kind of column scatter plot with special data point arrangement. Former Jitter Points checkbox is replaced with Arrange Points dropdown list in box chart. Several data arrangement methods are available.

1417

ORG-20552

Bland-Altman Plot

Bland-Altman Plot

Under Plot: Statistics menu.

1412

ORG-21201

Browser Graph in Window View

Browser Graph in Window View

• Plot: Browser menu to plot data (fast for worksheet with many columns) as Black Line, Colored Line, and Histogram. User can customize in Plot Details for more plot types, e.g. scatter, etc.

• Select plots to show in graph by selecting them on left panel. The left panel columns are customizable and sortable.

• Click the dropdown button on left panel for further options,

• When using Scale in toolbar to create a separate enlarged graph, turning off plots in browser graph will turn off corresponding plots in enlarged graph as well.

1418

ORG-21537

Bullet Chart

Bullet Chart

Under Plot: Specialized menu

1419

ORG-21137

Error Ellipse bubble plot

Error Ellipse bubble plot by LabTalk

Make Ellipse plot by running script:

worksheet -p 112 ellipse;

1415

ORG-21315

Plot 3D Bars side by side

XYY 3D Side by Side Bars

Plot: 3D: XYY 3D Side by Side Bars menu to plot such graph.

Side by Side Bar Style checkbox is added on Miscellaneous tab of Layer level of Plot Details dialog

1416

ORG-21429

Radial Bar Plot and Stacked Radial Plot

Radial Bar Plot and Stacked Radial Plot

User can select multiple Y data to create stacked polar graph, including line, area and column/bar

Under Plot: Specialized Plot menu

1413

ORG-19927

Streamline Vector Plot

Streamline Vector Plot

Plot > Specialize: Streamline (when a matrix with two object is the active window)

The two matrix objects are the derivatives of the plotted curve in the (x,y) directions, respectively.

1403

ORG-20834

Change X or Y of plot to column from other worksheet

Change X or Y of plot to column from other worksheet

• Select Columns is added under Change X and Change Y to pick column from other worksheet

• Old Select Columns context menu is renamed to More… to select other column in current sheet when containing multiple columns.

1421

ORG-21204

Common Display Range for plots in layer

Common Display Range for all plots in same layer

Run “layer.commonrange=1” in script window to use common range for all data plots. Then right click any plot to Edit the range. Other plots will show the same range.

1402

ORG-20528

Reverse Plots from Object Manager

Reverse Plots from Object Manager

In Object Manager window, right click layer node to reverse plot orders.

E.g. after reversing, the graph above will turn into

1387

ORG-20970

Separate Mini Toolbar buttons for X and Y Errors

Separate Mini Toolbar buttons for X and Y Errors

X and Y Error bars have separate Mini Toolbar controls.

1441

ORG-21347

Show Hide Plot with Specified Name

Add a edit box and fly-out button after Show/Hide Plots with Same Name. The fly-out is same as Legend Custom Format fly-out.

For multi-layer graphs with common display for show/hide plot with same name checked, it only works for same name legend.

In Origin 2020b, edit box and flyout buttons are added after Show/Hide Plots with Same control on On Layers tab of page level of Plot Details dialog. E.g. if user set it to same comments. Then when uncheck some plot in Object Manager on one layer, plots with same comments in other layers will be hidden.

1420

ORG-20318

Fill to relative base in Stack lines by Y Offset graph

Fill to relative base in Stack lines by Y Offset graph

In the past, when user fill area under curve in Stacked lines by Y offset graph, they are filled to the same base. See left graph.

In Origin 2020b, on Stack tab of Layer level in Plot Details dialog, a Custom Additional Line by Relative Position checkbox is added. Check it, each curve will be filled to relative additional line. Note: The additional line position is set on Grids tab of Axis dialog. E.g. y=0.

1445

ORG-20319

Additional Line for Polar Axis

Additional Line in Angular axis for Polar Axis

Add Additional Line branch to Grids tab in Angular Axis.  Fill area under curve and drop line to additional line will work when Additional Line is set to a R value.

1450

ORG-19835

Better Radial Grids for Polar

Polar Axis dialog now supports set radial axis' reference line fill to itself

Polar Axis dialog now supports set radial axis' reference line fill to itself. So fill inside circle is available now.

1444

ORG-21553

Polar Bar Support axopetal gradient fill

Polar Bar supports axopetal gradient fill

Polar bar has two-color gradient fill, with one color to another towards the center of the polar graph. Four options are added:

• Radial Inward

• Radial Outward

• Radial Center Out

• Radial Center In

1443

ORG-21461

Polar Bar Support Label

Polar Bar Support Label with offset

Change Horizontal Offset and Vertical Offset to Angular Offset, and Radial Offset in Label tab for polar plot. And they work like polar scatter with Position=angular inner/outer.

1457

ORG-9378

Alignment for multi-line text objects

Alignment for multi-line text objects

• Support left, center, right alignment for normal text object and legend object.

• For legend, this option should treat text part and legend symbol as separated columns, and only affect text column.

• Make Alignment buttons on Format toolbar work for multi-line text.

• Add alignment button to mini toolbar of text object but do not need this button for legend.

1459

ORG-21106

Color Scale Tick Label Size Affect Bar Width

Changing font size will modify value for Color Bar Thickness but bar width won’t change

Changing font size will modify value for Color Bar Thickness so color bar width will not change accordingly.

1452

ORG-18493

Curve Tool

Curve Tool: connect the close start and end point;drag to change shape;fill pattern and color

• It draws a smooth line object. When the last point is close to 1st point, it will be connected.

• 1st click on curve will enter edit mode. Drag the solid handlers on cursor to change the shape

• Support fill curve and polyline objects with pattern and color

1458

ORG-20930

Date Time Stamp use modified date format on new graph

Date Time Stamp use modified date format on new graph

When text object name is timestamp, we support a copy of text object default for this name. Basically, it will need to contain all text, position, frame related format except text content.

When user click Date&Time Stamp button, we create text object with this default.

No matter which layer user selected, we only create Date&Time stamp for 1st layer. Since we will update when there is existing time stamp, so active other layer will just update time stamp of 1st layer.

1455

ORG-21583

Set X Y Data Label & Annotation to follow axis tick label display and formula

Set X Y Data Label & Annotation to follow axis tick label display and formula

Origin supports formula for tick labels.

If it’s used and then user adds data label, annotation, and some gadgets to show X, Y value, user can set Custom Format as X, Y, Z to show value based on tick label formula.

For Data Label, when picking Y as Label Form, set Custom Format as Y, Y, .2, Y, *4 to set decimal places and significant digits.

For data annotation, set label form as $(Y, Y), $(Y, Y, .2), $(Y, Y, *4)

This also applies to Vertical Cursor and Quick Peak gadgets.

1437

ORG-21433

Support displaying area plot’s border line style in legend.

Support displaying area plot’s border line style in legend.

1453

ORG-19962

Text Customization Improvements

Text Object dialog: Add Sub- and Superscript; Select Multi-lines to customize

• Add Sub- and Superscript for non-consecutive characters

In Text Object dialog, if non-consecutive characters are selected with Ctrl key, set it to superscript or subsript now keep it’s position.

• Select Multi-lines to customize in Text Object dialog

1392

ORG-21470

Wrap text button for legend, axis title and text labels

Wrap text button for legend, axis title and text labels

Wrap text button for legend, axis title and text labels

1451

ORG-9996

Wrap Text in Legend, Axis Title, Text Labels on graph

Wrap Text in Legend, Axis Title, Text Labels on graph

E.g. click legend, and choose Wrap Text button on mini toolbar. Drag the edge of legend box to resize it. Legend will be wrapped.

A Wrap Text, Adjust Height checkbox is added on Frame tab Text ProObject dialog.

Note: When it’s wrapped, we don’t support resize the text to change font size. Please use mini toolbar or regular toolbar.

1440

ORG-21184

More settings can be set as default in Image Profile

Profile Plot Type, Profile Line name

• We add following in Default Settings dialog.
  Profile Plot Type --> Line (default), Scatter, Line+Symbol
  Set default legend as Profile Line Name

1411

ORG-21000

Easy manipulation on Theme Editor dialog

Easy manipulation on Theme Editor dialog

• Press + or - key on numeric keypad to expand/collapse the branch. press * key to recursively expand selected branch and its children. Press Backspace key to go to the parent

• Add 2 context menus:
  Expand Recursively
  Collapse Recursively

1449

ORG-13618

Theme Editor Improvement

Theme Editor: Select property in filter should be in screen when filter is off; Collapse All Siblings

When filter is selected, turn off the filter(select All) should keep the selected option in screen. If there are multiple selection, the first one should be in screen when filter off.

When user select a branch and right click, we should show an option "Collapse All Siblings" in context menu. Select this option means we will collapse all branch with the same level as the current selected one.

1549

ORG-21190

Allow Matlab Console to connect to already running instance of Matlab

Matlab Console is able to connect to already running instance of Matlab

If there is already a running Matlab instance existing, Origin will promp a massage asking if you'd like to connect to it. You will need to copy and execute a Matlab cmd in order to enable the connection.

1553

ORG-21278

Relink broken DDE links

When user open the file with broken links, it will ask user for file

For project with DDE links to an Excel file, if the Excel file is moved, the DDE links are broken. When user open the file, it will ask user for file that does not exist.

1550

ORG-21415

Allow copy paste of images and store them as project attachment

Drag and drop image to notes window/HTML report will create a matrix of image to keep image with project.

Drag and drop image to notes window/HTML report will create a matrix of image to keep image with project.

1406

ORG-21359

Shift+Up/Down arrow in Object Manager

Support Shift+Up/Down arrow to select multiple objects in Object Manager

Quick way to select multiple sheets in Object Manager.

1548

ORG-20696

Show all Pro menu in Regular Origin

OriginPro menus show in regular Origin, with suffix (Pro) on the menu.

OriginPro menus are hidden in the past in Origin regular so many Origin user doesn’t even know they can upgrade to OriginPro to have the feature.

In Origin 2020b,

1. OriginPro menus show in regular Origin, with suffix (Pro) on the menu.

2. Click it will open a message box to let user know it’s an OriginPro feature and consider upgrading.

3. Set system variable @rpm=1 to hide OriginPro menus in Origin.

1542

ORG-21526

Dialog supports multiple columns under the checkbox in branch.

Dialog supports multiple columns under the checkbox in branch.

1388

ORG-20527

Customization of Mini toolbar

User can click the … on mini toolbar pop-up to specify the buttons to show

User can click the … on mini toolbar pop-up to specify the buttons to show.

1409

ORG-21678

Disable all modified system variable values

System variable @@ can be used to disable all modified system variables.

A user system variable @@ to disable all modified system variables.

• 1 - disable

• 0 - enable

E.g. in Script window, run the following to disable modified system variables to go back to system default.

@@=1 //press Enter key

1547

ORG-21279

Save Separator Settings to Project

File: Properties… menu to save separator settings and then save into project file.

File: Properties… menu to save separator settings and then save into project file.

Audit Log and Password protection still needs to be set in Tools menu

0

ORG-20709

MDF4 Connector

Origin C support for MDF4 Connector app to import MDF4 (*.mf4) files.

Origin C support for MDF4 Connector app to import MDF4 (*.mf4) files.

1490

ORG-21435

Origin C support to import MPR File

Origin C support for Biologic file import App to import o BioLogic MPR (*.mpr) files.

Origin C support for Biologic file import App to import o BioLogic MPR (*.mpr) files.

1495

ORG-19856

Origin C support to read tables from PDF files

Origin C support for Extract PDF Tables App to import tables from PDF files

Origin C support for Extract PDF Tables App to import tables from PDF files

1537

ORG-21432

Access to name of embedded notes window

Provide labtalk function to access to name of embedded notes window

With embedded notes sheet active, run the following to pop the notes window open

win -an %@G;

1538

ORG-21409

Connect to Web Support Self-Signed SSL certificate

Accept self-signed or invalid SSL certificates checkbox is added.

Many intranets use self-signed SSL certificates. Connect to Web can accept them via Accept self-signed or invalid SSL certificates checkbox. Otherwise there will be an error if not checked.

1533

ORG-21202

LabTalk command to open Edit Range dialog

Provide Labtalk command to open Edit Range dialog to edit display range of plot

layer -ep to edit display range of plot

1530

ORG-21286

Labtalk function to Join arbitrary ranges as a single dataset

Provide labtalk function to Join arbitrary ranges as a single dataset

Dataset join(range1, range2, ...)

e.g. =mean(join(A1:A2, C5:D8)

1526

ORG-21065

LabTalk functions to categories operations

Provide new labtalks functions for category operations

They are accessible under It’s Function → Lookup & Reference menu in Set Column Values dialog

• category(vd)$ – e.g. category(A) or category(A)$

• catindex(vd) – e.g. catindex(A)

• catrows(vd)$ – e.g. catrows(A) or catrows(A)$

• cattext(vd, vd)$ – reverse of catindex(), e.g. cattext(E, A) or cattext(E, A)$

1534

ORG-21188

LabTalk property to get plot type info

Layer property to get plot type info

layer.plot1.pid

1532

ORG-21236

Some LabTalk function Improvements

• Set Column Values dialog: Under Function: Lookup & Reference and Function: Logical submenus, adding [$] functions at the end of those functions that return string

• Some lookup() function bug fixes, including system variable to disable numeric lookup @LKN=0

• Now all LabTalk function is improved to support using partial range as input.
  Example,

1527

ORG-21078

New Column Properties

New Column Properties are added to check whether the column is categorical or to be using sampling interval

• New Property IsCat to set a column to be categorical or check a column is categorical

wks.col1.IsCat

• New Property EvenX to both get and set a column to be using Sample Interval.

wks.col1.EvenX

1539

ORG-20879

Page Control Pane Framework

Support Labtalk for Page Control Pane

Support LT for Page Control Pane.

page.cp.Add();//add a control pane to the left with default

page.cp.Add(2 40 DataConnector 3);

//First parameter: 1=left, 2=top,3=right,4=bottom

//Second parameter: window width(%)

//Third parameter: control pane type

//Four Parameter: APPLY Button = 1, Hide Show Pane Button=2

page.cp.Remove();//Remove control pane

page.cp.Show = 0;//to hide it, and =1 again to show it

1529

ORG-21288

Useful Labtalk functions added

Sem() and Between() Labtalk functions

• Sem(vd) to calculate standard error in cell, column formula and script. Available under Under Function → Statistics menu in Set Column Values dialog.

• Between(str$, str1$, str2$)$ function to extract text between certain strings, E.g. if column A is filled with email addresses, use use between(A, "@", "."). to get text between @ and .

1536

ORG-21671

Set Order for Worksheet column labels quickly

Using wks.Labels(@) to reset current worksheet column label row to default order.

wks.Labels(@);

Reset current worksheet column label row to default order.

1528

ORG-21127

Split Text Cell / Text to Columns tool like Excel

Add X-Function to split Text Cell / Text to Columns tool like Excel

Add xfunction text2cols.OXF and put it under : ..\Origin\X-Functions\Data Manipulation\Worksheet\text2cols.OXF

In Script window, type text2cols -d to open the dialog

1531

ORG-20706

Support returning vector result to LT StringArray

Vector properties are also available to StringArray

Following usage is now supporting.

1535

ORG-21674

Unix timestamp conversion function

UnixTime() to convert to and from Unix timestamps.

New function to convert to and from Unix timestamps.

double UnixTime(d1[, d2, n])

Where d1 is a Unix timestamp or Julian date, d2 is a timezone offset (default 0), if n=0 (default) convert from Unix time stamp to Julian date. If n=1 it convert from Julian date to Unix timestamp. Supports vectors for SCV usage.

1543

ORG-21022

Add ReorderColWise function for matrixbase class

Added an OC function, ReorderColWise(), for matrixbase class:

Added an OC function for matrixbase class:

BOOL ReorderColWise( const vector<UINT> & vnIndices, int nR1 = 0, int nR2 = -1 )

1541

ORG-21369

Local Variables should support matrix in Code Builder

Local Variables should support matrix in Code Builder when debug in Origin C

When debug in OC, click on the down arrow menu button on the right side of the magnifier icon, and select Object Visualizer to view following data type:
Column
Worksheet
WorksheetPage
MatrixObject
MatrixLayer
MatrixPage
GraphLayer
GraphPage
...
matrix
matrixbase
vector
vectorbase

1546

ORG-21025

OrgLab Improvements

Add more methods and properties to OrgLab classes

• Added these two methods to MatrixSheet:

• Added these two properties to MatrixObject:

• Added the method to 

PageBase class, which allows moving any PageBase to a PE folder.

OODL_PREFIX_METHOD(ODISPID_PAGEBASE_MOVE_TO_FOLDER) HRESULT MoveToFolder([in] VARIANT fld);

• Added 

Comments string property to PageBase class to access WorksheetPage and MatrixPage Comments.

Column::SetData, MatrixObject::SetData, Worksheet::SetData, etc will convert 1.#QNAN values to Origin NANUM.

1544

ORG-19973

Support button in HTML report

Support button in HTML report

See example when Note window active, HTML: Load Samples: Combo and Button.html

1545

ORG-21472