Release Notes


Origin 2020b Features

Ease of Use

Mini toolbar for worksheet and Matrix
  • Customizable mini toolbar. User can click the … on mini toolbar to uncheck some buttons.

  • Shift key (Hotkey) to bring up mini toolbar again

  • Mouse over upper left corner or gray area close to last column of worksheet, cursor changes to indicate user can click there to see sheet leverl mini toolbar.

  • Sheet mini toolbar

  • Column mini toolbar

  • Row mini toolbar:

  • Cell/Range mini toolbar in multiple columns:

  • Select a cell or multiple cells in same column, besides the above Mask and Copy for Plotting buttons, there is an Extend Selection to last row of data button.

  • Copy as Image button on EMF image cell to copy image and paste to Word, etc.

  • Matrix Mini toolbar


Copy data (columns or range) from worksheet or matrix and paste as plot in existing graph window.
  • Copy for plotting button in column/range level mini toolbar to copy data and then Ctrl+V to paste as a plot in an existing graph window

  • LabTalk command to Copy (worksheet mjst be active, with some selection):

    worksheet -cp; paste what was copied above (graph must be active):

    layer -pcp; //paste, CANNOT undo

    layer -pcpu; //paste, CAN undo


Mini toolbar improvements for graph
  • Customizable mini toolbar. User can click the … on mini toolbar to uncheck some buttons.

  • Page mini toolbar improvements: Window/Page view toggle (single layer or linked+superimposed layers (e.g double-Y) only), Fit page to layers button, Update Page Dimension buttons

  • Layer mini toolbar Improvements: Rescale to show all, Add statistics reference lines and Add plot buttons.

  • New Axis break mini toolbar

  • Change Plot To and Edit Range mini toolbar for plot

  • Separate buttons for X and Y Errors

  • Mini toolbar for single point customization, hide, label

  • Mini toolbar button for data point control of box chart (Box type: Data)

  • Wrap text button for legend, axis title and text labels

  • Mini toolbar for data selector

  • Mini toolbar for graphic object

  • Mini toolbar to customize multiple objects together


Axis mini dialog improvements
  • Change direction: X or Y axis switch in mini dialogs: such as axis scale, grid line style, reference lines, etc.

  • More… button to open corresponding tab in Axis dialog

  • Log checkbox in Axis Scale dialog


Easy way to go to corresponding graph from result sheet

When user click green lock in result sheet, Go to Graph context menu is added to easily go back to the graph.


Reverse Plots from Object Manager

In Object Manager window, right click layer node to reverse plot orders.

E.g. after reversing, the graph above will turn into


Change X or Y of plot to column from other worksheet

a. Select Columns is added under Change X and Change Y to pick column from other worksheet

b. Old Select Columns context menu is renamed to More… to select other column in current sheet when containing multiple columns.


Change data type, display, digits, etc. of multiple matrix objects in same matrix sheet together

“Apply to matrices to the right” checkbox is added to apply same


More plot type is added under Insert: Plot to Layer submenu

Based on active graph window type and last activated worksheet/matrix, applicable plot types show under Insert: Plot to Layer submenus.

E.g. if user plot a 2D graph and then activated a matrix window then go back to Graph window.

Choose Insert: Plot to Layer, contour, image, histogram types show.


Shift+Up/Down arrow in Object Manager

Quick way to select multiple sheets in Object Manager


Edit Matrix/Virtual Matrix Z Title in OM

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.


Data Highlighter in 3D graph

E.g. plot 3D scatter graph. Click Data Highlighter toolbar button and drag rectangle to select a region. Corresponding data in worksheet and other graphs are highlighted.


Disable all modified system variable values

A user system variable @@ to disable all modified system variables.

  • 1 - disable

  • 0 - enable

E.g. in Script window, run the following to disable modified system variables so back to system default.

@@=1 //press Enter key


New Graph Types

Browser Graph in Window View
  • Plot: Browser menu to plot data (fast for worksheet with many columns) as Black Line, Colored Line, and Histogram. User can customize in Plot Details for more plot types, e.g. scatter, etc.

  • Select plots to show in graph by selecting them on left panel. The left panel columns are customizable and sortable.

  • Click the down arrow on left panel for further options,

  • When using Scale in tool to create an separate Enlarged graph for details, turning off plots in browser graph will turn off corresponding plot in Enlarged graph as well.


Streamline Vector Plot

Menu entry: Plot > Specialize: Streamline (when a matrix with two object is the active window)

The two matrix objects are the derivatives of the plotted curve in the (x,y) directions, respectively.


Beeswarm Plot

Basically, Beeswarm plot is a kind of column scatter with special data point arrangement.

Jitter Points checkbox is replaced with Arrange Points dropdown list in box chart to support it.


Plot 3D Bars side by side

Plot: 3D: XYY 3D Side by Side Bars menu to plot such graph.

Side by Side Bar Style checkbox is added on Miscellaneous tab of Layer level of Plot Details dialog


Radial Plot and Stacked Radial Plot

User can select multiple Y data to create stacked polar graph, including line, area and column/bar

Under Plot → Specialized menu


Bland-Altman Plot

Under Plot: Statistics menu.


Bullet Chart -

Menu > Plot: Specialized


Plot Customization

Fill to relative base in Stack lines by Y Offset graph

In the past, when user fill area under curve in Stacked lines by Y offset graph, they are filled to the same base. See left graph.

In Origin 2020b, on Stack tab of Layer level in Plot Details dialog, a Custom Additional Line by Relative Position checkbox is added. Check it, each curve will be filled to relative additional line. Note: The additional line position is set on Grids tab of Axis dialog. E.g. y=0.


Common Display Range for plots in layer

A new property on layer level so all data plots will have the same i1 i2.

E.g. in a graph, run “layer.commonrange=1” in script window to use common range. Then right click any plot to Edit the range. Other plots will show the same range.


Support turning off column/bar baseline

Origin uses the Additional Y= line on Grids tab of Axis dialog to control where column/bar is plotted from. In the past, the baseline can not be hidden. Origin 2020b supports uncheck the checkbox to hide it but still use it as baseline.


Show Drop lines at specified points only

The following syntaxes are supported:

  1. 1 3 5 – show at specified row indices.

  2. 2:0:5 – starting from 2nd row to end, show 1, skip 5.

  3. x=3.5 7.8 – show at specified X

  4. [book1]sheet2!col(A) – show at specified rows values read from specified column

  5. x=[book1]sheet2!col(A) – show at specified X values read from specified column


Show Label at Specified Points with new syntax
  • Same syntax as Show Drop Lines at specified points only. e.g. x= 2.5 3.5, etc. If corresponding x value doesn’t exist, the label will not show.

  • Show labels at droplines only


Transparency for Fill color only

In previous versions, transparency was applied to both fill color and edge.


Create Plot with label column designation

In very old version, user needed to set a column as Label to show label of a plot. The label is actually a separate plot entry if you open Plot Details dialog.

We hid it now since in newer versions, after plotting data, user can use mini toolbar or Plot Details to set any column as the plot’s label. See Labels tab of plot level. in Plot Details dialog.

But some user may still use the old way to set a column as Label. In Origin 2020b, even if user set a column as L, we plot it as a property of plot so Labels tab is updated with it.


Box Chart Improvements
  • Draw Whisker/Error Bar on Top of Data checkbox is added on Box tab in Plot Details

  • Support Plus only, Minus only Whisker in box chart.

  • Mean and median symbol for grouped box chart


Colormap Contour and Worksheet Conditional Format: Heatmap: Allow specifying Middle level value in in 3 color limited mixing

