Origin 2019b Features

• Connect to a web file, or a file on your local PC or network
• File types supported: CSV, Excel, ASCII/Binary (using Import Wizard filters), HTML, JSON, MATLAB, and Origin Projects
• Select data to be imported, such as specific node in XML, table in HTML, or Sheet in Origin Project
• Connection and data selection information is saved in worksheet/workbook
• Add connectors of same type to multiple worksheets in a workbook, and different connector types to multiple workbooks
• When saving the Origin project, you can opt to leave out the imported data associated with all connectors, or specific connectors. This can help reduce project file size. All calculated results and graphs from results will not be cleared.
• Re-import data from the source file any time. Make changes to source or to data selection at any time.
• More data connectors available for download from the App Center or from Data menu.
• With OPJU, user can bring in one entire sheet from the source OPJU file/webfile.
• Relative data source path and common data path for all connections in project. 

• Accessible from the new Data menu (Data→Connect to File and Data→Connect to Web)
• Also accessible from Connectors tab of Apps Gallary, which is docked on right side of the interface
• Need to have a workbook/Matrix active

For Data→Connect to Web..., there are sample URLs for various connectors. Click on the Recent URLs menu in the Connect to Web dialog to pick a sample URL.

We have several blogs on data connectors:

http://blog.originlab.com/category/origin-2019b

CSV connect

• can import both CSV and ASCII data with better auto detection of main header and subheader lines. 

Relative Data Source Path and Common Data Path:

• If your data are stored under relative folders of project file: Set Data Source relative to Project path. If you move project and data sources together, their relative path is the same. So no update needed in project file. 
• If there are many data sources under some common path: Set Data Source relative to Common Data Path. The Common Data Path needs to be set only in one Workbook.

LabTalk Access: 

• wks.HasDC
  • 0 = no connector in book
  • 1 = connector using sheet as destination
  • 2 = connector not using sheet as destination
• wks.DC.Source$: relative path, web source path
• wks.DC.Path$: empty if not File path, absolute path
• wks.DC.Sel$
• wks.DC.Valid
• wks.DC.SType: source type
  • 0 = absolute file path, this is the only value that is read-write
  • 1 = project relative file path
  • 2 = common data relative file path
  • 3 = web
• wks.DC.Allow()
• wks.DC.Reset(2)  //reset last imported data and label. Final released build will support wks.DC.Reset()
• wks.DC.Import(): import active sheet, and this is what the Import context menu used, which is now calling to File.ogs [DCImport]
  

Book Level Import Command:

• wbook.dc.import() or wbook.dc.import(0) : import all sheets, and this is what the Import All Sheets context menu used, which is now calling to File.OGS [DCImportAll]
  
• wbook.dc.Import(1) : for the active sheet, open Select... dialog and then do the import.
  
• wks.dc.Import

"doc -e LBC" to loop all sheets on book with Data Connector

• Example: Loop all sheets with DC and convert data source to Absolute path, books not having connector will be skipped. This will save time since project may have some books with many sheets.
  doc -e LBC { %H=; page.Active=; wks.dc.SType=0; }

Adding DC to workbook using LabTalk:

newbook;
wbook.dc.add("CSV");
wks.dc.source$="C:\temp\T275K.csv";
wks.dc.import();

wbook.dc.add("CSV");
wks.dc.source$=FromURL("http://www.sidc.be/silso/INFO/snmtotcsv.php")$; wks.dc.import();

Import Filter Connector and LT support: 
wbook.dc.add("Import Filter");
wks.dc.source$="C:\2016\Samples\Import and Export\S15-125-03.dat";
wks.dc.sel$="test1.oif"; //filter in same folder as data. If in uff\filters, then use wks.dc.sel$="%YFilters\test1.oif";
wks.dc.import();

• • Use Origin's Notes window to create the report
  • Use Markdown or HTML syntax
  • Copy and paste-link metadata, analysis results, and graphs
  • Support for Placeholder sheet to copy and pre-format results for placement in report
  • Report can be embedded in workbook for use as Analysis Template for batch analysis
  • Report can be printed, or exported as web page with all associated images.

