Origin 2018b Features

0

ORG-17657

Allow importing data directly into embedded matrix in worksheet when performing batch processing

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

If the embedded matrix exits in the analysis template, batch processing support importing data or image to the embeded matrix. Besides,  drag and drop to import data or image to opened analysis template is also supported.

0

ORG-17656

Batch Plot dialog now combines options for Book, Sheet and Column into one dialog

Batch Plot dialog now combines options for Book, Sheet and Column into one dialog

Batch Plotting GUI Improvements

• Combine Batch Plot with Book, Sheet and Column into one dialog. There is Batch Plot with dropdown list on the top of the dialog.

• Matching conditions to filter book/sheet are moved on top of the book/sheet list.

• Batch plotting menus and toolbar buttons also combine into single button and menu.

Open

0

ORG-16656

New App to distribute multiple files across multiple cores for faster Batch Processing

New App to distribute multiple files across multiple cores for faster Batch Processing

Select the Analyis Template and data files. Then specify how many cores to be used. The files will be distributed to multiple instances of Origin running on each core. App can be used to monitor progress. Once all tasks are finished, a consolidated summary report can be created with results from each core combined into one table.

0

ORG-17383

Save Batch Processing dialog settings into Analysis Template

Save Batch Processing dialog settings into Analysis Template

When using an Analysis template in Batch Process dialog, the batch processing dialog settings will be saved into the analysis template so that the next time this analysis template is loaded in Batch Process dialog, no need to set batch processing setting again. 

A system variable @bst is used to control the behavior.

0 : always no save settings;
1 (default): always save settings;
-1: pop up msg to ask.

0

ORG-17526

Some rule changes to batch processing

Some rule changes to batch processing for no dialogue and no interaction,

We tend to have no dialogue, no interaction, in batch process. So the rule of batch process now becomes to:

1. Before doing any batch process, user must make sure the input files format should be match with the last import settings in .ogw or filter in UFF.

2. Last import setting must be used when check on "Use Import Setting in Workbook". filter file will be used when uncheck "Use Import Setting in Workbook".

3. when filter is used, the proper filter should match: a. input file extension must be match with filters setting. b. filter file format must be match with last import settings in ogw.

Once user make analysis template with import ASCII, that means the template is only used for ASCII file. If user want to it for other type file, they must import another file from MENU and save analysis template again.

0

ORG-15328

Support to add data from many sheets/books into a combined graph or an existing graph

Add data from many sheets/books into a combined graph or an existing graph

• Add data from many different sheets/books into an existing graph

  • E.g. After plotting a multiple panel graph with data in one worksheet/book, user wants to add data from other sheet/book to same graph. 

• Add data from many sheets/books into a combined graph.

  • After plotting a complicated graph with data in one book with several sheets, user wants to create a similar new graph with all data in another book with different number of sheets

0

APPS-373

Distributed Batch Processing

Batch processing with multiple Origin instances.

Download Distributed Batch Processing app from the page and install the app.

This app is capable of batch processing with analysis template using multiple Origin instances in background.

Click the app icon to bring up the dialog, then provide the desired settings, and then click the Run button to start the batch processing. Note: there is a sample project together with this app. You can open the sample folder by right clicking on the icon of this app, and then choose Show Samples Folder from the context menu. In this folder, you can use the provided template and follow the note to get how to use this app.

Open

0

APPS-419

Toolbar Maker

Help to create simple and personal toolbar buttons that run script.

Download Toolbar Maker app from the page and install the app.

Simply select an image for buttons, enter the tooltip, enter or copy-paste an existing LabTalk script, and click a button to generate a user-defined toolbar named Toolbar Maker.

Open

0

ORG-17614

Fitting: Accuracy of p-value has been improved in nonlinear fit results.

Fitting: Accuracy of p-value improved in nonlinear fit results

Calculate the P value more accurately for tcdf and fdcf significance levels in Nonlinear Fitting Tools.

Change code to calculate P value for tcdf and fcdf in fitting tools for significance

