Origin 2019 Features

0

ORG-12759

Better Batch Processing with Multiple files in Analysis Template

Better Batch Processing with Multiple files in Analysis Template

If user has multiple data files imported into multiple sheets but also have other reference sheet, etc., Origin 2019 can better detect import data worksheet and only import to them when doing batch processing. 

E.g. user import 3 files into 1st 3 sheets. 4th sheet is a reference sheet, some analysis is done and analysis template is saved.

When using such workbook as analysis template for batch processing 6 files, first 3 will be processed together; second 3 files will be processed together. 

0

ORG-18539

Block Recalculation

Block Recalculation

0

ORG-18656

LabTalk command nlbegin supports to pick up error bar when fitting from graph

LabTalk command nlbegin supports to pick up error bar when fitting from graph

0

ORG-16862

Output Adj. R-square and Pearson's r of a scatter matrix plot to a result sheet

Output Adj. R-square and Pearson's r of a scatter matrix plot to a result sheet

When Pearson's r or Adj. R-square is checked in Plot Scatter Matrix dialog, a new result sheet named ScatterMatrixStats will be created with all Adj. R-square values and Pearson's r values in it.

0

ORG-18756

Support to define both 32bit and 64bit External DLLs in a fdf file

Support to define both 32bit and 64bit External DLLs in a FDF file

Different dll files will be loaded by the same function if it's name follows the below rules:
32bit: DLLname.dll
64bit: DLLname_64.dll

0

APPS-275

Peak Deconvolution

Offer an intuitive and interactive interface to perform peak analysis.

Download Peak Deconvolution app from the page and install the app.

This app is capable of performing peak analysis intuitively and interactively. It is able to define baseline, then detect the peaks, and fit peaks.

Open

0

APPS-450

Global Fit with Multiple Functions

Perform global fit and share parameters for different functions.

Download Global Fit with Multiple Functions app from the page and install the app.

This app is capable of performing global fit with multiple functions, and parameters can be shared across different functions.

Open

0

APPS-180

Image Object Counter

Object identification and measurement on image.

Download Image Object Counter app from the page and install the app.

This app is capable of identifying the objects on image, together of measuring their characterics.

Click the app icon to start this app by opening a dialog. Then load an image as source image (If the active window is image window, this active image is used as the source image for analysis.), and then insert operations by using the menu. You can also save or load the operations to or from a file. And after getting the target objects on image, you can output the measurement results of these objects.

Open

0

APPS-268

Design of Experiments

Design an experiment, fit a model to experimental data, and find best factor settings that optimize responses.

Download Design of Experiments app from the page and install the app.

This DOE app helps you determine the relationship between factors affecting a process and the output of that process.

You can use it to design an experiment, analyze experimental data and optimize output.

Features

• Various types of designed experiments to help you create a design.

• Customization of design table by replication, randomization, blocking, etc.

• Fit of mathematical model to data from test runs.

• Diagnostic statistics and graphs to help you interpret the results.

• Optimization of response after defining factor constraints.

Open

0

APPS-453

Fitting Function Libray

Search, find and add fitting functions to Origin.

Download Fitting Function Libray app from the page and install the app.

The purpose of this app is to allow Origin user search, find and add new fitting functions to Origin. Simply select the function and click a button to download the FDF file and add the function to Origin, then find and use it when perform fitting.

This app will update the function list automatically if Origin provides some new functions even after installation.

Open

0

ORG-8760

Dialog Theme context menu Improvements for Import tools

Dialog Theme context menu Improvements for Import tools

0

ORG-18710

Hide Recalculation Locks on the graph

Hide Recalculation Locks on the graph

For analysis done on each plot, a lock is created under layer icon. If there are many locks, it's hard for user to view the graph.

Choose View: Show: Lock menu to uncheck it to hide locks in graph window.

Labtalk page property page.lock=0 to hide it.

0

ORG-18864

Set default node's shrink/expanding status on hierarchical result sheet for each analysis

Set default node's shrink/expanding status on hierarchical result sheet for each analysis

User can right click any node on result sheet and choose Save Node Configuration to save default node status of the analysis. Next time when you do such analysis, it will used the saved configuration. 

