Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Analysis

Fitting

ID

JIRA

SUMMARY

Description

DETAILS

0

APPS-199

2D Peak Analysis

Perform 2d peak fitting and integration for each peak.

Download 2D Peak Analysis app from the page and install the app.

This app can be used to perform 2d peak fitting, and integrate each peak fitted data.
Features include:

  • Perform surface/matrix fitting for 2d peak.

  • Do integration for each peak's fitted data.

  • Show preview by contour plot or colormap surface plot.

  • Change each peak's center and width by typing value or resizing peak marker.

  • ROI support.

  • Multiple peak fit support.

  • Baseline support for integration.

    Image Removed

    Image Added


0

APPS-704

Neural Network Fitting

Fit data with neural network.


Download Neural Network Fitting app from the page and install the app.

This app can be used to fit data with neural network. It trains a neural network to map between a set of inputs and output.

Features include:

  • Custom number of layers and number of  hidden neurons in each layer

  • Choose algorithm to calculate the neural network weights

  • Perform K-fold cross validation

  • Predict response of independent variables with trained neural network.

...

ID

JIRA

SUMMARY

Description

DETAILS

0

ORG-4366

Allow ANOVA 'Number of Levels' to be > 10

Number of Levels dropbox for Raw data mode of ANOVA tools is increased to 25In Origin 2020, Allow ANOVA 'Number of Levels' to 25.

0

ORG-20758

Improve box plot in One-Way ANOVA

Box charts generated in ANOVA tools are plotted with grouped box chart
  1. For the box charts of One Way ANOVA and Statistic on columns, which has only one group column, Origin 2020 does not set subgroup.
  2. One Way ANOVA's box charts and Statistic on columns' box charts default templates follow Grouped Box Charts' setting in Plot Details dialog:
    1. Check Outliers checkbox and Box width=80 in Box tab.
    2. Uncheck 99% and 1%, Max, Min checkboxes in Percentile tab
    3. Border Color=Q13 and width=1.5, Fill Color: Auto in Pattern tab
    4. Caps Length=50 in Lines tab
  3. Rename Connect by Subgroup to Connect within Subgroup in Plot Details dialog Connect Lines tab for Grouped Box Charts

0

ORG-20506

Kernel Density Calculation: New (fast) algorithm

Faster  2D Kernel  Density plotting for large datasets

For large datasets to plot 2D Kernel  Density, earlier Origin versions take several hours or more. 

Origin 2020 introduces new Density Method: Binned Approximate Estimation and adds an new option: Interpolate Density Points to improve speed greatly, which takes only several seconds.

A New Labtalk function is supported as below:

ks2d(vx,vy[, int bandwidth=0, int grid=151, int interp=1, int density=1])

0

ORG-20883

Set Cluster Membership column as Categorical and Ascending type

K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column keeps  the order of the original data and is set as Categorical and Ascending type.

In Origin 2019b, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column was already sorted and without link to the order of the original data.

In Origin 2020, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column keeps  the order of the original data and is set as Categorical and Ascending type.

0

ORG-20734

Speed improvements on Means Comparison in ANOVA tool

Improved the calculating speed of Means Comparison, and it will be 30% faster than Origin 2019b.

Improved the calculating speed of Means Comparison, and it will be 30% faster than Origin 2019b.

Besides, if choose not output the Means Comparison result, previous version will still do the calculation in background and waste time. Now this is fixed in Origin 2020, and will be 83 times faster than Origin 2019b.

...

ID

JIRA

SUMMARY

Description

DETAILS

0

ORG-19827

Multi-threaded ASCII import

Add two system variables  for Multi-threaded ASCII import. The following system variables are added:
@IAMT=<auto> /// number of additional threads to use when import, will be auto detected by logical processors. Set to 0 to disable multi-threading.
@IAS=10 /// least file size (in Megabytes) to enable multi-threading.

Database Import

ID

JIRA

SUMMARY

Description

DETAILS

0

ORG-18853

Enhanced Database Import

Database Import images stored inside the database as pictures in worksheet cells.

  • Directly import images stored inside the database as pictures in worksheet cells
  • Protect imported data from editing, to ensure data integrity, 
  • @IPDB(Database Import) and @IPDC(Data Connector) to control the protection mode for imported range.
    • 0 - no protection
    • 1 - protected, except reorder
    • 2 - protected
  • @DBSV to control whether to show Views in table list on SQL Editor dialog or not. Default is 0 to not show.
  • Support Exclude Imported Data when saving as OPJU/OGWU for Database Import.
  • Improved Ease of Use and performance

In previous versions, import database by ODBC is slower than ADO, and cannot import large dataset. Now this has been improved in Origin 2020.

Setting @ODBCA = 0 (Default), then you should be able to import large dataset now.

