Origin 2019 Features
Analysis
Batch Processing
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | Block Recalculation | Block Recalculation |
Fitting
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | Example:
Active a plot with error bar then run the following labtalk script:
nlbegin func:=gauss; nlfit;
nlend 1; | |
0 | 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 | 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: | |
0 | 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.
| |
0 | 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.
| |
0 | 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.
| |
0 | 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
| |
0 | 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. |
General
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | Dialog Theme context menu Improvements for Import tools | Dialog Theme context menu Improvements for Import tools | ||
0 | 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 | 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.
| |
0 | Use new Window View for preview on more analysis tools | Use new Window View for preview on more analysis tools | Below analysis tool support:
Matrix/Surface Fit |
Mathematics
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | Add Excel Bicubic interpolation | Add Excel Bicubic interpolation |
|
Peak Analysis
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | Support threshold as a certain value in peak finding | Support threshold as a certain value in peak finding | Support Peak Filtering method in PA
|
Signal Processing
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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.
| |
0 | 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:
|
Statistics
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | 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). |
Data Handling
Database Import
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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. |
Import Data
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | 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 | 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
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. |
Importing Third Party Formats
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | 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. |
Workbook and Worksheet
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | 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 | 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 | 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 | 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 | Custom numeric format more works | Custom numeric format more works |
| |
0 | 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 | 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. 1. Paste Transpose, Paste Link, Paste Link Transpose will not paste mask status. 2. Copy (full precision) will not copy the mask status. | |
0 | 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 | Numeric allow percent (%) and engineering notation | Numeric allow percent (%) and engineering notation |
| |
0 | Press and scroll mouse wheel to view data | Press and scroll mouse wheel to view data | ||
0 | Support Hex numbers | Support Hex numbers |
HexDisplay.opju demonstrates the power of using Custom Display Format of Numeric, as well as the various improvements | |
0 | Treat missing as blank Improvements | Treat missing as blank Improvements |
| |
0 | User Parameter Row Formula | User Parameter Row Formula |
Worksheet Data Manipulation
ID | JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | 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 | Worksheet Conditional Formatting: Heatmap | Worksheet Conditional Formatting: Heatmap | ||
0 | 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. |
Graphing
Axes
ID | JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|---|
0 | 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 | Object Manager: Move Plot to Other Y Axis | Object Manager: Move Plot to Other Y Axis | ||
0 | Show Major tick at min and max of axis | Show Major tick at min and max of axis |
Box Chart
ID | JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | 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. |
Contour
ID | JIRA | SUMMARY | Description | DETAILS |
---|---|---|---|---|
0 | 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 | 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 | Support Custom Display Formats for Contour Labels | Support Custom Display Formats for Contour Labels |