• Useful feature for you if you want to print/export consistent reports from analysis

• Each analysis tool can have its own default node configuration.

0

ORG-18118

Use new Window View for preview on more analysis tools

Use new Window View for preview on more analysis tools

Below analysis tool support:

1.  XYZ (Log) Gridding

2.  IIR Filter

 Matrix/Surface Fit

Open

0

ORG-18857

Add Excel Bicubic interpolation

Add Excel Bicubic interpolation

1. Rename the current Bicubic method in 2D Interpolate/Extrapolate tool to be "Bicubic Convolution".

2. Add option "Bicubic Lagrange" (enum as "lagrange") as the last one in Method combo.

0

ORG-18333

Support threshold as a certain value in peak finding

Support threshold as a certain value in peak finding

Support Peak Filtering method in PA

0

APPS-179

Align Peaks

Shift, scale and trim data to align various peaks.

Download Align Peaks app from the page and install the app.

This app can be used to align peaks of spectra by shifting, scaling, clipping and inserting data.

Open

0

APPS-499

Independent Component Analysis

Separate mixed signals into sub-components.

Download Independent Component Analysis app from the page and install the app.

This app can be used to decompose observed mixed signals into sub-components which are assumed to be independent from each other. Input data can be either columns or matrices.

Three methods are supported:

• FastICA

• Information-Maximization (Infomax)

• Joint Approximate Diagonalization of Eigenmatrices (JADE)

0

ORG-15972

Set column as categorical for analysis tools related to grouping

Set column as categorical for analysis tools related to grouping

If a column is mostly text and the column is used as grouping column for analysis tools, Origin will automatically set it as categorical so you can easily adjust result sheet orders.

0

APPS-211

Stats Advisor

Help you pick the most appropriate statistical tool that is best suited for your data, including the tests, the graphs, and the Apps.

Download Stats Advisor app from the page and install the app.

If you are all new to Origin or are unfamiliar with the statistical procedures, this app could help you get started.

Open the Stats Advisor App, you could see three column, including What do you want to do, Your options and Suggested feature(s).

Open

0

ORG-18853

Data Connector for SQL

Added a system variable @sqli= to determine whether the menu and the tooltip on the DB icon in the top left of a worksheet are enabled. By default it is 0.

Added a system variable @sqli= to determine whether the menu and the tooltip on the DB icon in the top left of a worksheet are enabled. By default it is 0.

0

ORG-18790

Add system variable so that import with "Replace Existing Data" will really replace existing data

Add system variable so that import with "Replace Existing Data" will really replace existing data

Added a system variable @IRE for import Excel file with "Replace Existing Data" Import Mode.

@IRE = 1(default): Replace the existing sheets in the active Workbook from the active sheet on.

@IRE = 0: Only replace the active sheet, and create new sheets to import following Excel sheets.

0

ORG-15666

Check new LibXL update

Updated the new LibXL version 3.7.1 to Origin, so that Origin 2019 will support importing more higher version Excel files.

Updated the new LibXL version 3.7.1 to Origin, so that Origin 2019 will support importing more higher version Excel files.

0

ORG-18352

Import Wizard Support relative OC File Path for user defined type

Import Wizard Support relative OC File Path "<App Folder>" for user defined type.

Import Wizard Support relative OC File Path "<App Folder>" for user defined type.

0

ORG-2266

Support Date Time Data with higher precision

Support Date Time Data with higher precision

Add three system variables:

1. @DSP: a project property, the date system in current project

• 0: the current date system, +12 hours off from julian day system

• 1: julian day
  
  

• 2018: 2018 date system, 0 at 00:00 on Jan 1 2018

2. @DSO: the actual offset for the current date system, in day

And also, when the date system is 2018, Import Wizard support more higher precise date data, for example: When import time data like "2/5/2040 15:59:59.994983" using Import Wizard, can set Custom Date Format as "MM'/'dd'/'yyyy HH':'mm':'ss'.'######" to import.

0

ORG-18949

FAMOS import gets error about header not readable

Support importing newer FAMOS files that have the keys "NL" and "NV".

Support importing newer FAMOS files that have the keys "NL" and "NV".

0

ORG-18722