Also, the performance of ODBC should be faster than ADO method now.

Also, when importing using Microsoft OLE DB Provider for ODBC for database connection, Origin will use ODBC by default now. It used to use ADO by default even for ODBC.

0

ORG-20796

Option to encrypt or leave database credentials in clear text

In SQL Editor dialog, supply option to encrypt or leave database credentials in clear text

When SQL Editor dialog launches, the user is prompted to encrypt their credentials. If the user choose not to, the password is displayed in clear text in the Edit Connection String... dialog. However, it still appears as *** other places in Origin. If credentials are encrypted the password appears as *** everywhere.

Note: This is has late breaking issues which will be addressed.

0

ORG-20107

Origin Connector to allow basic SQL selection and Improve Origin Internal Query SQL Support

Following object notations are supported in internal query SQL. New worksheet command to output SQL query result to workbook.
  1. Following object notations are supported in internal query SQL
    • _Type, _SName, _LName, _DatasetType, _Comments, _Visible, Column_Y, Column_Z, Column_P1, Column_D1, Column_[Name], , Sheet_SName, Book_SName, Book_LName
  2. New worksheet command to output SQL query result to workbook.
    • worksheet -qn: Output to new book
    • worksheet -qa: Output to active book, this will first delete all existing columns
    • Example:
      • worksheet -qn Select Column From Project Where Book_LName like "*simple*" and Column_LName like "YCO*";
      • worksheet -qn Select Column from Project where (_Type = "X" and _Visible = True);
  3. A Query button is added in Origin Connector. Open it to enter query.

...

ID

JIRA

SUMMARY

Description

DETAILS

0

ORG-20095

CSV Connector Improvements

CSV Connector supports Import first 50 lines as previewPartial Import and Data Block Marker options.

E.g. sometimes data block starts or end with some keywords, e.g. [Data] or >>>>Start<<<<<<, etc. User can specify the start and end  data block marker. In the past, user needed to specify number of rows before data. 

0

ORG-20589

CSV connector needs to support ISO time with GMT

CSV Connector supports auto detect ISO time with GMT.CSV Connector supports auto detect ISO time with GMT(for exmple: 2014-08-04T14:32:27.000+02:00) and set Column Format as yyyy'-'MM'-'dd HH':'mm':'ss'.'###.

0

ORG-20163

Specify Long name, Units and Comments in Excel Connector

Excel Connector supports to specify Long name, Units and Comments.

0

APPS-772

Connect to tables and images in Word document.

Connect to tables and images in Word document

Connect to tables and images in Word document.This App connects the Origin project to a Word document in docx format.

0

APPS-416

Import NMR data in different formats.

Import NMR data in different formats

This App imports NMR data in different formats, including FID data and processed data.

0

APPS-765

Connect to a LeCroy trace data file.

Connect to a LeCroy trace data file

This App connects the Origin project to LeCoy waveforms (*.trc).

...

ID

JIRA

SUMMARY

DESCRIPTION

DETAILS

0

ORG-18764

Control Polygon or Polyline object thru LabTalk

Control Polygon or Polyline object through LabTalk
  • <objectName>.PointCount

Suppose user has a polygon of 4 points, then script "polygon.pointcount =;" will return 4.

Also, can set polygon.pointcount=5 to add more points, then use polygon.x5= and polygon.y5= to specify the 5th point coordinates.

  • Get and Set XY coordinates to/from worksheet columns
// objname.GetXY(xDataset, yDataset); // copy from obj to dataset
// objname.SetXY(xDataset, yDataset); // copy from dataset to obj
// Ex:
polyline.getXY(book1_a, book1_b);
polyline.setXY(book2_a, book2_b);
polyline.getXY(book1_a); // copy only X values
polyline.getXY(, book1_b); // copy only Y values
  • Also when adding polygon, polyline, ESC will finish it.


0

ORG-19996

Faster Date and Time LabTalk functions

Faster Date and Time LabTalk functions

Origin Labtalk functions belong to Date and Time category are moved to VC level to have faster speed.

E.g.

Column A is filled with 1million rows of date data

Set Column B formula as WeekDayName(A)

In Origin 2019b and earlier build, it took about 95 sec, while in Origin 2020, it only takes about 1 sec.


Note: In Set Column Values dialog, you can click Function: Date and Time menu to see all date and time functions Origin supports. 

0

ORG-20395

LabTalk option to generate gadget output for all curves, all layers, etc.

LabTalk option to generate gadget output for all curves, all layers, etc.
We had the following to generate new output of a gadget.
Gadget gd = Rect; gd.Output();

But since we have New Output for All Curves, New Output for All Layers, etc., we should have more options of what to output.
So now user can use
gd.Output(2) //new output for all curves