0

ORG-17385

Fitting: Standard error on derived parameters is now included in the parameter Summary table

Fitting: Standard error on derived parameters included in the parameter Summary table

Output the SE of derived parameter and in the Summary table.

0

ORG-16540

Fitting: Implicit Function now support Integral

Fitting: Implicit Function supports Integral

Support to define Implicit Function with integral in the Fitting Function Organizer and Fitting Function Builder

0

ORG-17236

Fitting: Sample Curve and Equation Preview images are included when transferring FDF files from older version.

Fitting: Sample Curve and Equation Preview images included when transferring FDF files from older version.

Transfer User Files tool can now transfer also (if present) the picture files for the formula (.wmf) and the picture files for the sample curves (*.cuv) with fitting function file (*.fdf).

0

ORG-16680

Fitting: Two new implicit fitting functions added for diode and solar cell data

Fitting: Two new implicit fitting functions added for diode and solar cell data

The SolarCellIV and ModDiode fitting functions are added in the Implicit Category.

0

ORG-16252

Support auto install of fitting function and origin template when installing opx

Support auto install of fitting function and origin template when installing opx

1. Fitting function file(*.FDF) and origin template(*.otpu,*.otwu,*.otmu,etc) will be also installed after installing opx

2. Install Support Files is removed from package manager dialog.

0

APPS-333

Rank Models

Fit and rank multiple functions to identify best fitting model.

Download Rank Models app from the page and install the app.

This app can fit and rank multiple functions ito identify the best fitting model for your data. The app works for XY and  XYZ data.

Open

0

ORG-16868

Support Plot Range for Dataset Identifier for Gadgets

Support Plot Range for Dataset Identifier for Gadgets

Added option "Plot Range" in the Dataset Identifier drop down list in all gadgets which have the combo.

0

ORG-17267

Better hint indication when run Pro-only features in Regular version

Better hint indication when run Pro-only features in Regular version

1. In Regular Origin, if the project contains pro-only operation, the analysis clock will show in gray color.

1. In Regular Origin, if the project contains pro-only operation and users click the recalculate toolbar button, there is a warning message shown in Message Log window.

0

ORG-14736

Peak Analysis:  New method for peak detection: Fourier Self Deconvolution

Peak Analysis:  New method for peak detection: Fourier Self Deconvolution

0

ORG-17380

Signal Processing: Unit description added to metadata of STFT result

Signal Processing: Unit description added to metadata of STFT result

Support unit output in worksheet result of STFT.

0

APPS-404

3D Smoother

Smooth 3D data.

Download 3D Smoother app from the page and install the app.

This app can be used to smooth 3D data from XYZ columns or a matrix. 

Features include:

• Support XYZ or matrix data

• Multiple smoothing methods like Adjacent-Averaging, Adjacent-Median, Negative Exponential etc.

• Support Grid Settings for smoothed data

Open

0

ORG-10828

Statistics: Frequency Count/Binning tool supports output format such as: 0-10, 10-20, etc.

Statistics: Frequency Count/Binning tool supports output format such as: 0-10, 10-20, etc.

2D Frequency Count/Binning output sheet creates 4  type columns ahead with following LongName: Bins of A, Bin Beginnings of A, Bin Centers of A, Bin Ends of A and create 3 label row : Bin Beginnings of B, Bin Centers of B, Bin Ends of B.

Frequency Counts output sheet creates 4  type columns ahead with following LongName: Bins, Bin Begin, Bin Centers , Bin Ends.

0

ORG-16974

Statistics: Hidden column will be ignored when computing statistics on rows

Statistics: Hidden column will be ignored when computing statistics on rows

Hidden column should be ignored if do statistics on rows and other statistics tools

0

ORG-12869

Statistics: PCA Loading plot and Biplot support improved plot labeling

Statistics: PCA Loading plot and Biplot support improved plot labeling

Principal Component Analysis: Loading plot and BiPlot use the latest design: plot label tab in Plot  details dialog, and update Axis Labels "Principal Component 1" to be "PC1", add the value of "Percentage of Variance" to the Units label 