Improve TDMS Import to make it work with Batch Processing

Improve Batch Processing to support TDMS files.

Improve Batch Processing to support TDMS files.

0

ORG-18157

Support import HEKA newest instrument model version 1000

Support importing newer HEKA file, up to version 2x90.3.

Support importing newer HEKA file, up to version 2x90.3.

0

ORG-19012

Add "1 000.0" as numeric separators in Tools: Options dialog.

In Tools: Options dialog, a newly entry "1 000.0" is added for Numeric Separators.

In Tools: Options dialog, a newly entry "1 000.0" is added for Numeric Separators.

0

ORG-18773

Auto fill column label row contents to the right

Auto fill column label row contents to the right

Double clicking the bottom-right corner of the cell with formula in Column label rows. The formula will be autofilled to all cells to the right.

0

ORG-18099

Column List View

Choose View: Column List View menu to view a list of columns with associated metadata and sparklines. Data cells are not displayed. You can select column(s) in this list view and perform the usual graphing and analysis operations.

Choose View: Column List View menu to view a list of columns with associated metadata and sparklines. Data cells are not displayed. You can select column(s) in this list view and perform the usual graphing and analysis operations.

0

ORG-18382

Copy and Paste Filter condition support

User can select the Copy Filter from filter's context menu or select a filter condition in Filter cell and Ctrl+C to copy a filter, and then paste it to other column(s).

User can select the Copy Filter from filter's context menu or select a filter condition in Filter cell and Ctrl+C to copy a filter, and then paste it to other column(s).

0

ORG-18166

Copy non-continuous rows

Support to copy non-continuous rows

Before Origin 2019, when selecting non-continuous rows and copying and pasting, the unselected rows in between were copied/pasted as well.

0

ORG-18990

Create Subset Sheet context menu to extract selected rows to a new sheet.

Create Subset Sheet context menu to extract selected rows to a new sheet.

After manually select multiple rows or select multiple rows based on data highlighting feature, right click the selected rows and choose Create Subset Sheet context menu

Corresponding X-Function: wcopy.

0

ORG-18759

Custom numeric format more works

Custom numeric format more works

1. Improvement for Latitude Longitude display format.
   General syntax is now like this:

   D[Space][M[S]][F/D][n] [EW/NS[B]]

   
   New:
   F/D: F to indicate not to include symbols and space is always inserted. D to indicate only exclude last symbol.
   EW/NS: EW for longitude, NS for latitude
   B: before the numbers. if not specified, will be after.
   
   Example: For decimal degree of latitude -3.03423

   DMD3 NS -> 3° 02.053 S
   DMS1 NSB -> S 3°02'03.2"

2. Support direct editing in custom numeric format using Hex.

0

ORG-19184

Improve Mask cells by condition to support noncontinuous columns and row ranges

Improve Mask cells by condition to support noncontinuous columns and row ranges

Highlight noncontinuous columns or row ranges, select menu Column: Mask Cells by Condition to open colmask dialog, masks cells by your condition.

0

ORG-18938

Masked status kept when copying and pasting data.

Masked status kept when copying and pasting data.

After pasting data into new sheet, masked data will be still masked. In the past, masked status was not kept.

A new system variable @CPM has been added to control the behavior, default value is 1.
Note:

1. Paste Transpose, Paste Link, Paste Link Transpose will not paste mask status.

2. Copy (full precision) will not copy the mask status.

0

ORG-14386

New XFunctions to join columns by plot designation

A new X-Function coljoinbydesig is added to concatenates columns by plot designation. Right now, it's only available by script access.

A new X-Function coljoinbydesig is added to concatenates columns by plot designation. Right now, it's only available by script access.

0

ORG-18380

Numeric allow percent (%) and engineering notation

Numeric allow percent (%) and engineering notation

• Type 12% will convert it into 0.12 automatically. You can disable it by system variable: @cap=0

• Convert Percent (%) to Number when Copying or Importing ASCII or Excel Data with %

• Type "1k" in a cell, then convert column to Numeric format will change it to 1000 automatically.

0

ORG-18525

Press and scroll mouse wheel to view data

Press and scroll mouse wheel to view data

0