By default when using 3-color mixing for contour plots, the middle color falls on the mid point value of From and To value.

In Origin 2020b, user can specify mid color by Value, Percent or Percentile.


Transparency option for vector plot


Mask data points in Box Chart

For box chart with data points, user can use Mask tool to mask data points.

Masked points will be gone and box chart will update. Corresponding cell in worksheet will be masked.


Support Connect Line for 2d and 3D XYY bars

Display tab is added on Plot level to turn on connect line, symbol and dropline for 2d and 3d XYY bar plots.


Zoom and Rescale Hotkeys in 3D graphs
  • D key + mouse wheel --- zoom in Z direction

  • Z key + mouse wheel --- zoom in X direction

  • Shift+Z keys + mouse wheel -- zoom in Y direction

Note: Enable clipping on Miscellaneous tab of Layer level of Plot Details dialog will hide plots outside the axis frame.


Heatmap improve to support triangular part and labels follow colormap
  • Fill Display Setting to show triangular part of blocks only.

  • Label Display setting to show triangular part of labels only.

  • Label color set to auto:

    • If there is fill display. show black or white color according to fill color.

    • If there is no fill, follow fill color.


Support displaying area plot’s border line style in legend.


Skew Plots by adjusting Angles between Axes

Skew Coordinates controls on Display/Speed tab of Layer level in Plot Details dialog.


Labels and Graphic Objects

Wrap Text in Legend, Axis Title, Text Labels on graph

E.g. click legend, and choose Wrap Text button on mini toolbar. Drag the edge of legend box to resize it. Legend will be wrapped.

A Wrap Text, Adjust Height checkbox is added on Frame tab Text ProObject dialog.

Note: When it’s wrapped, we don’t support resize the text to change font size. Please use mini toolbar or regular toolbar.


Curve Tool
  • It draws a smooth line object. When the last point is close to 1st point, it will be connected.

  • 1st click on curve will enter edit mode. Drag the solid handlers on cursor to change the shape

  • Support fill cuve and polyline objects with pattern and color


Text Customization Improvements
  • Add Sub- and Superscript for non-consecutive characters

In Text Object dialog, if non-consecutive characters are selected with Ctrl key, set it to superscript or subsript now keep it’s position.

  • Select Multi-lines to customize in Text Object dialog


System variables to attach text, rectangle and circle objects to Layer & Scale by default

If text or graphic object is attached to Layer&Frame, the position will stay with axis scale position. If it’s attached to Layer Frame, it will stay where it is even if axis scale changes.

@arx //text object attachment. 1: layer & scale. 0: layer frame (old behavior)

@arr //rectangle & circle attachment 1: layer & scale. 0: layer frame (old behavior)

We already have @ar for line and arrow objects


Set X Y Data Label & Annotation to follow axis tick label display and formula

Origin supports formula for tick labels.

If it’s used and then user adds data label, annotation, and some gadgets to show X, Y value, user can set Custom Format as X, Y, Z to show value based on tick label formula.

For Data Label, when picking Y as Label Form, set Custom Format as Y, Y, .2, Y, *4 to set decimal places and significant digits.

For data annotation, set label form as $(Y, Y), $(Y, Y, .2), $(Y, Y, *4)

This also applies to Vertical Cursor and Quick Peak gadgets.


Display Filter from Source

User can add label in graph with %(1, @LF, A) to refer to filter condition in source worksheet’s column A.

If user copy columns from source sheet to new book by Copy Columns To tool and plot from the new book, user can use %(1, @LF1) to refer to 1st row of filter condition if there are multiple filter conditions.


Axis

Axis Reference Line Fill Improvements

To add multiple reference line and fill adjacent areas with different color, duplicate reference lines are needed.

E.g. if user wanted to fill from y=0 10 with one color, y=10 to 20 another color, user needed to enter two y=10 reference lines.

It’s improved in Origin 2020b so user can specify fill color between any two reference lines.


First Tick in Axis dialog and Color Scale Control dialog is renamed as Anchor Tick

The name First Tick is misleading. It’s actually an anchor location tick must pass. E.g. if axis is from -2.36 to 3.789. Set Anchor Tick as 0 and Increment as 0.5. The major ticks will show at -2, -1.5, -1, … 0, 0.5, 1, …. 2.5

Same for color scale object. By default we only show ticks on major levels. User can set Levels to Custom Levels. And set Anchor Tick as 0 to make sure level 0 shows.


Zero tick label display options on Axis tab of Preference: Options dialog

a. add No Trailing Zero checkbox to remove the trailing zero in axis tick label(such as 5.0-->5)

b. add Zero is ‘0' checkbox to always show zero value as '0'(such as 0.0E+0 -->0)

c. system variable control is supported:

@tlc & 1: Zero is '0'
@tlc & 2: No Trailing Zero


Tick Label related improvements
  • Set Rotate (deg.): Auto to auto rotate tick labels to avoid overlapping. Set system varaible @ART=0 to roll back to old way.

  • Check Auto Hide Overlapped Labels checkbox when there are many tick labels.


Worksheet

Better display of cell contents instead of ####

Origin used to display cell values with #### when text or number are longer than cell width.
In Origin 2020b, it will show text and values.

Turn off the feature by system variable WPC=1


Support keyword "This" for workbook with Spreadsheet cell notation off

E.g. Enter This+1 to F(x) cell.

Enter mean(This) in user-defined parameter row or bottom of the column.


Allow more characters for Text format cell

Increase the limitation for a Text format cell, now you can enter up to 799 characters in a cell. (In previous version, the limit is only 252 characters)

If you want to enter more, just use the default Text & Numeric format. For a Text & Numeric format cell, you can enter up to 3799 characters.


Improve Matrix Shrink to Support More Statistics

Add dropdown list in mshrink xf dialog to select from different statistics.


Remove/Combine Duplicated Rows Tool Improvements
  • Support Multiple Reference Columns. Values in all reference columns must match to treat as duplicates

  • Support Duplication Tolerance. Set duplication tolerance to treat close by values to be duplciates


Split Worksheet Improvements
  • Split Worksheet by Reference Column Value speed has been improved by a factor of 10 or more.

Tested with a workshet with 1.8million rows and 5 columns with a reference column of two categories. The split speed improved from 158 sec in Origin 2020 to 12 sec in Origin 2020b.

  • More split options when splitting worksheet by Reference column, such as direction change, direction reset, reference value change. E.g. if X value increase, then decrease, and then increase again, user can split worksheet into 3 sheets so each x part is monotonic.


Append Worksheet Improvement

Add Dataset Identifier in result sheet. E.g. if appending worksheets row wise, new column will be added in result sheet to indicate which sheet the rows are from.


Copy Column Improvement
  • Add option to sort output worksheet.


Join Worksheets Improvements
  • Origin has X-Function to join worksheets by column or label but no menu for it. They are added under Worksheet menu now:

    • Join worksheet by Column

    • Join worksheet by Label

  • More options

    • Simpler syntax. When joining sheets with column A, older syntax [Book1]Sheet1!A=[Book2]Sheet1!A. New syntax: A or Time is time is the long name

    • Sort Output ascending and descending


Matrix

Show Matrix slider at the place of image thumbnail

wbook.slider=1;

show a single slider instead of image thumbnails


Change data type, display, digits, etc. of multiple matrix objects in same matrix sheet together

“Apply to matrices to the right” checkbox is added to apply same


Import/Data Connector/Database

Connect to Multiple Files


Selection in Data Connector Browser optional for some DCs.

Some DCs that utilize the Data Connector Browser and then the Navigator, allow for no selection in the Browser thereby deferring data import selection to the Navigator.