0

ORG-16287

Statistics: Stats on columns and rows will carry over Units from the source datasets

Statistics: Stats on columns and rows will carry over Units from the source datasets

Statistics on columns/Statistics on Rows, the result value will carry the same Unit as the source datasets.

0

ORG-17701

ASCII Import:

In ASCII Import, Origin's auto determine header line may not work well for all user's data.

Origin's auto determine header line may not work well for all user's data.

One example is user wants to import files by removing all lines that start with # character.

In sush case, uncheck Auto Determine Subheader lines and then choose By Leading Character option and specify a leading char under Header Lines node in ImpASCII dialog. This option is also available on Header page of Import Wizard.

0

ORG-17763

Improvements to labels in ASCII import dialog

Improvements to labels in ASCII import dialog

S1: Some label on ASCII dialog were changed:
1. Show blue hint "each character is treated as one delimiter" when the number of "Other Delimiters” is more than 1.
2. Multiple Delimiters --> Multiple Characters
3. Combine Delimiters as one Delimiter --> Treat Consecutive Delimiters as One (use a same label as ImpWiz)
4. Move "Header Lines" branch node above "File Structure" node, to be consistent with ImpWiz.

S2: Restrict editbox to allow single character input

On Import Wizard dialog, Data Columns page, the "Other" editbox is not allowed to enter more than 1 char.

0

ORG-17309

Cluster Gadget supports clearing category information

Cluster Gadget supports clearing category information

0

ORG-15752

Clone Import should trigger recalculation

Clone Import should trigger recalculation

Clone Import will trigger recalculation, even though the Recalculation is Manual.

0

ORG-17791

Import data with Start New Columns mode will not overwrite empty columns with merged column labels

Import data with Start New Columns mode will not overwrite empty columns with merged column labels

If user merges some column labels e.g. Comments and import mode is set as Start New Columns. Then Origin will treat the merged column as a unit and check if 1st column in the unit is blank or not. If blank, import into it. If not, start new column after the unit and import there. 

0

ORG-17791

Import data with Start New Columns mode will overwrite columns with missing values before creating additional columns

Import data with Start New Columns mode will overwrite columns with missing values before creating additional columns

Columns with missing values are still treated as columns with data. In the past, when user tried to import multiple data into same sheet with Multi-File Import mode set to Start New Columns, data will be imported into new columns after missing values columns. In 2018b, data will be imported into those missing value columns.

0

ORG-16460

Start New Sheet import mode should extend to allow more sheets

Start New Sheet import mode should extend to allow more sheets

Maximum number of sheets in one book is 1024, so when Start New Columns to import more than 1024 files, will automatically create new book for importing later files if number of sheets in current Workbook arrives 1024.

0

ORG-16604

CSV Import: Added option for starting new rows when importing multiple files

CSV Import: Added option for starting new rows when importing multiple files

0

ORG-17562

impcsv always import data from specific columns range since Origin2018

impcsv always import data from specific columns range since Origin2018

Added a system variable @IAR for  impCSV and impMSExcel import tools, when Highlight a column to import CSV or Excel file:

@IAR=1(default): Import data from CSV or Excel file from the first column.

@IAR=0: Import data from CSV or Excel file into the highlighted column.

0

ORG-17662

MDF Import: Significant improvement to speed of MDF Import

MDF Import: Significant improvement to speed of MDF Import

Tested with very large MDF file provided by user. It used to take more than 1 hour to import the data. In Origin 2018b, it takes only about 1 minute.

0

ORG-6175

More wav format wanted

impWav supports importing 24bit .wav file and multi-channel .wav file.

1. impWav supports importing 24bit .wav file.

2. impWav supports importing multi-channel .wav file.

0

ORG-17648

Partial Column Import in impBRUKER dialog

Partial Import node is added in BRUKER OPUS import dialog to import part of columns.

Partial Import node is added in BRUKER OPUS import dialog to import part of columns.