ORG-18351

Support Hex numbers

Support Hex numbers

• Custom numeric display such that hex numbers can be used in worksheet cells/columns natively, without using Hex2Dec kind of conversion like in Excel. In Column Properties, set Display as Custom and then set Custom Display as %X or %0<#hexdigits>I64X e.g., %012I64X means 12 hexdigits. X can be in lower case.

HexDisplay.opju  demonstrates the power of using Custom Display Format of Numeric, as well as the various improvements

0

ORG-14837

Treat missing as blank Improvements

Treat missing as blank Improvements

• Missing values will show as blank in worksheet.

• When importing excel file with empty cells, or copy and paste data with empty cells from Excel, 

• Before Origin 2019, when copying some data with blank rows above it and pasting it to new column, blank rows were removed. In Origin 2019, they are kept.

• If there are empty cells above the data, below data or within data range, click on it, status bar shows <i1:, >i2:, or nothing correspondingly. These empty cells will not be included in calcuation, statistics. 

• When selecting a cell outside the data bound, status bar will show "<i1: "(begin) or ">i2: "(end).

• Worksheet cell background color show differently if outside i1 i2 by default. There is a checkbox Indicate unused cells with a shaded background in Workbook Properties dialog. System variable @COR determines the darkening intensity.

• i1 starts from 1st row unless set otherwise.

• Delete data on last row will shrink data size (i2 updates)

• Ctrl+delete to add missing value to a cell, in cases that user wants to make sure each column has same length. 

0

ORG-18478

User Parameter Row Formula

User Parameter Row Formula

0

ORG-18358

Conditional Format Manager

Choose Worksheet: Conditional Formatting to manage and edit ranges with conditional format.

Choose Worksheet: Conditional Formatting to manage and edit ranges with conditional format.

0

ORG-16420

Split worksheet improvements

In Split Worksheet tool, add a new option "Retain 1st N Columns" for "By Number of Columns"/"By Column Label" split mode to keep the 1st N columns in the splitting worksheet result.

In Split Worksheet tool, add a new option "Retain 1st N Columns" for "By Number of Columns"/"By Column Label" split mode to keep the 1st N columns in the splitting worksheet result.

0

ORG-18290

Worksheet Conditional Formatting: Duplicates

Select a range of cells or column(s) and color cells with duplicate values.

Select a range of cells or column(s) and color cells with duplicate values.

0

ORG-18211

Worksheet Conditional Formatting: Heatmap

Worksheet Conditional Formatting: Heatmap

0

ORG-18289

Worksheet Conditional Formatting: Highlight

Select a range of cells or column(s) and color cells that match rules.

Select a range of cells or column(s) and color cells that match rules.

0

ORG-18350

Axis dialog to support Custom Numeric format

Axis dialog to support Custom Numeric format

Easier way to enter From and To, special ticks, reference lines and break, etc. in axis dialog. Allow user to type 0 and 2 which will refer to 0 and 2 pi. The same issue exists when set Major Tick type as By Custom Positions; Special Ticks, Break, and Reference Lines tab.

0

ORG-18663

Object Manager: Move Plot to Other Y Axis

Object Manager: Move Plot to Other Y Axis

0

ORG-18772

Show Major tick at min and max of axis

Show Major tick at min and max of axis

0

ORG-16102

Customize outliers in box chart

Customize outliers in box chart

In Plot Details dialog, if Outlier is checked on Box tab, then Outlier tab appears for outlier customization.

0

ORG-13417

Display the median value in box chart

Display the median value in box chart

Add a Median check box to show Median value Label

0

ORG-17983

Enable vertical auto position for box chart label

Enable vertical auto position for box chart label

Add Auto Reposition to Avoid Overlap checkbox in Label tab.

0

ORG-18676

Contour label consider custom boundary

Contour label will consider the custom boundary

When custom boundary is on, Contour label will consider boundary now. Use @TCBL=0 to disable the feature

0

ORG-18314

Image Plot should have missing value support similar to contour

Image Plot should have missing value support similar to contour

Add Missing value control for Image plot.

0

ORG-18823

Support Custom Display Formats for Contour Labels

Support Custom Display Formats for Contour Labels