3 toolbar buttons added

3 buttons added at the end of Import toolbar.

  • Import all connected books in project

  • Connect data from web

  • Connect Multiple Files


Data Navigator on left side of workbook for Data Connectors

E.g. Connect to a multi-sheet Excel file or an Origin project file.

Data navigator shows on the left panel. Right click gray sheet(s) to connect them.


CSV Data Connector supports wildcard in defining Data Block Marker.

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).


Drag and drop data int analysis template Improvements

If data import instead of data connector was used in the saved Analysis template, when drag and drop data, it will use import settings.

del -FI;//delete File Import info

wks.DC.allow(2)=; //returns 1 if File Import info. is deleted

System variable @DDC to disable drag and drop to use Data connector. E.g. set @DDC=8 and drag and drop a csv file into a workbook, it will use import instead of data connector.


Improved database connection options

New Database Connector dialog allows user to use Connection string, an existing ODBC datasource, a custom ODBC connection w/o datasource or an OLE DB connection.

Custom ODBC connection allows choosing driver and basic connection settings. For advanced settings, create a datasource in Windows Control Panel.


Slow database queries can now be aborted.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.


Database now supports ODBC-based connection strings.

Can now specify ODBC settings in a connections string. For example:

Driver=SQL Server;
Server=tcp:olab.database.windows.net,1433;Database=sample1;
Uid=blahblah;Pwd=blahblah;Encrypt=yes;
TrustServerCertificate=no;Connection Timeout=30;


Import all Data Connector data at one time

New toolbar button and menu item under Data menu entitled “Import all Connected Data“ imports all DC-connected data in order of worksheet creation.


Database import supports importing images

Database import now supports importing images into images in worksheet cells. Tested wiht MySQL and SQL Server only.


For some DCs Navigator allows appending variables as new columns in active worksheet

Some DCs offer the option to import variables as new columns in the active worksheet via right-click on variable.

NOT supported for Excel DC.


Analysis

Output Gadget results to source data workbook

In the past, user could only output gadget results to new workbook.

In Origin 2020b, user can specify [<input>]Sheet2 to output results to new sheet Sheet2 in source data book.


Support Multiple Dataset Idenifier in analysis result

User can specify more than 1 Dataset Identifiers, e.g. In Statistics on Columns, Fitting, Peak Analysis, etc.


Reprocess button on Batch Processing summary sheet

After doing batch process, use may want to modify template and do the batch process again, or data file has been modified and user wants to batch process again.

In Origin 2020b, a Reprocess button is added on summary book. Use can click it to update the result based on modified template or data.


Update button on Batch Processing Summary sheet

User can edit/mask data in Intermediate workbook created by batch process. Then select corresponding row(s) and click Update button on Summary sheet to get recalculated result.


Peak Analyzer improvements
  • Support sorting in output worksheet created by PA. E.g. user can sort peaks by peak index, peak height in Peak Properties sheet

  • Option to use data in x axis range when doing PA from zoomed in graph window

  • Customize Peak Filtering Method with script

E.g. Want Filter Condition combining Peak Number <=3 and Height Percent >= 20% (Maximum Height), the script can be written as n<=3 AND hp>=20

  • When there is YError bar and open PA, it will be included and YError will show under Input node on first page. Weighting method is still controlled on Fit Peaks page. But user can save PA theme with y error bar and use on new plot with error bar.


Batch Peak Analysis improvements
  • Recalculation support of Batch PA

  • All Columns option in Input node

  • Sort Output Sheet by Peak Index checkbox to show peaks by peak index. E.g. peak 1 of all spectra show together, then peak2 of all spectra, and so on.

  • Further speed up to open Batch Peak Analysis dialog when input has many XY datasets

  • Output Data Identifier information to Messages Log if the fit failed in Batch Processing

  • Batch PA picks all plots in page if starting from Graph window

  • Put Dataset ID in user-defined parameter row when appending results by Columns


Speed improvements of Unstack Columns

Using multi-threaded for Unstack Columns calculation, so the speed should be much faster now.

For example, unstacks 4M points of data to about 2000 groups, the speed can be 6 times faster.


improvements to Analysis with output to Matrix object to output useful info. to metadata of it

The source data's info should be putted to  the result matrix object's metadata, such as sheet name, long name, unit, comment and so on


Add EC90 and EC10 output for built-in functions and Sigmoidal gadget

We only output EC80 and EC20 in built-in Fitting Functions in the past. EC90 and EC10 are added in the following fitting functions and Sigmoidal Gadget.

  • Boltzmann

  • DoseResp

  • Hill

  • Hill1

  • Logistic

  • MichaelisMenten


Statistics

Support Mean Comparison in 3 Nonparametric analysis tools

Support multiple mean comparison for Kruskal-Wallis ANOVA, Moods Median Test and Friedman ANOVA.


Statsxy X-Function to get statistics by binning

Do statistics on Y based on X Binning. Multiple quantities can be calculated.


Programming

Labtalk functions to

They are accessible under It’s FunctionLookup & Reference menu in Set Column Values dialog

  • category(vd)$ – e.g. category(A) or category(A)$

  • catindex(vd) – e.g. catindex(A)

  • catrows(vd)$ – e.g. catrows(A) or catrows(A)$

  • cattext(vd, vd)$ – reverse of catindex(), e.g. cattext(E, A) or cattext(E, A)$


New Column Properties
  • New Property IsCat to set a column to be categorical or check a column is categorical

wks.col1.IsCat

  • New Property EvenX to both get and set a column to be using Sample Interval.

wks.col1.EvenX


Split Text Cell / Text to Columns tool like Excel

 New xfunction called text2cols.OXF and put it on : ..\Origin\X-Functions\Data Manipulation\Worksheet\text2cols.OXF

In Script window, type text2cols -d to open the dialog


Sem() function to calculate standard error of dataset
  • Syntax Sem(A) in cell formula or set column values dialog or Sem(col(A)) in Script window and code.

  • Available under Under Function → Statistics menu in Set Column Values dialog.


Labtalk function to Join arbitrary ranges as a single dataset

Dataset join(range1, range2, ...)

e.g. =mean(join(A1:A2, C5:D8))


Labtalk command to open Edit Range dialog

layer -ep to edit display range of plot


Labtalk property to get plot type info

layer.plot1.pid


Unix timestamp conversion function

New function to convert to and from Unix timestamps.

double UnixTime(d1[, d2, n])

Where d1 is a Unix timestamp or Julian date, d2 is a timezone offset (default 0), if n=0 (default) convert from Unix time stamp to Julian date. If n=1 it convert from Julian date to Unix timestamp. Supports vectors for SCV usage.


Set Order for Worksheet column labels quickly

wks.Labels(@);

Sets worksheet column label row order (from top) to long name, units, comments.


Miscellaneous

Project Properties dialog

File: Properties… menu to save separator settings and then save into project file.

Audit Log and Password protection still needs to be set in Tools menu


Show all Pro menu in Regular Origin

OriginPro menus are hidden in the past in Origin regular so many Origin user doesn’t even know they can upgrade to OriginPro to have the feature.

In Origin 2020b,

  1. OriginPro menus show in regular Origin, with suffix (Pro) on the menu.

  2. Click it will open a message box to let user know it’s an OriginPro feature and consider upgrading.

  3. Set system variable @rpm=1 to hide OriginPro menus in Origin.


Allow Matlab Console to connect to already running instance of Matlab

If there is already a running Matlab instance existing, Origin will promp a massage asking if you'd like to connect to it. You will need to copy and execute a Matlab cmd in order to enable the connection.


Origin 2020 Features