0 -- normal
1 -- last
2 -- all curves
3 -- all layers
4 -- entire curve //this is Quick Peaks gadget only

0

ORG-20688

LT command to reduce file size

LT command to reduce file size

Labtalk command file -cp is very useful to reduce a huge data file, E.g. a 14G CSV file, you cannot open it anywhere. You can reduce it to a manageable size first. The code is like this

dlgfile g:=*.csv;
file -cp 3Mb fname$;

to reduce it to 3Mb.

0

ORG-20040

Origin C OC and LT Access to Data Connector

Origin C and LabTalk Access to Data Connector

1. OC call LT Sub method in Page level, for example:

void test()
{
WorksheetPage wp = Project.Pages();
int nErr = wp.DoMethod("DC.Add", "CSV");
}

2. Support "wbook.DC.type$" to get the DC type.

3. Simpler syntax for web connector in LT, for example:

newbook;
wbook.dc.add("JSON"); wks.dc.source$="https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=2018-01-01&endtime=2018-01-23"; wks.DC.Sel$="JSON/features"; wks.dc.import();


0

ORG-20197

Support numeric access to label cell

Support numeric access to label cell

When label cell is a numeric value, you can access it as numeric value instead of string now. 

E.g, 

col(A)[D1] =;

This can be disable by setting @LRNA = 0.

0

ORG-19390

Support simple LT expression in Add Straight Line and other XFs

Support simple LabTalk expression in Add Straight Line and other X-Functions
  • Support LT Expression for Value, e.g. enter -log(0.05)
  • Support Page info variables and values from columns as input to XF, e.g. page.info.user.variables.noofpoints

...

ID

JIRA

SUMMARY

DESCRIPTION

DETAILS

0

ORG-20631

Add OriginC for note window

Add OriginC for note window
void test(string str = "Hello World.html")
{
	string strFile=GetOriginPath(ORIGIN_PATH_SYSTEM) + "\\Samples\HTML\\" + str;
	string strExport = "c:\\test\\test.html";
	int n;
	Note note;
	note.Create();
	n = note.DoMethod("Load", strFile);
	n = note.DoMethod("EXPORTHTML", strExport);
	n = note.SetProp("View",0);
	n = note.SetProp("Syntax",0);
	n = note.DoMethod("DUPLICATE");
	n = note.DoMethod("Close");
}

0

ORG-20431

Convert floating-point from other formats to IEEE 754

Convert floating-point from other formats to IEEE 754

Added following OC funtion to convert floating-point from other formats to IEEE 754.

typedef enum
{
	FLOATING_POINT_TYPE_IEEE_FLOAT = 0,   // 32-bit
	FLOATING_POINT_TYPE_IEEE_DOUBLE,      // 64-bit

	FLOATING_POINT_TYPE_VAX_F,            // 32-bit, ~[-2.9E-39, 1.7E+38]
	FLOATING_POINT_TYPE_VAX_D,            // 64-bit, ~[-2.9E-39, 1.7E+38]
	FLOATING_POINT_TYPE_VAX_G,            // 64-bit, ~[-5.6E-309, 0.9E+308]

	FLOATING_POINT_TYPE_IBM_SHORT,        // 32-bit
	FLOATING_POINT_TYPE_IBM_LONG,         // 64-bit
	FLOATING_POINT_TYPE_IBM_LONG_XPORT,   // 64-bit
FLOATING_POINT_TYPE_COUNT } FLOATING_POINT_TYPE;

bool convert_floating_by_format(LPVOID lpOutputBuff, LPVOID lpInputBuff, size_t nNumValues, FLOATING_POINT_TYPE nOutputFormatType, FLOATING_POINT_TYPE nInputFormatType);

For example:
void vax_test() { unsigned int a[] = {0x268bc2d9, 0x015dc2d9}; double f[2]; convert_floating_by_format(f, a, 2, FLOATING_POINT_TYPE_IEEE_DOUBLE, FLOATING_POINT_TYPE_VAX_F); // f = { -27.14381980895996, -27.12566566467285 } return; }

0

ORG-19439

NAG Mark 26.1

NAG Mark 26.1

NAG library is upgraded to Mark 26.1 version

0

ORG-20204

Support copy and paste link for GetN numeric or string input

Support copy and paste link for GetN numeric or string inputUser can copy a label cell or a data cell, and paste link to edit box in XF dialog.

...

ID

JIRA

SUMMARY

DESCRIPTION

DETAILS

0

ORG-18480

Preshipped Python 3.7.2

Pre-shipped Python 3.7.2Preshipped Python version upgraded to 3.7.2

0

ORG-20077

Support Python Input() Method

Support Python Input() Method

Python 3.x: var1 = input ("Enter a number:")

Python 2.7: var1 = raw_input ("Enter a number:")

This will prompt a GetN box.

...