0

ORG-17036

Support the import Excel theme created from old version

Support the import Excel theme created from old version

Support using import Excel themes from old versions in Origin 2018b, before using the old theme, need to run some scripts to convert it.

run.loadoc("originlab\theme_convert.cpp", 16);//Run this script to load the convert theme function.

and then:

1. theme_file_convert_for("impExcel", "impMSExcel", "import_injekt_excel") //Convert single impExcel theme to impMSExcel theme.

2. theme_file_convert_for("impExcel", "impMSExcel") ortheme_file_convert_impexcel_to_impmsexcel() //Convert all impExcel themes to impMSExcel themes.

0

ORG-17606

Add Matrix as a Sheet in Workbook, Allows for Analysis Templates to include image or matrix data in a single book.

Add Matrix as a Sheet in Workbook, Allows for Analysis Templates to include image or matrix data in a single book.

To support an analysis template which contains both workbook and matrix, everything must be in one workbook.

So in Origin 2018b, we allow user to right click a workbook tab and choose Add Matrix as Sheet context menu. 

This actually adds the whole matrix book as a sheet in workbook. You can double click the matrix to open the matrix again.

0

ORG-13536

Cell-Embedded image supported when saving Matrix Book

Cell-Embedded image supported when saving Matrix Book

After insert an image file to a worksheet cell, double-click on it will pop up a matrix window, and convert the cell type from "LBmp" to an embedding matrix.

0

ORG-17786

Customer Report on OPJU issues

Customer‘s OPJU Crashing on load. 

Customer‘s OPJU Crashing on load. 

0

ORG-17263

Autosave is now available for Untitled.opj

Autosave is now available for Untitled.opj

In the past, you must have project saved once in Origin and then if it's dirty, every 12 minutes (by default), the project will be autosaved in case Origin crashes. But sometimes user started a new project and had never saved it. Then Origin didn't autosave it at all and if Origin crashed, there was no autosave. 

Note: If Origin is closed normally, no autosave will be kept since Origin always prompt user to save.

0

ORG-17786

Customer Report on OPJU issues

Customer‘s OPJU Crashing on load. 

Customer‘s OPJU Crashing on load. 

0

ORG-17647

Improve Project Backup Mechanism

Improve Project Backup Mechanism

• Each Origin project will have its own backup file.

• Set system variable @PBO=0 to go back to old behavior. Only one Backup.opj/opju under User Files folder for last saved project file.

• Access Project Backup Folder via Help: Open Folder: menu in Origin or from Windows Start menu.

• Change Backup folder location on System Paths tab of Tools: Options dialog.

0

ORG-17471

Option to default to old OPJ format for saving projects

Option to default to old OPJ format for saving projects

A new system variable:

0

ORG-16878

Optional better handling of worksheet with large number of sparklines that may slow down opening projects.

Optional better handling of worksheet with large number of sparklines that may slow down opening projects.

When a worksheet contains sparklines, prior to Origin 2018b, all sparklines had to be drawn on project loading even if they were not visible. This slowed down initial rendering of the worksheet significantly.

A new system variable in 2018b addresses this issue by specifying how Origin should save EMF images of the sparklines:

Note: This system variable is persistant- it will be remembered across Origin sessions. It should be set from the Script Window or Command Window and not in the System Variables dialog.

0

ORG-16878

Optional faster rendering of graphs when many are shown at once and/or overlapped

Optional faster rendering of graphs when many are shown at once and/or overlapped

When many graphs are shown and/or overlapped, complete rendering (painting) of all of them may take a considerable amount of time if the graphs contain a lot of data. Up until Origin 2018b, each graph had its own setting specifying that if 70% of the graph is covered it would not repaint. Now in Origin 2018b there is a system variable to change this behavior on a global basis.

Note: This system variable is persistent- it will be remembered across Origin sessions. It should be set from the Script Window or Command Window and not in the System Variables dialog.

0

ORG-17295

Save files to or open files from Google Drive

Save files to or open files from Google Drive