Ease of Use

Mini toolbars for easier 2D graph customization

Popup buttons when clicking on plot, axis, label, layer or page for easier customization.

Note: For a group of plots, 1st click will select a single plot. The popup shows two tabs. One is Group tab to customize the whole group. The other tab is Single plot to customize that plot only.

You can Shift+click to select group of plots. 


  • Axes Mini Toolbars (Little dialog like Grid Lines, Reference Lines, Special Ticks, Axis Break, Axes Dialog)
  • Text Object Mini Toolbar                                                                                                                              
  • Tick Label Mini Toolbar                                         
  • Data Label Mini Toolbar (Improved in Beta5)                                                                   
  • Line+Symbol Plot Mini Toolbar (line or scatter plot, some controls will be hidden)
  • Error Bar Mini Toolbar                                                                            
  • Column/Bar Plot Mini Toolbar                                                                           
  • Box Chart Mini Toolbar                                                                          
  • Histogram Mini Toolbar                                                                                                  


  • Pie & Doughnut Chart Mini Toolbar                                                               


  • Contour and Heat Map Mini Toolbars                                      
  • Layer Mini Toolbar                                                                                                         
  • Page Mini Toolbar                                                                          



Copy Paste Data Plots between Graph Layers

Click on a plot and then choose Copy Plot button on Mini toolbar

E.g. on the left graph below, click the continent border (black plot plot) and click Copy Plot button.  Then on the right graph, Ctrl+V. Border lines will be added. 

Labtalk command

layer.plot.copy() //copy active plot or group of plots

layer.plot2.copy() //for ungrouped plot, copy 2nd plot


Easy way to plot selected YX columns
Sometimes user's X column is on the right side of Y, if user selects Y and right X columns, Y will be plotted against the right X. System variable @DXR=1 to turn it off


Compact Popup for Font and Line Format

Font and some Line format controls are combined to make Plot Details dialog more compact. 

E.g. Font control are combined into one with down arrow at the end to customize further. 

Box Chart Line and Connect Lines control are also combined. 


Move Multi-Panel/Axis plots to new tab of Plot menu

There are too many plot types under Plot: Basic 2D. So we moved multi-panel and multi-axis plot types into a new tab: Multi-Panel/Axis


List View in Template Library

Template Library with large thumbnail view is not easy to use if there are many user-defined graph template. List View is added. 


Object Manager for workbook window
  • List all sheets in active workbook.
  • Click the sheet in Object Manager will activate the corresponding sheet in workbook.
  • Right click for common operations, such as Delete, Insert, Add, Move, Copy, Rename, etc.


User Tree at Sheet Level
Right-click on any sheet and bring up Worksheet Properties (or double click in gray area of active sheet). There is now a User Tree tab, and user can add and view sheet level entries.


Single click in graph is changed to select a single plot for grouped plots

When multiple data are plotted together, they are grouped. In the past, when click on a plot in the group, the group will be selected. 2nd click will select a single plot. 3rd click will select a single point.

In Origin 2020, 1st single click on a plot will select the single plot, 2nd click will select a single point. If you want to select the whole group, press Shift key when clicking on plot. Set system variable @gsm=0 to roll back to the old behavior.


Copy and paste data as as HTML table to other applications such as MS Word, etc.

Copy a block of cells from worksheet or a table from a report sheet and choose Copy Table (HTML, EMF).

and paste to Word or other application either as an HTML table or an EMF image. If the destination App supports editing the pasted HTML or EMF, table design and contents may be changed. EMF is useful for Adobe Illustrator which doesn't support pasting HTML.

.


Indicate the selected graph in preview of Merge Graphs dialog


Add a Find Apps... menu under Fitting, Peak Analysis, and Statistics menu
There are many Free and easier to use apps in these area and hidden. When built-in ones don't fit your need, click Find Apps in these areas.


Hotkey improvements in Worksheet

CTRL+SIFT+END extends to end of data column.

CTRL+SHIFT+HOME extends to 1st column 

SHIFT + Arrow to select multiple columns or rows like in Excel


Clear <auto> in From and To box when clicking on it in Set Column Values dialog
So user can directly key in From or To values. 


View: Show Plot Selection in Workbook menu when graph window is active

It's checked by default so selecting a single plot will highlight corresponding data in other windows, such as worksheet and other graph windows. 

Uncheck it if user doesn't want to highlight data in other windows.

Corresponding system variable @PS=1 by default. 


In Load Template dialog, arrow shows on top of column header by default

Choose File: New: From Template... to open a dialog. 

Templates here can be sorted by clicking column header. But it's not obvious.

In Origin 2020, an arrow shows on column header by default to indicate sort-ability.


Change Parameters... context menu when right clicking anywhere in hierarchical result sheet

In the past, user had to scroll up to the top of the hierarchical sheet and click the green lock to bring up the Change Parameters... context menu. In Origin 2020, Change Parameters... context menu is added no matter where you click in the sheet.



Sheet level context menu improvements

The quickest way to open Worksheet Properties dialog is by double clicking gray area to the right of column area.

But for worksheet with many columns, it's hard. And using Format: Worksheet... isn't that convenient.

So in Origin 2020, we added Properties... context menu when right clicking sheet tab or right clicking the upper-left corner of worksheet. 

The context menu on upper-left corner of worksheet is also more compact now. Some old menus are removed from there. 


Support Recently Used Fonts in some dialogs, such as Plot Details, Text Object, etc.

Click Font control in the dialog, user can see recently used font on the top of the dropdown list.

Not supported in Axis dialog.


Reduce unnecessary redraw of Object Manager to save time when editing large graph.
For graph which many data, object manager will NOT be updated unless there are actual changes to data plot in any of the layer. This will avoid slowness causes by necessary update of Object Manager. 


Support deleting rectangle box in enlarged graph

Before this change, if user clicks Scale in button, and then single clicks in graph window to create an independent enlarged graph with a rectangle box in source graph, it was very hard to delete the rectangle box. User had to choose Edit: Edit Mode and then delete it. 

Now user can select the rectangle object and press Delete key to delete it together with the enlarged graph.


Unhide all hidden rows or columns Context menu
Unhide All context menus are added under Hide/UnHide Rows and Hide/Unhide Columns context menus.


Many Windows in Folder slow to load and switching folders

For project file with many windows in folder, loading the project or switching folders in Project Explorer is very slow. System variable @PEN is introduced. It controls how many windows show at maximum when switching folders. Default is 0, which means no auto hiding. Set it to 20, then when loading opju or switching folders, only up to 20 window shows. Others are hidden. Right click the folder and choose Show All Windows to make them show.


System variable to disable graph rendering
For project file contains graph that will take forever to draw, can set @DDP to 1 to prevent graph drawing.


Turn off the Autosave of Untitled.opju

When you are working in Origin and haven't saved the project yet, it's called Untitled.opju.

  1. In the past, autosave would kick in every N minutes for such untitled.opju no matter how big the data is, which can be annoying and time conusming. Origin 2020 will check the current workspace size and give warning if more than 20MB for user to decide if autosave it or not. 
  2. Set system variable @DASU=1 to turn off Autosaving of Untitled.opju. 


Allow edit data label format for group plot
Allow edit data label format for group plot when edit mode=dependent


Customizable Floating Toolbar for graphs
Install the GToolbar.opx and WToolbar.opx, customized different Graph/Worksheet Toolbar respectively, hotkey F6 to open the Toolbar locates at current cursor, F6 again or switch to other window to hide it.


Use different shortcuts for main menu beginning with same initial letter
In 2020, we changes some menu shortcuts


New Graph Types