Blog: http://blog.originlab.com/publishing/creating-html-reports-and-documents-in-origin-2019b

With Notes window active, go to HTML→Load Samples menu. You will find both HTML and Markdown samples.

NOTE: If you plan to write your own Markdown syntax, after opening a new Notes window, you need to right-click on title and select the Syntax→Markdown menu item. To switch between HTML and Markdown syntax, you need to first set to Text and then change to the other.

When in Markdown mode, you include html syntax, such as for setting styles, or for advanced formatting not supported by Markdown.

To view a sample OPJU showing HTML+Markdown reports:
Press F11 to open Learning Center. Then select "Analysis Samples" on left, then set the drop-down on right to "General Analysis"
Then select and open the file "Earthquakes - JSON Connector and HTML Report".
This gets data for last week's quakes from USGS and the updated data and graph are put into HTML and Markdown reports.

System variable to control using HTML or Markdown when pressing Ctrl+M

@NPS=0; /// 0 means HTML, 1 means Markdown

• Clone the current project by clearing data or clearing both data and operation
• Maintain Data Connector link to current project from the cloned project
• After cloning, you can further modify project and then save it for future use.

Menu: File→Clone current Project

This new menu replaces the old menu items File→Save Project without Data... and File→Duplicate Project without Data...

The cloned project can optionally maintain Origin Data Connector connections to the original file.

• With ANY data import (not just Data Connectors), user can opt to clear the imported data when saving project.
• This allows for your "analysis project" to stay small in size. You simply re-import the data, when needed, to perform further analysis

• Right-click on Workbook, select Window Properties.
• There is a new check box named "Exclude imported data when saving project."

Blog: http://blog.originlab.com/data-import/exclude-imported-data-when-saving-project

Copy-paste Folders

Copy-paste workbook

Copy an entire Origin Project Folder and paste it within the same project or even to another Origin session running on the same PC

Copy workbook and paste n same session or another session.

• To copy a folder, right-click on Folder/subfolder in Project Explorer (PE) and select Copy, or do CTRL-C and then CTRL-V
• To copy a workbook and paste, Right click a book in bottom panel of PE to copy, and right click in bottom panel  of PE to Paste. 

• From Plot → Statistics or Plot: 2D, there are Scatter, Histogram, Kernel Density Plot, Box Plot etc.
• Open Axes dialog. You will see a new "Rug" tab with options
  • Works for multiple plots in same layer

• Context menu on axis or rugs to copy and paste format
• Negative size to show rugs plot within axis frame with axis tick labels still stays with axis

Added support for exporting multi-sheet workbook as a multi-sheet Excel file.

File: Export: Excel

Sheets can be excluded by right-clicking on tab and selecting "Exclude from Excel Export" context menu

More first level menus to avoid  too many entries in each menu

• All Data import related to Data menu.
• With Graph window active, there is Insert menu to insert all kind of things, such as plot, graphic objects, table, etc.

The Plot menu reorganization

• Recently Used category on top.
• Icons have been rearranged so user can see all plot types in same category at once.

Some context menu changes.

ORG-18347

ORG-18329

ORG-19899

In the past when using View: Show: Frame to add layer frame, it was a non-customizable thin black line. 

In Origin 2019b, it will follow the bottom axis color and thickness, etc. 

ORG-17870

ORG-19037

ORG-19778

ORG-19110

ORG-18844 S2

ORG-19375

The Transparency controls are on corresponding tabs in Plot Details dialog.

• For two curve plots with below and above colors, areas above and below can have independent transparency.
• For Violin plot with box, violin and violin can have independent transparency.

ORG-19327

ORG-19172

ORG-19345

ORG-18361

Support Color list as Colormap Fill

• With Stretch to Full Range unchecked (default), color increment by one for different levels. 
• With Stretch to Full Range checked, color will stretch from begin to end of color list.

ORG-19660

ORG-15452

On Scale tab of Redial axis, there is a Center at %  box. Set it can add circle from center of polar.

ORG-19912

ORG-19670

ORG-19338

ORG-19321

ORG-19568

Adjust height of worksheet label row for output columns

After analysis is done, there are long column comments long names in output columns.

