Page Comparison

• New way to import data from file or web page
• Connection details remembered in book/sheet
• Imported data is locked from accidental/intentional editing, for keeping data integrity
• When project is saved, imported data is cleared, but output from calculations
  such as set values to new columns, operations such as LR, NLFit, Stats etc are kept.
  This helps to reduce project file size. Simply re-import when need to do further new analysis.
• A given workbook can have only one type of connector, but each sheet can have a different data sources (such as multiple CSV files connected to multiple sheets of one book
• Currently the following file formats are supported;
  CSV, HTML, JSON, Origin OPJU and MATLAB
  With OPJU, user can bring in one entire sheet from the source OPJU file/webfile

• Accessible from the new Data menu (Data→Connect to File and Data→Connect to Web)
• Also accessible from App Bar docked on the right side of the interface
• Need to have a workbook 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

NEW in Beta4:

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. Later if the common data path changes, you only need to update Common Data Path in one workbook connection. All others will be updated. 
 

CSV Connector:

 Many improvements have been made to this connector

Context Menu for Connector Icon: This has new entries including Import All Sheets and Import all Books
There is also an Auto Import entry with two options: "On Project Open" and "On Change"

Deleting Columns after DC Import: After DC import, if you delete some columns, then next time you re-import, those columns are not brought in. In other words, your reduced set of columns will be unchanged and data will be imported only into those columns.

Add New Connectors: Data→Connect to File→Add New... menu item has been added. This will open App Center and show more connector Apps that are available for download. Currently for beta4, this will show XML Connector as a new available connector for download.

• Origin Notes window now has "HTML Mode"
• Notes can be added to workbook in order to create HTML Report as part of your Analysis Template
• Support for Place Holders in HTML that can be linked to report sheet elements such as calculation results and graphs

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

New in Beta4:Markdown  Markdown syntax supported (in addition to html)

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 Markdownand 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.

• Clone the current project by clearing data (dialog has options)
• 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.

New in Beta4:

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. 

• Create graphs such as 2D 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

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-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")$

• 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