Pie Chart Improvements


Plot → Basic 2D

Many Pie/Donut samples in Help: Learning Center.


Sankey Diagram

Plot: Categorical: Sankey 

Plot: Categorical: Aluvial 


Kite Diagram

Plot: Specialized: Kite Diagram


Density Dots and Color Dots for Large Data

Plot: Basic 2D: Density Dots and Plot: Basic 2D: Color Dots



Population Pyramid

Plot: Statistics: Population Pyramid

It's a two layer histogram side by side. 


Before-After Plot
Plot: Basic 2D: Before-After


Graph Customization

Faster scatter plot drawing speed

Improved scatter drawing speed when turning off speed mode to show all data, specially for square shaped scatter plot and colormapped scatter plot, it's almost 5-10 times faster.

Also, support a new plot type, Color Dots. It can be almost 8 times faster than normal colormapped scatter plot.

For scatter plot with solid rectangle and circle shapes, improve the drawing speed when turn on transparency. It can be 1.5 times faster than before.


Faster contour plot drawing speed

Improved Contour plot drawing speed for large dataset, especially when some level's fill colors are set to be none.  

E.g. for 130,000 row of XYZ data, if you plot contour and turn the speed mode off. It may take a few minutes. In Origin 2020, it will be a few seconds. 


Data Highlight speed improvements for large data

If user has a large scatter plot with many points and use data highlight tool to highlight a region, it was very slow in the past.

E.g. plot a scatter graph with 2million points. Turn off speed mode. Highlight a region with >28k points. It takes about 5 sec in Origin 2020 vs 100 sec. in Origin 2019b. 


Offset data points in box chart and alternating the offset in pairs


Supersubscript button and Align Columns checkbox in Text Object Properties dialog


Left Arrow options when adding custom legend symbol


Dense Data Mode

Improve graph customization by turn on the dense data mode.

After customization done, user can refresh graph to update image.

It's on Page level mini toolbar. Click close to border of white page to see the page mini toolbar


Skip Points (or speed mode) keeps last point by default
When skip points in scatter graph, last point may be skipped.  In Origin 2020, last point will be forced to show by default. Set @smep=0 to roll back to old behavior. 


Separate rugs for each panel of Trellis Plot


Plot Data Organized as X,XErr,Y,YErr, Z as a 3D Graph with X and Y direction error
If there is another Z column after Z column and you choose Plot: 3D: 3D Scatter + Z Error,  the last Z will be plotted as Z direction error bar.


More options in Windrose Plot


Highlight corresponding data when selecting a single Box Plot
In Origin 2019b, highlighting corresponding worksheet data only worked for basic graphs such as line, scatter, column/bar.. 


Color Scale Improvements


Edit Range by X, Y and Z value in 3D graph
  • Data: Edit Range... menu is added for easy access.
  • For 3D graph, user can specify the range by X, Y values. Note: For data plotted by XYZ columns, By X and By Y radios are only enabled if X or Y is monotonic.

  • For 3D graph, Clip data also supports by Value on Miscellaneous tab of Page level in Plot Details dialog.


Improved tooltip for Contour, and Heatmap graphs
For contour, X, Y and Z values will show. For contour, interpolation will be used.


Reduce graph refresh when modify axis properties

Origin refreshed the whole graph when customing axis ticks, tick labels, title, color scale object, etc. in old versions, which could be very slow for large graph.

This is improved in Origin 2020 to reduce some unnecessary refreshing of graph.  


Support density color mapping

By points:Density color mapping.

Do not support 3D symbol for now.


Show Scaling Factor even if Symbol Size isn't indexed to a column

Size Unit can be set. We can choose Point, X scale, Y scale.

Precision and maximum value for Size option should follow axis scale, when size unit=X scale, Y scale.
When Size Unit=Point, it keeps old limitation.


Improvements on Rectangle box for Enlarged graph
 When the name of rectangle object is ZOOMRECT,
1. open Object Properties dialog should go to Dimensions tab by default.
2. Unit should be Scale by default.

For Rectangle/Circle/Polygon/Polyline/rake object,
1. Unit = Scale, show Right and Bottom editbox instead of Width and Height.
2. Unit = % of layer or % of page show Left Margin, Right Margin, Top Margin, Bottom Margin.

Add Update Dimensions to context menu of Zoom ROI, above Properties. Click it could get the scale info of related enlarged graph.


Do not select point if user click again exceed certain time frame
After user selects a plot, only if clicks again in a very small time 2 sec, then select a single point.


Double Click tooltip should not open preference dialog
Turn off double click tooltip to open Preference dialog


Improve Plot Highlight effect to work better with Customization
  1. Do not show indicator if user select plot
  2. Fade out other group if there are multiple groups


Auto Fill color for Error Bar
Add en option for Error bar for fill. When it's enable, error bar will show as lighter version of line color.


Data Point Tooltip should not open dialog for sankey/alluvial/parallel
Turn off the Data Point Tooltip dialog for sankey/alluvial/parallel 


Allow show Median Line when there is no box
Support show median line if there is no box as Box Type


link axes in child layer to parent with same from to should update scale mutually
  1. plot vertical 2 panel plot,
  2. open PD, go to layer2, link Axes Scales tab
  3. set X Axis Link Custom, X1=X1, X2=X2, ok
  4. go to layer 2 change X scale
    ==> only layer 2 change scale

In Origin2020, child layer change could also affect parent layer.


More work on Clip Data to Frame for edge points
Do not draw point when its value is outside axis scale in Origin2020.


3D XYY Stacked Bar/Wall Plot

Support Incremental stack for 3D plot.

For 3d XYY Bar, stack offset means offset in Y direction.
For 3d XYZ Bar, stack offset means offset in Z direction.


More Data Label Position Control for Polar
 We support following options for Position and Rotate for data label in polar coordinate:
  1. For Rotate, add <Radial> and <Angular> to dropdown list.
    • <Radial> is direction from polar center to data point.
    • <Angular> is perpendicular to <Radial> and in clockwise direction.
  2. For Position, add Angular Outer and Angular Inner to dropdown list.
    • Angular Outer means the point on label bounding box which is closest to the center of polar should be on the outer of data point
    • Angular Inner means the point on label bounding box which is farthest to the center of polar should be on the inner of data point
    • If angular outer or inner is selected, offset should not be horizontal and vertical. We should use Angular Offset(degree) and Radial Offset(% of font height)


Reverse Axis for Polar Radial Axis
 Polar radial axis support to reverse.


Axis Tick label: Show zero as 0, no decimal places

Set @tlc=1 to show zero as 0, no decimal places. 

Default @tlc=0 so zero isn't treated differently.


Import & Export

Multi-threaded ASCII import
The following system variables are added:
@IAMT=<auto> /// number of additional threads to use when import, will be auto detected by logical processors. Set to 0 to disable multi-threading.
@IAS=10 /// least file size (in Megabytes) to enable multi-threading.


System variable to control the protection mode of imported range

@IPDC(Data Connector) to control the protection mode for imported range.

  • 0 - no protection
  • 1 - protected, except reorder
  • 2 - protected


CSV Connector Improvements

E.g. sometimes data block starts or end with some keywords, e.g. [Data] or >>>>Start<<<<<<, etc. User can specify the start and end  data block marker. In the past, user needed to specify number of rows before data. 


Specify Long name, Units and Comments in Excel Connector


Drag and Drop support of Data Connector
When dragging and dropping data into Origin, inform user there is data connector and let user specify using data connector or old import way to import data. 