In the past, we auto resized the column width to fit such info. 

In Origin 2019b, by default we adjust height of column label row to avoid very wide output columns.

Use @RCW=1 to rollback the old behavior.

ORG-19427

ORG-19569

ORG-19343

ORG-18915

ORG-19355

ORG-19337

Cluster Gadget.: X at Min Y, X at Max Y, Y at Min X, Y at Max X are supported

Statistics Gadget: More outputs: besides x at min/max y, SE, confidence bands, percentiles are supported as well.

ORG-17253

ORG-19405

For the Nonlinear Fitting using Orthogonal Distance Regression, R-Square quantity is improved.

Before 2019b, R-Squared value may always be 1 though the ODR fit is normal. It is caused by the inappropriate TSS. Now the R-Square should be more accurate as TSS calculation is improved as:

TSS = sum( (y - ymean)^2) + sum( (x - xmean)^2)
R^2 = 1 - RSS/TSS
where TSS is the total sum of square, and RSS is the residual sum of square.

ORG-18180

This is supported in many tools that supports multi-sheet range.

E.g. if user wants to do statistics in same range of data on multiple sheets, user can specify the input as [book1](1:5)!1[89]:17[95]

• If it's not consecutive sheets, then what should be the syntax, (1, 3:5)!
•  together with options in Input node "Combined as Single Dataset", user can get statistics of same range in different sheets easily.

ORG-19433

• Fixed if(C=0,A,"") and C==0? A:"" issue of only filling 1st occurance of true condition.
• Default else to blank. E.g. fill column A with 1, 2, 3 and enter if(A=2,100) in column B's F(X), row 1 and 3 should be blank values instead of missing.
• IF() supports both numeric and string return. E.g. if(A<5,"small","big") works. In 2019, user needs to type if(A<5,"small","big")$

ORG-19284

ORG-19715

• IsEmpty() will give 1 for range out of bound. E.g. column A has text in 1st 4 rows only. In column B, enter formula IsEmpty(A) for rows from 1 to 10. row 5-10 will be filled with 1.
• When concatenating two string columns, use longest data to set the range. E.g. if there are 5 rows of data in column A, while 10 rows of data in column B. Set column C's formula as A$+B$.  Origin uses the 1st vector to decide the calculation range so only 1st 5 rows was conconcated. Origin 2019b, usea the longest rwo to decide range. To go back to old behavior, which used the first vector i2, set @VAS=0

• doc -rn: Make current project as Untitled and new project
• doc -e WM: Execute for all workbooks and matrix books in the project
• doc -e LBC: Execute for all sheets on book with Data Connector

del -di: Delete imported data in current sheet

ORG-19198

• Context menus to exclude files and load dependents at App Folder level
• Context menu on OGS file to run its Main section.
• Context menu on file level to load dependent files to TEMP folder

ORG-18480

ORG-19831

Added the optional argument lowbound to the COM server's method Worksheet::GetData():

OODL_PREFIX_METHOD(ODISPID_WKS_GETDATA)	HRESULT GetData(
                                                        [in, optional] VARIANT nRowStart, 
                                                        [in, optional] VARIANT nColStart,
                                                        [in, optional] VARIANT nRowEnd, 
                                                        [in, optional] VARIANT nColEnd, 
                                                        [in, optional] VARIANT format, 
                                                        [in, optional] VARIANT lowbound, 
                                                        [out, retval] VARIANT * RHS);

ORG-19690

1. Added new bit GETNEVENT_ON_AUTO_BUTTON_CLICKED for auto checkbox event.
2. Support hiding customizable value.

ORG-19426

ORG-19228

Support relative path for Apps folder in OC, for example, 

#include "file_in_Apps.h" // directly inside Apps folder
#include "AppsSubDir\awesome.h" // a sub-folder named AppsSubDir inside Apps

ORG-19028

ORG-18207

In Config.ini file, QuietModeNoRebootDialog is added.

If QuietMode and QuietModeNoRebootDialog are both set to 1, then after the end of installation, no Reboot PC page will show.

QuietModeNoRebootDialog setting will be ignored if QuietMode isn't 1.