Location of TempSave folder has been moved into a subfolder in ProgramData folder to avoid conflicts with Google Drive. Also, Origin better handles cases where user's Documents folder is located on a network drive.

0

ORG-17477

Copy and paste entire worksheet across multiple Origin sessions.

Copy and paste entire worksheet across multiple Origin sessions.

Right-click on the sheet tab, two new context menu items are available.

• Copy Sheet

• Paste as New Sheet

Use Copy Sheet to copy current sheet with all information(including the header lines and structure) into the clipboard, and then use Paste as New Sheet to paste it as a new sheet from the clipboard into a new layer or new window.

LabTalk command is also provided,

clip -cs; /// copy active sheet

clip -ps; /// paste sheet to active book from clipboard, if possible

clip -psn; /// paste sheet to new book from clipboard, if possible

0

ORG-17790

Export ASCII to support ignore empty columns

Add a checkbox named as "Ignore Ending Empty Columns", to control ascii export, to ignore empty columns from the end.

Add a checkbox named as "Ignore Ending Empty Columns", to control ascii export, to ignore empty columns from the end, with the following options:

0 = no ignore (current way, default)

1 = ignore all empty columns after the last column with data, meta data not considered, and column with all missing values are considered empty.

This is used only if export selection is not chosen.

0

ORG-16407

Stack Columns tool check numeric for group identifier label row

In Stack Columns, choose a label row as Group Identifier, then Origin will check if all value is numeric and not set it as categorical in the result.

In Stack Columns, choose a label row as Group Identifier, then Origin will check if all value is numeric and not set it as categorical in the result.

0

ORG-17796

Stack Columns tool will maintain column plot designation for Other columns

Keep column plot designation for other columns in the Stack Columns result.

Keep column plot designation for other columns in the Stack Columns result.

0

ORG-16882

Support Excel column notation in condition string for Counif() function

For Averageif(), Countif(), and Sumif() function, you can use Excel column name in condition string argument in 2018b.

For Averageif(), Countif(), and Sumif() function, you can use Excel column name in condition string argument now. E.g,

Also, the performance of these functons is improved.

0

ORG-16509

Support for custom formatting of User Parameter rows in Worksheet

From Origin 2018b, user is allowed to set data format for a Parameter row or a User-Defined parameter row.

From Origin 2018b, user is allowed to set data format for a Parameter row or a User-Defined parameter row. This option is provided in Worksheet Properties dialog.

0

ORG-17976

Support more numeric format like Excel

Support more numeric format like Excel

• #5

• Percent: #%, #.00%

• Proper fraction # ##/##, # #/8, # #/4, # #/10, etc. and Improper fraction #/#, #/4, #/10, #/100. ##/##, etc.

• Degrees, minutes, seconds (DMS), D MS, DM, DMF

0

ORG-17285

Support more options when Copy Columns to

Support more options when Copy Columns to.

Copy Columns to is a useful way to copy columns from one sheet to other sheets and keep the linking. But some settings in source columns are not copied. Added in Origin 2018b.

0

ORG-17060

3D XYZ bar graph supports customization of individual bars

3D XYZ bar graph supports customization of individual bars

Customize pattern, color and labels

0

ORG-16671

Added Connect Control for 3D Waterfall. 

New connect line control for 3D Waterfall

Before Origin 2018b, 3d waterfall can only be plotted as straight lines. To have spline, etc., user had to plot as 2D Waterfall.

0

ORG-17466

Improve preview of 3D OpenGL graphs in dialogs

Improved 3D OpenGL graph preview in dialogs

Better preview in our export graph dialog

0

ORG-17697

Support <end> as end of column/row for size, when creating virtual matrices

Support <end> as end of column/row for size, when creating virtual matrices

Add a context menu "Dynamic Ends" to the Plotvm dialog's Input node. When it is selected, virtual matrix's range will be expanded to both row&column ends.

0

ORG-17067

Support 2D annotation for 3D scatter plot.

Support 2D annotation for 3D scatter plot