Origin Connector to allow basic SQL selection and Improve Origin Internal Query SQL Support
  1. Following object notations are supported in internal query SQL
    • _Type, _SName, _LName, _DatasetType, _Comments, _Visible, Column_Y, Column_Z, Column_P1, Column_D1, Column_[Name], , Sheet_SName, Book_SName, Book_LName
  2. New worksheet command to output SQL query result to workbook.
    • worksheet -qn: Output to new book
    • worksheet -qa: Output to active book, this will first delete all existing columns
    • Example:
      • worksheet -qn Select Column From Project Where Book_LName like "*simple*" and Column_LName like "YCO*";
      • worksheet -qn Select Column from Project where (_Type = "X" and _Visible = True);
  3. A Query button is added in Origin Connector. Open it to enter query.


Enhanced Database Import

  • Directly import images stored inside the database as pictures in worksheet cells
  • Protect imported data from editing, to ensure data integrity, 
  • @IPDB(Database Import) and @IPDC(Data Connector) to control the protection mode for imported range.
    • 0 - no protection
    • 1 - protected, except reorder
    • 2 - protected
  • @DBSV to control whether to show Views in table list on SQL Editor dialog or not. Default is 0 to not show.
  • Support Exclude Imported Data when saving as OPJU/OGWU for Database Import.
  • Improved Ease of Use and performance

In previous versions, import database by ODBC is slower than ADO, and cannot import large dataset. Now this has been improved in Origin 2020.

Setting @ODBCA = 0 (Default), then you should be able to import large dataset now.

Also, the performance of ODBC should be faster than ADO method now.

Also, when importing using Microsoft OLE DB Provider for ODBC for database connection, Origin will use ODBC by default now. It used to use ADO by default even for ODBC.


Option to encrypt or leave database credentials in clear text

When SQL Editor dialog launches, the user is prompted to encrypt their credentials. If the user choose not to, the password is displayed in clear text in the Edit Connection String... dialog. However, it still appears as *** other places in Origin. If credentials are encrypted the password appears as *** everywhere.

Note: This is has late breaking issues which will be addressed.


Data Connector Exclude saving only for larger files

Added system variables @DNS, @FSE, @FSEW and @FSEB to control if check Exclude Imported When Saving menu item for Data Connector and Database.

  1. @DNS ///exclude imported data or not when saving
    • 0 = (defualt) file check @FSE and web check @FSEW
    • 1 = always don't exclude, all data always save with project
  2. @FSE=500(default) //500=500kb, save data if the file size is less than this value, for CSV, Excel and Import Filter connector
  3. @FSEW=80(default) //in units of 100, save data if the size(rows x cols) of imported data is less then this value, for any web data and other files not listed above
    • 0 = never save web data
    • -1 = always save web data
  4. @FSEB=0(default) //in units of 100, save data if the size(rows x cols) of imported data is less then this value, for database


CSV connector needs to support ISO time with GMT
CSV Connector supports auto detect ISO time with GMT(for exmple: 2014-08-04T14:32:27.000+02:00) and set Column Format as yyyy'-'MM'-'dd HH':'mm':'ss'.'###.


Copy and paste density plot
  1. support copy page
  2. allow user to add another layer like double-Y kind to overlay another layer with or without data


Worksheet

Excel like cell reference in cell formula


Set a column with checkbox, dropdown list or combo list
wks.col2.edit=
1. Checkbox
2. Dropdown List with fixed entries
3. Combo box, dropdown list but user can enter new entries.

E.g. set column B as categorical.
Run wks.col2.edit=2, then click a cell, you can choose a category entry from dropdown list.
Run wks.col2.edit=3 and then click a cell, you can either choose a category from dropdown list or add a new category.

Click Any cell in column B, a dropdown list will show with filled categories. 


Worksheet Short Name, Long Name improvements
  • In the past when right clicking sheet tab, there is a Sheet Name to Display context menu for user to specify what name to show on the tab.

     In 2020, the context menu is hidden. A system variable @SSL is added to control sheet display name

                   0 – The way before Origin 2020

                   1 – Long name if present (default)

                   2 – Short Name

                   3 – Long Name

     Sheet Name to Display context menu is hidden unless system variable @SSL is set back to 0

  • In Plot Setup, Layer Contents dialogs, Sheet Name will use display name by default. Sheet Long Name, Sheet Short Name can be shown in these dialogs as well. 


Duplicate Project or Workbook without data keeps cell reference or cell formula

In the past, if there is cell formula and user right click workbook title bar to duplicate without data, or right click sheet tab and choose Duplicate Without Data, cell formula will be cleared.

Improved in Origin 2020 so user can easily create a new book/sheet with same strucuture and cell formula as original one.

In File: Clone Project... dialog, Clean Raw Data (Exclude Cell Link) radio button is added. 


Support copy a data range with column label rows


Improve Sum function to support rowwise sum

E.g. sum(A:D) to sum rowwise from column A to D.

Sum(A, C:D, F:H) to sum rowwise columns A, C to D and F to H.


Show Column Index and data size in Column List View


Filter will be triggered automatically when importing data

In the past, after importing new data, user needs to manually reapply filter.


Faster cursor response when clicking in a large worksheet with column filter

For large data, after adding filter in worksheet, it was very slow to do data manipulation in worksheet,

such as select/unselect cell(s) or column(s)

move or resize window.


Worksheet manipulation: Speed Improvement.

Origin 2020 Worksheet Data Exaction is 10 times faster than Origin 2019b.

Origin 2020 Split Worksheet has 208% speed improvement from Origin 2019b.

Origin 2020 Split Columns has 14% speed improvement from Origin 2019b.

Origin 2020 Worksheet transpose has 24% speed improvement from Origin 2019b.

Origin 2020 Worksheet Convert to XYZ has 60% speed improvement from Origin 2019b.

Origin 2020 Worksheet Unstack Data has 24% speed improvement from Origin 2019b.



Add View: Arrange Graphs menu item for Worksheet
When worksheet contains floating graphs, user can choose menu View: Arrange Graphs to place in top left corner of data area. This is useful if floating graphs are invisible or beyond the worksheet window.


Copy display string for hierarchical report table

Improve Ctrl + C to follow the Digits setting in Preferences: Options dialog when copy values in hierarchical report sheet.

User can still user Ctrl + Alt + C to copy full precision.


Analysis

Speed improvements on recalculation

Improvement was made on SetReportTree() method, which is used to generate a results worksheet. So when there are many operations involves report sheet, you will get at least 10% time saving on calculation.

Besides, if there are many column formula operations, recalculation was done one by one in previous version and the time maybe a little long. But now in Origin 2020, you will see that all recalculation can be done in the same time and the calculation is very fast.


Speed improvements on Quick Peak tool

For large data, it was very slow to use Quick Peak gadget in previous versions.

  • Add gadget speed is more than 150 times faster than Origin 2019b – It may take a few minutes to open the gadget in Origin 2019b while it only takes a few seconds in Origin 2020.
  • Output result speed is 80 times faster – It may take a few minutes to output result sheet in a region of interest while it only takes a few seconds in Origin 2020.

Note:

  • System variable @PPBLN is added, default value is 1000. If number of input data points over this value, baseline data will not be output in the result Notes.
  • System variable @PPBMA is added, default value is 100. If number of find peaks over this value, no base markers and integrated areas shown on the ROI.
  • If choose the "New Output for Entire Curve" item, the performance is not improved yet.

Besides, pkFind tool is also improved, 7 times faster on calculation.


Speed improvements on Means Comparison in ANOVA tool

Improved the calculating speed of Means Comparison, and it will be 30% faster than Origin 2019b.

Besides, if choose not output the Means Comparison result, previous version will still do the calculation in background and waste time. Now this is fixed in Origin 2020, and will be 83 times faster than Origin 2019b.


Improvements in Normalization tool

When normalizing multiple datasets, can combine them as a single dataset to normalize.



Support simple LT expression in Add Straight Line and other XFs
  • Support LT Expression for Value, e.g. enter -log(0.05)
  • Support Page info variables and values from columns as input to XF, e.g. page.info.user.variables.noofpoints


Support copy and paste link for GetN numeric or string input
User can copy a label cell or a data cell, and paste link to edit box in XF dialog.


Combine all Word files into one file after batch processing


Simple Curve Math supports custom formula

In the past, user could only do basic calculation between two curves by choosing +,-, , / and ^ in Operator dropdown list. Custom is added in Origin 2020 to define custom formula by using y1 as input data and y2 as reference data, e.g. y1*5-y2^2.

Custom formula is also added in Simple Column Math tool.


Context menu on analysis lock to include hidden rows in analysis

By default when there is filter in column and it's input for an analysis, hidden rows will be ignored. But user can click the analysis lock and choose Ignore Hidden Rows: No to include hidden rows in analysis.

Auto means follow the setting in Worksheet Properties → Miscellaneous tab. 


Allow double clicking Axis to open Axis dialog in Peak Analysis Preview
This feature was turned off in some recent versions but user complains very hard to adjust axis scale. So we bring it back in Origin 2020. 


Copy All Open Tables in hierarchical result sheet


Kernel Density Calculation: New (fast) algorithm

For large datasets to plot 2D Kernel  Density, earlier Origin versions take several hours or more. 

Origin 2020 introduces new Density Method: Binned Approximate Estimation and adds an new option: Interpolate Density Points to improve speed greatly, which takes only several seconds.

A New Labtalk function is supported as below:

ks2d(vx,vy[, int bandwidth=0, int grid=151, int interp=1, int density=1])


Improve box plot in One-Way ANOVA
  1. For the box charts of One Way ANOVA and Statistic on columns, which has only one group column, Origin 2020 does not set subgroup.
  2. One Way ANOVA's box charts and Statistic on columns' box charts default templates follow Grouped Box Charts' setting in Plot Details dialog:
    1. Check Outliers checkbox and Box width=80 in Box tab.
    2. Uncheck 99% and 1%, Max, Min checkboxes in Percentile tab
    3. Border Color=Q13 and width=1.5, Fill Color: Auto in Pattern tab
    4. Caps Length=50 in Lines tab
  3. Rename Connect by Subgroup to Connect within Subgroup in Plot Details dialog Connect Lines tab for Grouped Box Charts


Better level crossing result for large duration points


Set Cluster Membership column as Categorical and Ascending type

In Origin 2019b, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column was already sorted and without link to the order of the original data.

In Origin 2020, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column keeps  the order of the original data and is set as Categorical and Ascending type.


support the "Open Books" button in summary report when appending results by column
Append by column will also support the "Open Books" button in summary report book like appending result by row when do batch processing, it will be convenient for user to check the intermediate workbook.


Batch Processing support Analysis Templates that having Data Connector

Origin support importing data by data connector since Origin2019b, therefore,batch processing also improve to support analysis template which source data is imported by data connector(such as CSV connector,Excel Connector,MATLAB Connector,etc).

note:currently Data Connector will be supported only when Data Source is Import From Files.


Data filter in analysis template will automatically trigger after importing data

In Origin2020, data filter will be auto triggered after importing data, it will be very convenient when do batch analysis on analysis template which having data filter in source data sheet. you do not need add script to handle data filter anymore.

note:This support in batch process dialog only when Data Source is Import From Files .


Allow ANOVA 'Number of Levels' to be > 10
In Origin 2020, Allow ANOVA 'Number of Levels' to 25.


Programming

Increase Row Size Limit for 64bit
Increase the worksheet row size limit from 90M to 200 M for 64bit.


Support numeric access to label cell

When label cell is a numeric value, you can access it as numeric value instead of string now. 

E.g, 

col(A)[D1] =;

This can be disable by setting @LRNA = 0.


Labtalk option to generate gadget output for all curves, all layers, etc.
We had the following to generate new output of a gadget.
Gadget gd = Rect; gd.Output();

But since we have New Output for All Curves, New Output for All Layers, etc., we should have more options of what to output.
So now user can use
gd.Output(2) //new output for all curves

0 -- normal
1 -- last
2 -- all curves
3 -- all layers
4 -- entire curve //this is Quick Peaks gadget only


Faster Date and Time Labtalk functions

Origin Labtalk functions belong to Date and Time category are moved to VC level to have faster speed.

E.g.

Column A is filled with 1million rows of date data

Set Column B formula as WeekDayName(A)

In Origin 2019b and earlier build, it took about 95 sec, while in Origin 2020, it only takes about 1 sec.


Note: In Set Column Values dialog, you can click Function: Date and Time menu to see all date and time functions Origin supports. 


Add OriginC for note window
void test(string str = "Hello World.html")
{
	string strFile=GetOriginPath(ORIGIN_PATH_SYSTEM) + "\\Samples\HTML\\" + str;
	string strExport = "c:\\test\\test.html";
	int n;
	Note note;
	note.Create();
	n = note.DoMethod("Load", strFile);
	n = note.DoMethod("EXPORTHTML", strExport);
	n = note.SetProp("View",0);
	n = note.SetProp("Syntax",0);
	n = note.DoMethod("DUPLICATE");
	n = note.DoMethod("Close");
}


Control Polygon or Polyline object thru LabTalk
  • <objectName>.PointCount

Suppose user has a polygon of 4 points, then script "polygon.pointcount =;" will return 4.

Also, can set polygon.pointcount=5 to add more points, then use polygon.x5= and polygon.y5= to specify the 5th point coordinates.

  • Get and Set XY coordinates to/from worksheet columns
// objname.GetXY(xDataset, yDataset); // copy from obj to dataset
// objname.SetXY(xDataset, yDataset); // copy from dataset to obj
// Ex:
polyline.getXY(book1_a, book1_b);
polyline.setXY(book2_a, book2_b);
polyline.getXY(book1_a); // copy only X values
polyline.getXY(, book1_b); // copy only Y values
  • Also when adding polygon, polyline, ESC will finish it.



LT command to reduce file size

Labtalk command file -cp is very useful to reduce a huge data file, E.g. a 14G CSV file, you cannot open it anywhere. You can reduce it to a manageable size first. The code is like this

dlgfile g:=*.csv;
file -cp 3Mb fname$;

to reduce it to 3Mb.


NAG Mark 26.1

NAG library is upgraded to Mark 26.1 version


Preshipped Python 3.7.2
Preshipped Python version upgraded to 3.7.2


Support Python Input() Method

Python 3.x: var1 = input ("Enter a number:")

Python 2.7: var1 = raw_input ("Enter a number:")

This will prompt a GetN box.


Convert floating-point from other formats to IEEE 754

Added following OC funtion to convert floating-point from other formats to IEEE 754.

typedef enum
{
	FLOATING_POINT_TYPE_IEEE_FLOAT = 0,   // 32-bit
	FLOATING_POINT_TYPE_IEEE_DOUBLE,      // 64-bit

	FLOATING_POINT_TYPE_VAX_F,            // 32-bit, ~[-2.9E-39, 1.7E+38]
	FLOATING_POINT_TYPE_VAX_D,            // 64-bit, ~[-2.9E-39, 1.7E+38]
	FLOATING_POINT_TYPE_VAX_G,            // 64-bit, ~[-5.6E-309, 0.9E+308]

	FLOATING_POINT_TYPE_IBM_SHORT,        // 32-bit
	FLOATING_POINT_TYPE_IBM_LONG,         // 64-bit
	FLOATING_POINT_TYPE_IBM_LONG_XPORT,   // 64-bit
FLOATING_POINT_TYPE_COUNT } FLOATING_POINT_TYPE;

bool convert_floating_by_format(LPVOID lpOutputBuff, LPVOID lpInputBuff, size_t nNumValues, FLOATING_POINT_TYPE nOutputFormatType, FLOATING_POINT_TYPE nInputFormatType);

For example:
void vax_test() { unsigned int a[] = {0x268bc2d9, 0x015dc2d9}; double f[2]; convert_floating_by_format(f, a, 2, FLOATING_POINT_TYPE_IEEE_DOUBLE, FLOATING_POINT_TYPE_VAX_F); // f = { -27.14381980895996, -27.12566566467285 } return; }


Origin C OC and LT Access to Data Connector

1. OC call LT Sub method in Page level, for example:

void test()
{
WorksheetPage wp = Project.Pages();
int nErr = wp.DoMethod("DC.Add", "CSV");
}

2. Support "wbook.DC.type$" to get the DC type.

3. Simpler syntax for web connector in LT, for example:

newbook;
wbook.dc.add("JSON"); wks.dc.source$="https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=2018-01-01&endtime=2018-01-23"; wks.DC.Sel$="JSON/features"; wks.dc.import();



Support Column to use ComboList or Checkbox control

wks.col.edit

Adds to each cell in the column, one of the following:

1 = unselected check box
2 = list box (not editable)
3 = combobox (editable).

0 = Remove controls

wks.col2.edit=2; //add list box to column 2
wks.col2.edit=0; // remove list box from column 2


Installation and Licensing

Speed Up Origin Startup
Origin startup speed has been improved especially when User Files Folder is on LAN.


Invite colleague to try Origin
Users who have active maintenance service can choose Help: Invite a colleague to try Origin... to offer colleague a fully functional license for 21 days.


Origin 2019b Features

Ease of Use

Main Menu Reorganization
  • More horizontal menus.  (Import is removed to a separate menu called Data).

Workbook window active:

Graph window active:

Matrix window active:

Layout window active:

Notes window active:

No window active:

  • Import is removed from File menu and put under Data menu


Plot Menu Reorganization
  • Easier way  to see all templates in one category.
  • Recently used plot types are listed under Recently Used category
  • User-defined templates show under My Templates category
  • Quick access to Graph Maker and Template Library dialogs.


Copy and paste folder in Origin
  • Right click a folder in Project Explorer to copy the whole folder.
  • Right click another folder in Project Explorer to paste it there. 
  • Support paste to new session.
  • Support Ctrl+C and Ctrl+V hotkeys.


Copy and paste workbook in Origin
  • Right click a workbook in bottom panel of Project Explorer to copy.
  • Navigate to the destination folder in Project Explorer in same session or new session
  • Right click in bottom panel of Project Explorer to paste.


Project name shows at the beginning of Origin title

The information in Origin2019b title bar ordered as Project name - Path - Current PE folder - Origin version - Bit - License Type

If it's an unsaved new project, the order is Origin version - Bit - License Type - Untitled

  • Easier find which is current project name.
  • If multiple Origin opens, easier to use Window taskbar to find correct project to toggle to


Show column list view of Workbook as tooltip when mousing over workbook in Project Explorer


Block docked windows to auto expand when mousing over it

Customer complained Project Explore, Messages Log, etc. windows auto show while he is trying use tools on Tools toolbar which 

System Variable @AHBC is added to control this.

  • Set @AHBC=1 and restart Origin. 
  • Now move mouse on Project Explorer, it will not auto expand. You must click on it to see it. 


File:Clone Current Project ...
  • Clone the current project by clearing data only, clearing data and operation, or clearing and setting column calculation mode to None.
  • Add Data Connectors checkbox so the cloned project is connected to data in current project
  • After cloning, you can further modify project and then save it for future use.


Appending Projects Improvements

If user's projects

  • have no windows in root folder
  • contain only 1 subfolder

then when appending project files, and you choose No to not create subfolders for each project,

all windows will be put together to current folder.



HTML Report in Notes Window
  • Support HTML and Markdown language in Note window, 
  • Toggle Notes window between Render mode or normal mode (Ctrl+M)
  • System variable to set preferred language when pressing Ctrl+M. @NPS, 0 means HTML, 1 means Markdown
  • Note can be saved/exported to disk including all related elements such as images in a subfolder
  • New HTML main menu with Notes is active, plus context menu on Notes window title. Main menu has "Load..." with pre-shipped samples.
  • It will auto detect if the loaded file is HTML or Markdown
  • Support print HTML Style Notes window
  • HTML code can link to graphs, worksheet cells, string registers, etc either directly or using a Placeholder worksheet

HTML field codes:

  • Direct Links
    • {{str://%X%G.opju}}   -- current project name
    • {{cell://[Book1]Sensor01!B[4]}}  --- B4 value in Book1, Sensor01 sheet.
    • <img alt="{{graph://Graph1}}" width="500">
    • {{table://sheet1!}} — sheet1 or current book, {{table://[Book1]FitNL1!Parameters}} — parameters table of fitting result sheet FitNL1 in Book1  
  • Placeholders, like {{SlopeValue}}. Right click Notes window title and choose Edit Placeholder... to open the worksheet. Follow instruction there


Recently Used Fonts

Recently used fonts show on the top of the font dropdown list

Fixed some bugs when typing to find fonts


Font control for Notes window
Change Font and Font Size from Format toolbar for Notes window. It applies to all Notes window.


Reset all dialog custom positions on new Origin session

There are cases user moved some dialog, script window, etc. to other location .e.g. another monitor and when restarting Origin, user couldn't find them.

So in Origin 2019b, by default the dialog locations will reset. 

Set System variable @RDP=0 to go back to old behavior.


Copy cell and paste to a range

E.g.

Select A1 cell and copy (Ctrl+C). Select B1-B3 and paste. B1 -B3 will be filled with A1 value.

Select A1 - A3 cells and copy (Ctrl+C). Select B1-B6 and paste. B1-B3 will be filled with A1-A3, B4-B6 will be filled with A1-A3.


Set System variable @CPNB=0 to roll back to old behavior.


Reorganization of some controls on Layer level of Plot Details dialog
  • Rename Display tab as Display/Speed tab. 
  • Scale Elements moved to Size tab.


Group Folder Sharing Improvements
  • Set an Origin as group leader of multiple groups from Preferences: Set Group Folder Location... menu

 

  • Easier way to publish different files to different groups from Preferences: Group Folder Manager menu

  • Set an Origin as group member for multiple groups

  • For App (OPX) files published, it will auto install immediately after group member gets the file. No need to restart Origin.


Easier way to update all Apps to latest version

User can right click the Add Apps icon in Apps Gallery and choose Update All to updates all installed Apps to latest version.


Sort Apps in Apps Gallary

Sort apps by alphabetic order, newest, oldest


Support search in Template library
User can type keyword in upper-right corner of Template Library dialog to search for user-defined graphing templates.


Plot: 3D: Parametric Surface menu to plot 3d parametric plot from data
Data needs to be organized in z, x, y, z(optional) matrix objects order in Matrix


Graphing

New Graph Types

Rugs Plot
  • Several built-in Rugs Plot types, Scatter + Rug, Histogram+ Rug , Distribution + Rug
  • In Axis dialog, Rug tab is added to add Rug to axis with style and layout cust