OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

Release Notes


Origin 2019 Features

A *Start Menu* button has been added to the bottom left corner of the Origin interface.

Origin icon on bottom left corner of the Origin window. 

Settings button to customize the search.

Search results can by controlled by typing a letter in front of the search phrase:
m search phrase : show only menu and shortcut menus
a search phrase  : show only apps
h search phrase  : show only Help+FAQ
search phrase  : show only videos
search phrase  : show only X-Functions

p search phase : show recent projects

s search phase: show sample projects

search phrase  : show Menus+Apps+X-Functions (executable ones)


The New Workbook dialog allows you to:

"File→New Workbook" menu or Ctrl+N.

Can also be turned on for New Project and on startup.


Add Sparklines to selected columns.

Highlight columns and click the 1st button on Columns toolbar.



Double-Y Trellis PlotParallel PlotCluster PlotViolin PlotRow-wise PlotContour plot of Categorical Z valuesHeatmap with Label3D Tetrahedral PlotStacked Histogram

Graph samples are included in the product.

Press F11 to open Origin Central dialog. 
Select  "Graph Samples" tab, then set drop-down on right side to "All Plot Types", then type 2019 in the edit box and click the search button.


Highlight data points in all open graphs that originates from same row of worksheet.
  1. With a graph active, select the new Data Highlighter tool (5th button in Tools toolbar, same group as the old Data Reader and Data Cursor)
  2. With graph active, hover on a data point for new tooltip. To customize, move your mouse into the tooltip area, then right-click and select Preferences.


Mouse over data point in graph will show coordinates & row number. Customize it to show other information from worksheet
  • Mouse over data point in graph to view tooltip.
  • Double click within the yellow tooltip box to customize further.
  • Right click within the yellow tooltip for more options such as Copy text, Go to worksheet etc.
  • Uncheck View: Data Tooltip menu to turn it off.
  • Set transparent background by system variable @TDT
  • Click reset back to restore to default. 



When selecting a plot in graph or in Object Manager, other plots fade away.

In Object Manager, click a plot.

Or in graph window, click once to select a plot. For grouped plot, needs to single click twice to select a plot

Click LEFT and RIGHT arrows to highlight previous or next plot



Highlight Cells by Rules, Highlight Duplicate Cells, and Heatmap

Select a group of cells/columns/entire sheet, then right-click and select context menu "Conditional Formatting", or select the "Worksheet→Conditional formatting" menu.


For large data with or many metadata, switch to Column list view to better view columns and metadata.
  • With worksheet active, select "View→Column List View" menu or Ctrl+W
  • Mouse over the beginning of long name cell to see 1st 5 values in tooltip


Empty cells display as blank instead of missing values (--) in worksheet when adding/inserting data; copying and pasting data and importing data.

Examples:

  • select a set of cells in a worksheet and hit Delete key. The cells will be blank. In previous versions the cells will be missing value.
  • Copy a column with missing value on top and paste to new columns, empty rows will be kept on the top.
  • Import Excel file with blank cells. In Origin, they are still blank. In the past, if u click those empty cells, they are --. 


The new Graph Maker App provides an interactive way of exploring relationships between multiple variables.

Pre-installed in 2019.

  • Create a plot by dragging and dropping variables from a column list
  • Quickly change plot type, for example, from scatter to box plot
  • Use categorical variables to split data into multiple panels, vertically or horizontally
  • Use categorical or numeric data from other columns to assign symbol color, symbol type etc.
  • Create the graph in Page View, or a drag-to-resize Window view that lets you to interactively drag and resize the graph window to give a better view of your data



Interactive dialog to guide user on choosing the appropriate statistics test/tool/app.
Pre-installed in 2019.
  • The App asks you to describe the type of test you wish to perform
  • App then recommends built-in Stats tools and/or Apps appropriate for the test
  • If a recommended App is not installed, it can be installed in the background
  • Keep the Advisor dialog open while working with your data, so you can return to try another tool or App with your current data


Perform peak fitting/deconvolution with a friendly interface.
Search from Start menu of Origin 2019 and download it


Design an experiment, fit a model to experimental data, and find best factor settings that optimize responses.
Search from Start menu of Origin 2019 and download it


Decompose observed mixed signals into sub-components which are assumed to be independent from each other. Input data can be either columns or matrices.
Search from Start menu of Origin 2019 and download it


Import images from LSM files.
Search from Start menu of Origin 2019 and download it


Fit Gaussian mixture models and cluster test data.
Search from Start menu of Origin 2019 and download it


Object identification and measurement on image.
Search from Start menu of Origin 2019 and download it


Perform global fit and share parameters between different functions.

Search from Start menu of Origin 2019 and download it


Help to prepare a graph for publication.

Search from Start menu of Origin 2019 and download it


Align peaks of spectra by shifting, scaling, clipping and inserting data.

Search from Start menu of Origin 2019 and download it


Interface

A Start Menu button has been added to the bottom left corner of the Origin interface.


The New Workbook dialog allows you to:



Support Numeric Units, pi, km etc in worksheet and graph


Define Preview of Book and Graph Templates

When saving book or graph templates, user can specify his/her own preview image. 

This also works when saving Workbook Window as OGWU or saving Workbook as Analysis Template OGWU 


Add Sparklines button on Columns toolbar

Click it will add sparklines on selected columns.


Help: Origin Central is renamed as Help: Learning Center.

Under Help: menu, Origin Central... is renamed as Learning Cener...

There are only 3 tabs

  • Graph Samples
  • Analysis Samples
  • Learning Center


Reorganized Help: Open Folder to open useful folders:


Adds some new graph types to 2D and 3D Graphs toolbars.


SCN icon improvements


Easy way to pick a color and get its HEX value.

X-Function Colors is added.

Run "colors" in Script window. Colors dialog will open for user to pick a color.

Click OK. Hex value will be dumped.


Project Explorer Improvements


New mechanism to show information to user such as free upgrade to new version

In the 1st few instances of Origin, you will see the following notification on upper-right corner of your Origin. It will fade away after 10 seconds. It's for testing our new way to notify user of future release. The link goes to wrong location. U can ignore that.


Improvements on By Points tab of Color control in toolbar and dialogs with applicable color controls.


Reorganize and reduce Help menu entries
Reorganizing and also regrouping the Help Menu


Select multiple layers by clicking+Shift on the layer icon on the graph
Press Shift+click on layer icon to select multiple layers on the graph.


Graphing

Data Visualization Enhancements

Data Point Tooltip


Data Highlighter


More Line Plot Styles


Better Default Numeric Display Format For X Y Z in Tooltip

Data Tooltip display custom format, following case covered:

  1. User unit
  2. Engineering
  3. DMS
  4. PI
  5. Percent


Pick point tool

When mousing over a data point, data point tooltip shows. Right click in the tooltip and choose Pick Point to enter picking point mode.

Double click or single click +Enter key to keep on picking points. Press ESC to finish picking points. A output sheet will be created with pointed points for further analysis. 


New Graph Types

Trellis Plot with Double-Y Axes


Parallel Plot



Cluster Plot

Known Issue: Slow when there are many panels.


Row-wise Line Series with Error Bars

When data is organized row wise, choose Plot: Line+Symbol: Row-wise to plot it.

  • YError column is supported.
  • X info. can be put to column label rows.


Contour with Categorical Z Values

If Z column is categorical, when choosing Plot: Contour: Contour with Categorical to plot it.

The graph will be plotted with color scale for each category.


Heatmap with Labels

Choose Plot: Heatmap: Heatmap with Label to directly plot a heatmap with Z values showing on each cell.

Customize the label on each cell on Labels tab of Plot Details dialog. E.g. Set decimal digits to display, etc.

Choose Y or Y, etc. from Label Form dropdown list on Labels tab to show  X or Y value as label.


Tetrahedral Scatters/Lines/Line+Symbols

For XYZZ data, Origin can normalize each row and plot in tetrahedral (Pyramid) coordinate system.


Violin Plot


Stacked Histogram


Grouped Scatter Plot


Graph Customization

Row Title for Tick Label Table


Support %(CRLF) in Legend to wrap text

This works on Legends/Titles tab of Plot Details dialog and Update Legend dialog.

First set Translation mode to be Custom. Then specify the syntax with %(CRLF) in between.


Legend Symbol context menu is added
Right click legend in graph and choose Legend → A quick way to go to Symbol tab of Legend Properties dialog to customize symbol part.


Legend Symbol Width scale factor on Symbol tab of Text Object - Legend dialog
Easy way to set line or line+symbol kind of legend longer or shorter.  There was Legend Symbol Width control in Plot Details dialog for this in the past but hard to find. 


legend.align=1 by default for Legend
It's set to 1 by default so legend will be aligned to left properly even after modifying the text.


New Legend for Fill Area Plot

Both above and below colors are supported in legend.

In the past, only above color was supported.


Image Plot should have missing value support similar to contour
Add Missing value control for Image plot.


Enable vertical auto position for box chart label
Add Auto Reposition to Avoid Overlap checkbox in Label tab.


Display the median value in box chart
Add a Median check box to show Median value Label


Customize outliers in box chart
In Plot Details dialog, if Outlier is checked on Box tab, then Outlier tab appears for outlier customization.


Longer minus sign in Graph


Rename plot group's long name in Object Manger

Right click group node, e.g. g1, g2 and choose Rename to give a meaningful group name.

Such group long name shows in

  • Data menu
  • Layer Contents dialog when mousing over group name
  • Labtalk commands are added to set and get group name:

    set %C -g1 Name; // %C must be Group Head get %C -g1 Name;



Object Manager: Data manipulation related to grouped plots

Usually when multiple data is selected and plotted, they are grouped so different colors are assigned to each pot.

Right click a plot in the group in Object Manager and choose Remove, the plot will be removed from the group. In the past, the whole group is removed.

This also works if you single click twice to select a plot in a group on the graph and then choose Remove

There is also Set as Group End context menu. When it's selected, all plots below it will be isolated from the group. 



Object Manager: Move Plot to Other Y Axis


Object Manager: Move a plot from one layer to another by dragging in Object Manager

Drag a plot in Object Manager to another layer in Object Manager and release the mouse.


Edit Range supports specifying X values and an Apply button

User can right click a plot and choose Edit Range context menu to edit the display range.

In the past, user had to specify by row index. In Origin 2019, user can specify x range. 

Apply button is also added.


Support 3-Color Limited Mixing for Color Mapping


Support Categorical legend for 3D xyz bar plot
Before Origin 2019, categorical legend isn't supported in 3D xyz bar.


Show Major tick at min and max of axis


Support Custom Display Formats for Contour Labels


Smith Chart handles negative real for z
@NRSC = 1 to disable this change


Display 24:00 as 00:00 in time data

Added a system variable @DSRS to specify if display 24:00 as 00:00 on Axes tick label. By default @DSRS = 1, means display 24:00 as 00:00, can also turn it off by setting @DSRS = 0.


Add independent color scale on layout window
When adding 3d or contour graph with color scale into layout window, the color scale is very small in each graph. In Origin 2019, you can add an independent color scale object in layout and customize it to match the color scale in graph.


Axis dialog to support Custom Numeric format
Easier way to enter From and To, special ticks, reference lines and break, etc. in axis dialog. Allow user to type 0 and 2 which will refer to 0 and 2 pi. The same issue exists when set Major Tick type as By Custom Positions; Special Ticks, Break, and Reference Lines tab.


LabTalk set command for custom increment list more support

Newly switches are added for set command to set custom increment list for color.

set %c -cuf XXXX; // fill color of pattern
set %c -cus XXXX; // edge color of symbol
set %c -cusf XXXX; // symbol fill color


Need 4 directions margin controls for fit layers to page
 Support left right top bottom margin for fit layers to page. Note we do not need to modify the gui of fit layers to page, just let the margin setting apply to 4 directions.


Show Master Items on Screen should be default and convert existing
  1.  Allow any object to be skipped as master items
  2. Apply page size to all
  3. Allow rotate from Landscape to Portrait
  4. LT template saving needs to dump message


Support more than one custom incremental lists for one property of one plot
Support more than one incremental lists for one property(currently is color or pattern) of one plot. User could ctrl-click to edit the increment list in fly-out to arrange elements. 


Smith Chart improvements requested by Michael Lehnert Additive
  1. Support zoom
  2. Data reader supports more results
  3. Handle negative real for z


Show Categorical values in Color List, Shape List, Interior List tab

Add a 2nd column "Categories" in the following tabs and increment editor dialog:

  1. shape list tab
  2. interior list tab
  3. color increment editor dialog
  4. pattern increment editor dialog
  5. shape list tab of 3D bar


2d Vector graph should also support Scale Length with Magnitude like 3D vector
 Support Scale Length with Magnitude for both 2D Vector XYXY and 2D Vector XYAM. Note 2D Vector XYAM have Magnitude control to modify magnitude, the Scale Length with Magnitude should base on the modified magnitude. 


Speed issue when there are too many panels

Limit the number of panels. System variable is @nop. The value of nop is 50 by default.


Support adding color scale on layout window
Support adding independent color scale to layout window by Add Color Scale button in add object to graph toolbar.


Contour label consider custom boundary
When custom boundary is on, Contour label will consider boundary now. Use @TCBL=0 to disable the feature


Line Cap Control for Plots like Line and Column

Add a new system variable to @LCP to control the end of lines for Line+Symbol plot. 

  • 0: round (default value)
  • 1: square
  • 2: flat


Support number of table rows =10
Now the maximum of table row rises from 5 to 10. And Grouped Box/Column plots also support number of table rows to 10.


Graph: Fix Scale Factors dialog improvements

Set fixed scale factor for all layers so that font, axis, plots and objects will not be resized when layer is resized.

When clicking OK, current size and thickness of all elements are adjusted to maintain current look.

Show smart hint for PD resize as well.


Pick Points Improvements

Improve Pick Points to display and output column-based range string. If range is too long for the dialog to display, show it with a tooltip when mouse over range.

Make data source column range strings in output into links.


Size index column should automatically indicate in bubble scale
A new system variable is added: @BNLP .It controls the auto-nested layout percent of bubble size. The default value is 20, which means when the bubble scale is larger than 20% of the whole layer in size, its layout will be switched to Nested from Linear if you renew/add a bubble scale for a size-indexed scatter/line+symbol plot.


Auto Fill/Distribution Curve/Line Color

Add Auto option for Box, Column and Bar graph's pattern fill color. When Auto is on, Fill color is slightly lighter than Border color. A new system variable @PFACF is introduced with default value as 65. Auto Fill color will be lighter when number increases. 


Auto option for distribution curve in Box chart and Histogram also changed to follow the same logic. And a new system variable @PDACF is introduced with default value as 30. Auto distribution cuve color will be darker when number increases. 


Support subset for Scatter Plot
Subset is available for scatter plot in Origin 2019. When X is <autoX>, Spacing tab will show in Plot Detail dialog with Enable Subset Option, with option By Size and By Column. The new plot type Grouped Scatter-Indexed Data is base on this feature.


Worksheet

User Parameter Row Formula


Worksheet Conditional Formatting: Highlight

Select a range of cells or column(s) and color cells that match rules.



Worksheet Conditional Formatting: Duplicates

Select a range of cells or column(s) and color cells with duplicate values.



Worksheet Conditional Formatting: Heatmap


Conditional Format Manager
Choose Worksheet: Conditional Formatting to manage and edit ranges with conditional format.


Auto fill column label row contents to the right

Double clicking the bottom-right corner of the cell with formula in Column label rows. The formula will be autofilled to all cells to the right.


Column List View

Choose View: Column List View menu to view a list of columns with associated metadata and sparklines. Data cells are not displayed. You can select column(s) in this list view and perform the usual graphing and analysis operations.



Copy non-continuous rows
Before Origin 2019, when selecting non-continuous rows and copying and pasting, the unselected rows in between were copied/pasted as well.


Improve Mask cells by condition to support noncontinuous columns and row ranges
Highlight noncontinuous columns or row ranges, select menu Column: Mask Cells by Condition to open colmask dialog, masks cells by your condition.


Support Hex numbers
  • Custom numeric display such that hex numbers can be used in worksheet cells/columns natively, without using Hex2Dec kind of conversion like in Excel. In Column Properties, set Display as Custom and then set Custom Display as %X or %0<#hexdigits>I64X e.g., %012I64X means 12 hexdigits. X can be in lower case.

HexDisplay.opju  demonstrates the power of using Custom Display Format of Numeric, as well as the various improvements



Custom numeric format more works
  1. Improvement for Latitude Longitude display format.
    General syntax is now like this:
    D[Space][M[S]][F/D][n] [EW/NS[B]]

    New:
    F/D: F to indicate not to include symbols and space is always inserted. D to indicate only exclude last symbol.
    EW/NS: EW for longitude, NS for latitude
    B: before the numbers. if not specified, will be after.

    Example: For decimal degree of latitude -3.03423

    DMD3 NS -> 3° 02.053 S
    DMS1 NSB -> S 3°02'03.2"

  2. Support direct editing in custom numeric format using Hex.


Numeric allow percent (%) and engineering notation
  • Type 12% will convert it into 0.12 automatically. You can disable it by system variable: @cap=0
  • Convert Percent (%) to Number when Copying or Importing ASCII or Excel Data with %
  • Type "1k" in a cell, then convert column to Numeric format will change it to 1000 automatically.


Copy and Paste Filter condition support
User can select the Copy Filter from filter's context menu or select a filter condition in Filter cell and Ctrl+C to copy a filter, and then paste it to other column(s).


Press and scroll mouse wheel to view data



Split worksheet improvements
In Split Worksheet tool, add a new option "Retain 1st N Columns" for "By Number of Columns"/"By Column Label" split mode to keep the 1st N columns in the splitting worksheet result.


Treat missing as blank Improvements
  • Missing values will show as blank in worksheet.
  • When importing excel file with empty cells, or copy and paste data with empty cells from Excel, 
  • Before Origin 2019, when copying some data with blank rows above it and pasting it to new column, blank rows were removed. In Origin 2019, they are kept.
  • If there are empty cells above the data, below data or within data range, click on it, status bar shows <i1:, >i2:, or nothing correspondingly. These empty cells will not be included in calcuation, statistics. 
  • When selecting a cell outside the data bound, status bar will show "<i1: "(begin) or ">i2: "(end).
  • Worksheet cell background color show differently if outside i1 i2 by default. There is a checkbox Indicate unused cells with a shaded background in Workbook Properties dialog. System variable @COR determines the darkening intensity.
  • i1 starts from 1st row unless set otherwise.
  • Delete data on last row will shrink data size (i2 updates)
  • Ctrl+delete to add missing value to a cell, in cases that user wants to make sure each column has same length. 



Masked status kept when copying and pasting data.

After pasting data into new sheet, masked data will be still masked. In the past, masked status was not kept.

A new system variable @CPM has been added to control the behavior, default value is 1.
Note:

1. Paste Transpose, Paste Link, Paste Link Transpose will not paste mask status.

2. Copy (full precision) will not copy the mask status.


Create Subset Sheet context menu to extract selected rows to a new sheet.

After manually select multiple rows or select multiple rows based on data highlighting feature, right click the selected rows and choose Create Subset Sheet context menu

Corresponding X-Function: wcopy.


Add "1 000.0" as numeric separators in Tools: Options dialog.
In Tools: Options dialog, a newly entry "1 000.0" is added for Numeric Separators.


New XFunctions to join columns by plot designation
A new X-Function coljoinbydesig is added to concatenates columns by plot designation. Right now, it's only available by script access.


Analysis

Block Recalculation



Hide Recalculation Locks on the graph

For analysis done on each plot, a lock is created under layer icon. If there are many locks, it's hard for user to view the graph.

Choose View: Show: Lock menu to uncheck it to hide locks in graph window.

Labtalk page property page.lock=0 to hide it.


Set default node's shrink/expanding status on hierarchical result sheet for each analysis

User can right click any node on result sheet and choose Save Node Configuration to save default node status of the analysis. Next time when you do such analysis, it will used the saved configuration. 

  • Useful feature for you if you want to print/export consistent reports from analysis
  • Each analysis tool can have its own default node configuration.


Better Batch Processing with Mulltiple files in Analysis Template

If user has multiple data files imported into multiple sheets but also have other reference sheet, etc., Origin 2019 can better detect import data worksheet and only import to them when doing batch processing. 

E.g. user import 3 files into 1st 3 sheets. 4th sheet is a reference sheet, some analysis is done and analysis template is saved.

When using such workbook as analysis template for batch processing 6 files, first 3 will be processed together; second 3 files will be processed together. 


Labtalk command nlbegin support to pick up error bar when fitting from graph
Example:
Active a plot with error bar then run the following labtalk script:
nlbegin func:=gauss; nlfit; nlend 1;


Support to define both 32bit and 64bit External DLLs in a fdf file
Different dll files will be loaded by the same function if it's name follows the below rules:
32bit: DLLname.dll
64bit: DLLname_64.dll


Support threshold as a certain value in peak finding

Support Peak Filtering method in PA

 


Use new Window View for preview on more analysis tools

Below analysis tool support:

  1.  XYZ (Log) Gridding
  2.  IIR Filter

 Matrix/Surface Fit


Add Excel Bicubic interpolation
  1. Rename the current Bicubic method in 2D Interpolate/Extrapolate tool to be "Bicubic Convolution".
  2. Add option "Bicubic Lagrange" (enum as "lagrange") as the last one in Method combo.


Output Adj. R-square and Pearson's r of a scatter matrix plot to a result sheet.
Origin 2019 added "ScatterMatrixStats" worksheet to arrange Adj. R-square values and Pearson's r values of scatter matrix plot.


Set column as categorical for analysis tools related to grouping
If a column is mostly text and the column is used as grouping column for analysis tools, Origin will automatically set it as categorical so you can easily adjust result sheet orders.


Output Adj. R-square and Pearson's r of a scatter matrix plot to a result sheet
When Pearson's r or Adj. R-square is checked in Plot Scatter Matrix dialog, a new result sheet named ScatterMatrixStats will be created, with all Adj. R-square values and Pearson's r values in it.


Import and Export

Dialog Theme context menu Improvements for Import tools


Support Date Time Data with higher precision

Add three system variables:

1. @DSP: a project property, the date system in current project

  • 0: the current date system, +12 hours off from julian day system
  • 1: julian day
  • 2018: 2018 date system, 0 at 00:00 on Jan 1 2018

2. @DSO: the actual offset for the current date system, in day

And also, when the date system is 2018, Import Wizard support more higher precise date data, for example: When import time data like "2/5/2040 15:59:59.994983" using Import Wizard, can set Custom Date Format as "MM'/'dd'/'yyyy HH':'mm':'ss'.'######" to import.


Check new LibXL update
Updated the new LibXL version 3.7.1 to Origin, so that Origin 2019 will support importing more higher version Excel files.


Import Wizard Support relative OC File Path for user defined type
Import Wizard Support relative OC File Path "<App Folder>" for user defined type.


Add system variable so that import with "Replace Existing Data" will really replace existing data

Added a system variable @IRE for import Excel file with "Replace Existing Data" Import Mode.

@IRE = 1(default): Replace the existing sheets in the active Workbook from the active sheet on.

@IRE = 0: Only replace the active sheet, and create new sheets to import following Excel sheets.


Data Connector for SQL
Added a system variable @sqli= to determine whether the menu and the tooltip on the DB icon in the top left of a worksheet are enabled. By default it is 0.


Support import HEKA newest instrument model version 1000
Support importing newer HEKA file, up to version 2x90.3.


FAMOS import gets error about header not readable
Support importing newer FAMOS files that have the keys "NL" and "NV".


Improve TDMS Import to make it work with Batch Processing
Improve Batch Processing to support TDMS files.


Ctrl+G hotkey to open Export Graph with previous settings
Hotkey CTRL+G opens Graph Export dialog with <last used> theme. It used to open with system default theme. 


Add Zooming to expGraph Image Pane
Add zooming to image panel of expGraph that allows for zooming when raster is exported file type.


Programming

Support latest R 3.5.0


Provides LabTalk functions for Linear Fit


More LabTalk/SCV Functions Support

More LabTalk/SCV functions are supported (or improved) e.g.,

  • Integer-handling functions: Ceil(x), Floor(x), GCD(x1, x2,...),
  • Convert(xa,xb)
  • Engineering functions: Base(), Decimal(), BitLShift(), BitRShift()
  • Math functions: Combina(number, number_chosen), Permut(number, number_chosen), Permutationa(number, number-chosen)
  • Complex functions: Imcosh(c), Imcot(c), Imcsc(c), Imcsch(c), Imsec(c), Imsech(c), Imsinh(c), Imtan(c)
  • Financial functions: pDuration(rate, pv, fv), RRI(nper, pv, fv), Effect(nominal_rate, npery), Nominal(effect_rate, npery)
  • Statistical functions: Maxifs(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...), Minifs(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
  • Miscellaneous functions:

    • IfNA(value, value_if_na), xor(logical1, [logical2],…)

    • if(con,val_true[,val_false]), if(con,val_true$[,val_false$])$
    • ifs(con1, d1[,con2, d2,]...[,con40,d40]), ifs(con1, str1$[,con2, str2$,]...[,con40, str40$])$
    • switch(expression, val1, res1[,val2,res2]...[,val39,res39][,default]), switch(expression, val1$, res1$[,val2$,res2$]...[,val39$,res39$][,default$])$
  • TextJoin(StringArray|String delimiter$, bool empty, StringArray text|String text1$,...)$
  • IsFormula(string ref$)


Improve Cell() function to get actual cell display string
Example: Enter 0.5 in the first cell of col(A), format as Time format. Now it shows "12:00". Execute "cell(1,1)$ =;" will return "12:00", while it returns "0.5" in previous versions.


command to create OPX file

InitFromIni method is added to OPXFile class to support using OriginC function to create app, so that user can easily creating opx without opening package manager dialog. this will be useful if user execute origin from command line or a windows BAT files.

note: this method require a source ini file which including all settings in package manager dialog.

Example:

#include <Origin.h>
#include <../OriginLab/OPXFile.h>
int test_ini_to_opx()
{
	OPXFile opx;
	int err = opx.InitFromIni("opx_IEVer.ini");
	if( err == 0 )
	{
		if( !opx.Save() )
			printf("Failed saving.\n");
	}
	else
		printf("InitFromIni error %d\n", err);
	return 0;
}


HTML Mode for Notes Window

Support HTML mode for Note window:

1 . Labtalk is added to provide access to the active note page:

  • note.text$: get/set the text of active note
  • note.readonly = 0/1: switch readonly mode, default=0
  • note.syntax = 0/1: default=0, plain text, 1 means HTML syntax colored.
  • note.view = 0/1: default = 0, text editor, 1 means render with HTML browser

2 . Embed Various Origin objects into Note page's HTMLIntroduce a new mechanism for user to insert Origin Graph, Cell, Table(from report sheet) and Matrix image inside note window's HTML mode. the syntax will be like this: 

<ANY_HTML_TAG data-OLink="OriginLink">

 For example, to insert a graph preview to a note window, you should use graph type. e.g.

<div data-OLink="graph://graph1"></div>

See following table for the type of responding Origin objects:

3 . HTML Export As Web Page: Added a new menu on Note window's title bar, label as Save as Webpage..., this menu will only be enabled when the Note is currently in HTML mode.



Add GraphLayer::InsertPlot(int nIndex) method

Added an OC function to reorder the plots in Graphlayer.

int GraphLayer::ReorderPlots(const vector<uint>& vnIndices, int c1 = 0, BOOL bUndo = FALSE);

  • vnIndices: Specify the new order of the plots.
  • c1: The indice of the starting plot.
  • bUndo: Specify if support undo.


Big Integer and the Bit Operations Support

LabTalk now supports big integers which are higher than 32bit values (up to 52 bits), and their bitwise operations:
Conversion to an integer: int(), nint(), ceil(), floor()
Bitwise operators: (&(AND) and |(OR))
Bitwise functions: BitAnd(), BitOr(), BitXor(), BitLShift(), BitRShift()
  for example:
    i=hex(F1101010101);
    j=hex(F2010101011);
    Dec2hex(bitAnd(i,j),12)$=;     //==>0F0000000001
    Dec2hex(bitOr(i,j),12)$=;       //==>0F3111111111
    Dec2hex(bitXor(i,j),12)$=;      //==>003111111110
    Dec2hex(bitLShift(i,3),12)$=; //==>788808080808
    Dec2hex(bitRShift(i,3),12)$=; //==>01E220202020


OC and LT access to Dataset Storage

Support LT and OC ways to the size of Dataset Storage, for example: Add a Dataset Storage and then run following code to get size:

LTlist -st;

OC: GetBinaryStorage(NULL, NULL, &nSize);


Improve JSON::FromString() & JSON::ToString()

For JSON::FromString(): support converting Javascript array to arbitrary Origin C vector types, for example:

string strvs = "[\"hello1\",\"hello2\",\"hello3\"]";

vector<string> vs;

JSON.FromString(vs, strvs);

For JSON::ToString(): support convert Origin C vector to Javascript array, lfor example:

vector<string> vs = {"Chris", "Zheng", "Aviel", "Hideo", "Yiming"};

string str;

JSON.ToString(vs, str);


Build OriginExt for more Python Versions
Build a new OriginExt for Python 3.6 version.


Support inserting a link to a matrix book or sheet

Syntax:

  • matrix://MBookName: Insert a link to a matrix book, given by MBookName, so the matrix book will be displayed in the current worksheet cell. 
  • matrix://[MBookName]MSheetName: Insert a link to a matrix sheet, given by MSheetName, so the matrix sheet will be displayed in the current worksheet cell. 

(Note: Insert a link to a matrix object syntax is matrix://[MBookName]MSheetName!MatrixObjectName, which is already supported before Origin 2019.)


New worksheet switch to select column label row in worksheet

Syntax:

worksheet -sl c1 r1 c2 r2


Need export a function to convert the date value from/to system time

Added two functions to convert the date value from/to system time for inner python: Date2datetime() and Datetime2Date()

For example:

import PyOrigin
dateT = PyOrigin.Date2datetime(2458310.5811)
date = PyOrigin.datetime2Date(dateT)


OC font file path

Added a new OC function to get font file path:

int okutil_get_font_file_names(StringArray *psaResults, LPCSTR lpcszFontName);

psaResults: Return all the font file name.

lpcszFontName: Specify the font name,


OC functions wanted for Batch Plotting

Added two new OC functions for batch plotting:

int GraphPage::GetDuplicateWithData(StringArray &saItems, const DuplicateWithDataInfo& info);
int GraphPage::AddDuplicateWithData(StringArray &saItems, const DuplicateWithDataInfo& info);


OriginC OC JSON add Tree support

Improved OC function JSON::FromString to support converting JSON string to oc tree, and added a following OC function to get tree vector:

BOOL TreeToVector(TreeNode& tree, vectorbase& vv, LPCSTR lpcszTagName = NULL)


COM interface to allow full search ability for Origin Project Files

In Find in Project dialog:

  1. The keyword to search is highlighted in the found item.
  2. Show Comments on the pop up preview dialog.
  3. Show Graph preview for the graph item.

COM Interface:

  1. Added new Origin.Application COM class OriginFinder, more information see http://wikis/ocwiki/index.php?title=Category%3AOriginFinder_(OriginCOM).


OC issues related to getting data from the internet

1. New following OC function to read text file:

BOOL ocu_read_text_file(LPCSTR lpcszFilename, string* pstr);

Parameters:
    lpcszFilename
= [input] full path file name
    pstr
= [output] resulting file content as a string
Returns:
    FALSE if file not found

2. Improved OC function Column::SetFormat to support setting column custom format, for example:

void setcolumnformat_ex()
{
    Worksheet wks = Project.ActiveLayer();
    Column col1(wks, 0);
    col1.SetFormat(OKCOLTYPE_DATE, "yyyy'-'MM'-'dd");
    
    Column col2(wks, 1);
    col2.SetFormat(OKCOLTYPE_TEXT_NUMERIC, "DMS2");
    
    Column col3(wks, 2);
    col3.SetFormat(OKCOLTYPE_TIME, "hh mm ss'.'##");
}


New OC funtion to get list of installed fonts

Added following  OC function to get the name list of installed fonts:

int GetFontNames(vector<string>* pstrNames, BOOL bIncludeDefFont = TRUE);
Parameters:
pstrNames[output]:font name list.
bIncludeDefFont[input]:whether include origin default font.
Returns:
Count of font names


http_get_str Fails to Return Response Body as String w/ Certain URL

Added following OC functions:

int okutil_http_download(LPCSTR lpcszURL, LPCSTR lpcszFileName, int nConnectTimeout = 0, int nResponseTimeout = 0, BOOL bIgnoreCertError = FALSE);

int okutil_http_get(LPCSTR lpcszURL, string *pstrResult, int nConnectTimeout = 0, int nResponseTimeout = 30);

int okutil_http_post(LPCSTR lpcszURL, LPCSTR lpcszRequestData, string *pstrResult, int nConnectTimeout = 0, int nResponseTimeout = 30);

DWORD okutil_http_error();

DWORD okutil_http_status();

More information see http://wikis/ocwiki/index.php?title=Category%3ANetwork_(global_function)


New OC method to scale the font size and line thickness when page size changes

Improve LT command "page -AFU -newWidth/oldWidth;" to support scale the font size and line thickness when change page size by oc way.

For example:

void SetPageSize()
{
	GraphPage gp = Project.ActiveLayer().GetPage();
	Tree tr;
	tr = gp.GetFormat(FPB_ALL, FOB_ALL, true, true);
	double dOldWidth = tr.Root.Dimension.Width.dVal;
	tr.Root.Dimension.Width.dVal = 5;
	tr.Root.Dimension.Height.dVal = 5;
	if(0 == gp.UpdateThemeIDs(tr.Root))
	{
		gp.ApplyFormat(tr, true, true);
	}
	
	string strScript;
	strScript = "page -AFU -" + 5 + "/" + dOldWidth;
	LT_execute(strScript);
	strScript = "menu -e 33027;";
	LT_execute(strScript);
}


Build OriginExt for more Python Versions
Improve OriginExt packager to support calling Origin COM for python 3.6.


HTML Table support internal and from OC

Support getting HTML table by OC way, for example:

void	html_test()
{
	OHTML doc;
	BOOL bRet = doc.ReadFile("c:\\temp\\html\\test.html");
	if( bRet )
	{
		StringArray headers, data;
		int nTables = doc.GetTableCount();
		for(int table=0; table<nTables; table++)
		{
			string strCaption;
			bRet = doc.GetTableCaption(table, strCaption);
			int nRows = doc.GetRowCount(table);
			int nCols = doc.GetColCount(table);
			for(int col=0; col<nCols; col++)
			{
				bRet = doc.GetColHeader(table, col, headers);
				bRet = doc.GetColData(table, col, data);
			}
		}
	}
}


Code Builder should be able to inspect the values declared inside the loop

Support to detect the variables inside the loop and list them in the variables list when debug in Code Builder.

For example: debug the following LT script in Code Builder.

doc -e LB 
{
  double x = 1.5;
  Col(2) = Col(1) * x;
} 

It will show x variable in Variables window.


Tree-like datatip in Code Builder to show variable structure for debugging
When debugging OC code in Code Builder,and move the mouse over a variable name, a simple tooltip pops up to show the value of it.


Color Picker XF needed

 Add new XF, name = colors

OC added as

bool ColorsBox(COLORREF* pcr);

LT command as

ed -c [color]

LabTalk function needed to convert ocolor to RGB,

int ocolor2rgb(int ocolor);




More work on @MRU
System variable MRU support enable user template (MRU=8) and recent file (MRU=16)


GetN GETN_OPTION_NUM_FORMAT to support Custom Numeric Format

Added GETN_OPTION_NUM_FORMAT function to custom Numeric format, for example:

#include <GetNbox.h>
void test()
{
    GETN_TREE( treeTest )
    GETN_STR(test1, "Str Value", "junk")
    double xx = 0.5*PI;
    GETN_NUM(testVal, "PI Test", xx)
    GETN_OPTION_NUM_FORMAT( "* \"pi\"" )
   
    if( GetNBox( treeTest ))
        out_tree( treeTest );
}


Installation and Licensing

Customize Installation and File Path

Config.ini under setup.exe folder to

  1. prefill settings in installation. This is useful for group users. Manager can set Serial number, Installation Path, install 32 bit or 64 bit, etc. in config.ini file. Subsequent users just run setup.exe to do a silent installation. Together with PK.txt under setup folder, IT can auto install and license Origin.
  2. preset license information, e.g. flexnet server name and port number.
  3. preset User Files folder, Apps folder, AutoSave, backup, etc. folders so no dialog opens on first launch of Origin. 


"About Origin" dialog improvements
  1. Added the "Check Available Licenses" button to get license information for Individual License.
  2. Added the "Citation Text" button to dump a string for citation to messages log.


Others

GUI changes in miscellaneous tab of tools options dialog
  1. Add Proxy Setting control.
  2. Move Bisection Search Points to Graph tab.
  3. Move Footnote Size Ratio to Text Fonts tab, and rename it to Footnote Size Ratio in Analysis Reports


Backup, Autosave, Unsaved from User Files Dialog
  1. If user has already customized their paths (customization can be via registry per Tools Options, or can be via config.ini), then DO NOT show any choices. Just use the customized locations
  2. Otherwise show the following radio choices:
  • Same level as UFF
  • Under User Files Folder (UFF)
  • Under "%s" // (show actual default root path)


Shortcut window improvements
  1. Shortcut window keep own state (position, size) if adjust the source window


Menu toolbar locking


Origin 2018b Features

Origin Interface

Active Window is indicated by a frame around the window. Color and line style can be customized.

When there are many child windows, it's hard to tell which window is active.

A magenta frame is added around active window title bar 

System Variables:
@AWI = 0; // No Indicator
@AWI = 1; // default, solid line, outside window frame

@AWI=2;; // title bar frame
@AWI=3; // title bar top line

and add 4 to use thin line 
and add 8 to use dashed line

For example:
@AWI=9; // thick dashed line, window frame


@AWC is for indicator color as an RGB integer.

For example:

@AWC=color(255,0,0);


How to control which window display in File Explorer thumbnail and Preview

System Variables:

@SPM=1, PriorityMatrix

@SPM=2, PriorityWorksheet

@SPM=3, PriorityHolderImage

@SPM=4, PriorityMatImage

@SPM=5, PriorityHolderGraph

@SPM=6, PriorityGraphNotOpen

@SPM=7, PriorityGraph

where "Holder" refers to a Graph or Matrix added to a Workbook as a Sheet, and if a Matrix, View must be Image Mode (View: Image Mode).

The variable determines if a given window type will be elevated to "Must Use if Active".

The value of @SPM is stored in the Windows registry and will persist across Origin sessions until it is again changed.


Extra large icon view for workbooks and matrices in Project Explorer and Windows File Explorer
  • Extra large icon view and Preview of workbook in Windows Explorer.
  • In Project Explorer, Extra large icon view and tooltip.


Hide preview of OPJU with password protection
If user uses Tools: Password Protection to set password and then save the OPJU, preview of the OPJU will be hidden in Windows Explorer.


Show both Long Name and Short Name in List and Icon Views in Project Explorer

In the past, if there was long name in window, only long name showed in List or Icon views of Project Explorer. In Origin 2018b, you can check Show Long and Short Names to both names. 



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

     


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.


Plot menu icon size can be scaled by a factor from 0.5 to 2
Use system variable @pps to set scale from 0.5 to 2, zoom in or out the Plot menu icon size


Graphing

Labels, Legend, Color Scale and Bubble Scale, Graph object

Scale factor for fill pattern entries in legend. Applies only to Geology patterns.

For example, code

 \L(1, PatternScale:p200) 

means set both X scale and Y scale of pattern to 2. 


More flexible color scale object, including arbitrary color scale
  • show color scale for 2d plots colors.
  • show an independent color scale.


System variable to control double-click legend behavior
@LDC=1 -- Double clicking legend opens Properties dialog
@LDC=0 (default) - Double clicking legend goes into in-place edit mode (old behavior in versions before Origin 2018)


More controls added to Bubble Scale
Add Bubble Edge Thickness in Layout tab.


Pie Chart label supports Apply to layer etc
For labels with object name begin with PIE, all the properties except position, text content and programming will support apply to layer/window/folder/project/plot/grouped plot.


Support for label to be attached to data or error bar
We add an option "Error Bar" to "Attach to" combo in Label tab. For Y error bar, it will take effect when position is Above or Below.
For X error bar, it will take effect when position is Left or Right.


No limit for characters of tick labels


Improve arrow object control

Introduce system variable @LCAS, with default value=1. It is used to toggle between sharp arrow and round-head arrow.

0 = round-head arrow, old behavior
1 = sharp-head arrow


Hotkey Ctrl+Shift+Drag to duplicate the annotation object to another data point and add visual feedback when moving annotation


Plot Manipulation

Support Tagging Sheet as Exclude from Plotting Dialog

Some users have a lot of worksheets in project. And it's hard to select which sheet to plot.

In Origin 2018b, User can exclude some worksheets from showing in Plot Setup and Layer Contents dialogs by right clicking worksheet(s) and tag as "Exclude from Plotting Dialogs". 


Easier way to show/hide error bars and data labels from Object Manager


Rename Plot Groups instead of just using g1, g2, ... in Object Manager

Right click g1, g2, ... node in Object Manager to give a meaningful group name. 

Such group name will show in

  • Layer Contents dialog as tooltip
  • Data menu
  • Context menu when right clicking on graph


Support for grouping and ungrouping of data plots in Object Manager

In Object Manager,

  • Right click group node, e.g. g1 to Ungroup.
  • Right click a plot that doesn't belong to any group and Set as Group Begin. Then Origin will find all consecutive plots below it that have same plot type and group them.


Support line style customization for vector graph
Support Line Style option for vectors in polar graph. You can customize the line style through Plot Detail or button.


Option to ignore blank data when deciding column bar plot spacing
Add a checkbox Ignore Missing Data for Column/Bar Width in Graph level's Display tab, so column/bar plot's spacing width will ignore missing value once it's checked.


Allow displaying reference lines on top of data
  1. Add check box in Display tab of PD at Layer level: "Reference Lines on Top of Data"
  2. Add right-click context menu entry to Axis: "Reference Lines on Top of Data"


Support for Stacked Column and 100% Stacked Column plot types in Trellis Plot
Add Stacked Column, Stacked Bar,100% Stacked Column, 100% Stacked Bar to Trellis plot xf dialog Plot Type drop-down list.


Auto option added Colormap rescale modes
Auto is added to list of Rescale modes in colormap tab of Plot Details.


Support Box Chart in Trellis Plot to provide easier way for controlling box charts arrangements from grouped data.
  • Support Box Chart with Panel
  • Enable By Point tab for box chart color and pattern
  • Add Box Chart to Plot Type combo of plot_group


Improve Handling of Date/Non-Categorical Grouping Data in Indexed Group Box Plot
Better support Date/Non-Categorical Grouping Data in Indexed Group Box Plot


Graph Page and Layer

Fit all layers to maximum available page area, including option for margins.

Margin control to fit all layers in graph into page area nicely.

User stories:

  • There are too much white space outside the layer. User wants to make the margin tigher.
  • Some text, axis title, or layer shows in gray area, so they will not be printed/exported. Use this tool to fit them into page siie.


Better legend position when Fitting Layers to Page

Add the option -L to the page -FLS command

page -FLS -L; //fit layers to page so as to leave room on the right side for the legend. No gap between layer and legend.
page -FLS -L 0.03 -m 0.04 //fit layers to page, with space (3% of page) btween layer and legend, margin on edge of page is 0.04.
To use the -L option, the following must be true:
  • Graph contains a single layer.
  • There is one (and only one) legend object.
  • Scale Elements (Format: Layer Properties > Display tab) must be Fixed Factor.


Keep Aspect Ratio check box at Page level, to resize page

This allows user to specify desired page width for publishing, and Origin can then scale the height accordingly to keep the aspect ratio, if this check box is checked.

All elements in the graph will be scaled such that they "appear" the same in the final graph in terms of relative dimensions such as font size etc. MAY NOT work fully yet for elements such as color scale, and for 3D graphs.



New LT command to force all layers to have scale factor fixed but keep the look

Select menu Graph: Fix Scale Factors...to open dialog, and you will allow to set all layers to fixed scale factor value and maintain current look.

LabTalk command is also available,


Customize Layer/Plot/Axes properties across all ayers

By checking what you want to customize together on Layers tab of Page level of Plot Details dialog, and then go to a layer to customize settings, all layers will be customized together.


Easier notation for adding labels when merging multiple graphs, including support for Roman numerals

Set Label Text as Custom and click the dropdown list to see Custom notations.

Notations can be combined, e.g. h$n$ to show #1, #2, ....

a$ (default) – enumerate lower case letters
A$ – enumerateupper case letters
r$ – enumerate lower case roman numerals 
R$ – enumerate upper case roman numerals 
n$ or # – enumerate numbers
h$ – represent #

Graph## – Graph01, Graph02, ...

hsn$ means #1, #2, ....

Labtalk Script example:

merge_graph labeltext:=custom labelcustom:=h$n$;

Tip: Click the > button next to Dialog theme and choose Generate Script, executable Labtalk script will be created.




Enlarged graph using scale-in tool supports multiple overlapped layers

If layers are linked with 1:1 X axis and area, choose Scale In toolbar button and click in graph to create enlarged graph. Plots in all linked layers show in enlarged graph.

 


Integrate Gadget now supports marking of Fill Area under multiple curves


Improve the assignment of columns to layers for multi-panel plots

When number of x cols <= number of layers, use x col as separator to plot into layers; When number of x cols > number of layers, pop up error message: When number of x cols > number of layers, pop up error message. Add X Column" to the "Group By" combo in Multiple Panels by Label tool dialog.

For example, if data is organized as XYYYXYY and user asks for a 2-panel plot, the first three Y columns will be plotted in layer 1, and the last two Y colums will be plotted in layer2.


Page size change to keep same look

Automatically scale all elements similar to the work with fix scale factor.

System variable @PSM controls the minimum change to trigger size update.  Set @psm=100, elements will not resize when changing page size.


3D and Contour

Added Connect 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.


Support total label for 3d stacked column/bar plots


Support more 2D arrow shapes in 3D graphs


Support 2D annotation for 3D scatter plot.


3D XYZ bar graph supports customization of individual bars
Customize pattern, color and labels


Improve preview of 3D OpenGL graphs in dialogs
Better preview in our export graph dialog


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

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


Contour Profile/Image Profile Improvements
Add a Default settings button in Image/Contour Profile dialog. Clicking it will open Default Settings dialog. You can customize Legend Preferences(by Width or Value), Profile Quantity(will only show when source data is virtual matrix and matrix) and Output Profile Data( will only show when source data is virtual matrix)


Axis

Extend arrow at end of axis to show outside of the layer limit
User can set offset of axis arrow so the arrow head is longer than original axis.


Apply changes to axes immediately from secondary dialogs that pop up
1. If user clicks Details button to open secondary dialog, the main dialog will be hidden.
2. Changes on main dialog will not be applied to graph but still remembered.
3. On Secondary dialog, there is Apply button. Click it will apply changes on secondary dialog only.
4. Click OK will apply and close the secondary dialog and main dialog will open again.


Added Alignment/Positioning options for Axis Titles with respect to axis position
Add an new option Offset Relative to Axis: Middle, Begin, End  in Axis dialog Title tab.


Added Rescale Axis option to axis context menu

Depending on X, Y or Z axis you click, Corresponding Rescale Axis context menu will show


Rescale axes of linked overlapping layers

Rescale to show all only rescaled the axis range of current layer in the past. In Origin 2018b, it will take care of linked overlapping layers. Usually Multy-Y plots have such linked overlapping layers. E.g. on one layer, data range is from 2000 to 2005. On the other layer, the data range is from 2001 to 2006. 

Registry based System variable @RML (Rescale Multiple Layers) 

1 – rescale multiple layers

0 - rescale active layer only (old behavior)


Analysis

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

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


Fitting: Accuracy of p-value has been 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


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.


Fitting: Implicit Function now support Integral
Support to define Implicit Function with integral in the Fitting Function Organizer and Fitting Function Builder


Fitting: Sample Curve and Equation Preview images are 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).


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


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 


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.


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


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.


Signal Processing: Unit description added to metadata of STFT result
Support unit output in worksheet result of STFT.


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.

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


Worksheet and Data Processing

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. This option is provided in Worksheet Properties dialog.


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


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.


Stack Columns tool will maintain column plot designation for Other columns
Keep column plot designation for other columns in the Stack Columns result.


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.


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 now. E.g,
countif(a, "A>0") //Before Origin 2018b, must use countif(a, "col(A)>0")

Also, the performance of these functons is improved.


Importing

CSV Import: Added option for starting new rows when importing multiple files
Added a new Import Mode option:Start New Rows option for import CSV tool


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.


ASCII Import:

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.


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. 

System vairable @DCM=1;//disable check merged labels. Then Origin will work the old way before 2018b. Import into empty columns in the unit.


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.



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.


Partial Column Import in impBRUKER dialog

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


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.


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.


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.


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


More wav format wanted
  1. impWav supports importing 24bit .wav file.
  2. impWav supports importing multi-channel .wav file.


Exporting and Presentation

Option to export multiple graphs as a single multi-page PDF file
"Export as multi-page PDF file" checkbox is added in Export Graph dialog to export multiple graph windows together into one Multi-Page PDF file.


Export graphs with PE folder name included in the name of the exported file
We introduce a new keyword like <PE parent1> which refers to the immediate parent folder name.
We can for now support up to 3 levels, so we will support <PE parent2>&<PE parent3>, but show only <PE parent1>-<long name> on GUI for now.


New menu and improvements to quickly set up and apply Master Page elements such as logos and timestamps to all graphs.
New menu item to open and customize Master Page and apply to all graphs.


More options and script commands to customize application of Master Page elements

 1. Any object with name beginning with "NoExport" will be skipped as master items. Use @UPN=1 to disable it.

2. We can use labtalk command to apply active page's width and height to all other pages.

doc -pdad;

This command was made for the button on the master page.

3. Allow rotate from landscape to portrait. The following labtalk command is used.

page -o r

"Rotate" button is on the master page template.
4. "Save" button is on master template.


Little Dialog to control Margin Offsets

When choosing Edit: Export Margin Offset,

1. Show width and height of selected area with unit of page.
2. Enable the rectangle to be draggable and resizeable all of the time


Improve Copy Page for Embedded Graphs
 Embedded/floating graph can be copied as actual Graph, but not an EMF.


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


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.


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.



Some rule changes to batch processing

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.


Support to 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


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.


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

If the embeded 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.



Project and Data Management

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.


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.


Option to default to old OPJ format for saving projects
A new system variable:
@OPJ=
0 Project to use new format and Copy Paste also new format
1 Project to use old format but Copy Page to use new format
2 Project to use new format, but Copy page to use Old format
3 Both will use old format


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.


Customer Report on OPJU issues
Customer‘s OPJU Crashing on load. 


Bottom panel of Project Explorer no longer lists folders

We are working on supporting moving windows in bottom panel to reorder them. If there are folders in subfolder, it's hard to reorder windows. So we hide folder in bottom panel.

  • Folder structure will only show in top panel. 
  • Set system variable @PEF=1 to show folder in bottom panel
  • When mousing over folder in top panel, tooltip will show about folder comments, size, etc. 


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:

@SIC=
0 Save all sparkline images in the OPJU.
-1 Don't save any sparkline images in project.
7000 (Default) If individual sparkline is < 7000 bytes then save it in the project.

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.


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.

@NPP=
0 (Default) Use existing setting in graph- same as old behavior.
1-100 Percentage that must be uncovered before repainting is triggered.
>100 (e.g.101) Only repaint the currently active graph. Do not attempt to repaint other graphs.

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.


Improvements on Converting to Scientific Notation

Some improvements are made:

  • Suppose Upper Threshold to convert to scientific notation is 6. In the past, 1000000 displays as 1000000, while 2000000 displays as 2E6. In Origin 2018b, 2000000 will still display as 2000000. Only values equal or bigger than 1E7 will convert to scientific notation.
  • There was some round off error in the past. To see the problem: Suppose Lower Threshold Power to convert to scientific notation is -3. In the past if the axis is from 0.001 on 10, it will display as 0.001 fine. If axis is from 10 to 0.001 (axis decreases), 0.001 showed as 1E-3. Fixed in Origin 2018b now. Shows 0.001.


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.


Cluster Gadget supports clearing category information


Programming

LabTalk:  New command to turn on audit log for all projects.

new LT command

doc -log1; //turns on for current project with empty password doc -log1 test;//turns on for current project with password = "test" doc -log0 test;//turns off for current project
doc.AuditLog=; //(ready-only )returns 1 or 0 AuditLog is on/off for the current project.

New system variable that is Registry based added
In Script Window, run
@ALOG=1;//turn on Audit log on New project (untitled)

You can also preset this in msi installer script to set registry
HKEY_CURRENT_USER\Software\OriginLab\Origin 9.5b\International\SysV\ALOG
with a DWORD value of 1 


LabTalk: Skip Columns when Plotting and after Plotting

-pc option is added in Worksheet and Set commonds.

//to make plot woksheet -pc plottype template startIndex Increment;
//to modify, %C will need to automatically find group head set %C -pc startIndex Increment
If Increment is a negative number e.g. -N, it means span and plot N plots.

Examples:

Highlight all columns and run
1. worksheet -pc 200 line 2 3 //start from col B, every 3rd col is plotted so i got B, E, H, K, .... in graph.
2. worksheet -pc 200 line 2 -10 //start from column B, span the whole data and pick 10 columns to plot. I got B, O, AB, AO, BB, BO, CB, CO, DB, DO columns plotted.

First plot all data. With graph window active, run
1. set %c -pc 2 3; //start from column B, every 3rd col is plotted.
2. set %c -pc 2 -10; //start from column B, span the whole data and pick 10 columns to plot. I got B, O, AB, AO, BB, BO, CB, CO, DB, DO columns plotted.


LabTalk:  Script access to better support install and uninstall of Origin files that D&D can install

Add the nlsf_install_fdf and nlsf_uninstall_fdf OC functions to install and uninstall fitting functions.

LabTalk Access is supported:

run.section(dofile.ogs, OnInstallFDF, "%Yfitfunc\MyGauss.fdf")
run.section(dofile.ogs, OnUnInstallFDF, "%Yfitfunc\MyGauss.fdf")

Add the template_install and template_uninstall OC functions to install and uninstall graph templates.

LabTalk Access is supported:

run.section(dofile.ogs, OnInstallTemplate, "%YMyGraph.otpu")
run.section(dofile.ogs, OnUnInstallTemplate, "%YMyGraph.otpu")



LabTalk: LabTalk Hex related functions to handle bigger values
  • Improve hex2dec(), hex() functions to support 48 bits integer
  • Support "0x" prefix. E.g, hex2dec("0x10A") returns 266
  • Dec2hex() function support places argument. E.g, Dec2hex(10,3)$ returns "00A"


LabTalk: LabTalk function to converts text to a number

Syntax:

NumberValue(str$[, decimal$, group$])


OC: Better default for index in  GetParameterResults
The default value of second parameter of OC function GetParameterResults() was changed to 0.


OC: Access to get and set LabTalk LT properties of Origin Objects

S2: Support accessing page properties by OC functions:Pagebase::SetProp() and Pagebase::GetProp(), for example:

void test_Graph_Set_and_Get_Properties()
{
	GraphPage gp;
	gp.Create("origin");
	gp.AddLayer("Test");
	double vv;
	gp.SetProp("active", 2);
	gp.GetProp("active", &vv);
	
	return;
}


LabTalk: Support for programming way to control Master Item display

S2: Programming way to view Master Items on Screen LT

page.master = 0, not export the Master item.
page.master = 1, export the Master item, but not view it on screen. page.master = 2, for screen, but ignore if bit 1 not set

However, if page.master = 1,  can use LT script "Menu -e 33096" to toggle viewing Master items on screen, but cannot control it.


LabTalk: New command to remove dividers

 Labtalk command to remove divider:

page -ADX -<opt> dividerindex;


Labtalk command to restore dividers:

page -ADGR;


X-Function: findFiles x-function now supports recursive folder
New variable "recursive" is provided, can set value to 1 to find the files in the recursive folders.


X-Function: More output options for mstats xf
1. add variable i1/i2 to XF quantiles for worksheet;
2. add variable x1/y1/x2/y2 to XF mquantiles for matrix.


Python: API for calling Origin from outside Python
The module name is OriginExt, and only applicable for Python 35. Use pip command to install in Windows Command Line.


OC: Added a parameter for specifying the title of dialog created by "okoc_folder_browser"

Added a new parameter "lpcszInitTitle" to the OC function okoc_folder_browser, and the new parameter is used to specify the title of dialog box, now the function is:

int okoc_folder_browser(LPCSTR lpcszInitDir, StringArray* saFolders, LPCSTR lpcszInitTitle)

The new parameter "lpcszInitTitleis used to specify the title of dialog box, and its default value is NULL.

Example:

#include <Origin.h>
#include <okocUtils.h> void folder_browser_ex1() { vector<string> vsFolders; int nRet = okoc_folder_browser("C:\\test", &vsFolders,"Folder browser"); printf("%d folders selected!\n", nRet); for ( int ii = 0; ii < nRet; ii++ ) printf("Folder%d: %s\n", ii + 1, vsFolders[ii]); return; }


OC: Functions for  Batch Plotting
Added three oc functions:

1. int GraphPage::CanDuplicate(int nWith = CAN_DUP_WITH_ANY);
Suppose a graph is active, use this OC function to tell if this graph is possible to duplicate with new columns, sheets, books.

2. int GetDuplicateWithCols(StringArray &saItems, DataPlot &dataPlot = NULL, int nModifier = PMMT_IGNORE);
Assume a graph is active, use this OC function to get the list of columns which can be used to batch plot the graph.

3. int GetDuplicateWithBooks(StringArray &saItems, int nModifier = PMMT_OFFSET, int nMatchCol = MATCHCOLUMN_INDEX, int nMatchSheet = MATCHSHEET_INDEX);
Assume a graph is active, use this OC function to get the list of sheets or books which can be used to batch plot the graph. If nMatchSheet == MATCHSHEET_IGNORE then Range is Sheet, else Range is Book.



OC: function for Code Builder File Access

Added a new OC function:

BOOL CBFileOpen(LPCSTR lpcszFileName, LPCSTR lpcszSectionName=NULL, int nCntrl = CBF_OPEN);

lpcszFileName: File path and name.

lpcszSectionName: Specify a section you want to go.

nCntrl:

  • CBF_OPEN: Open the file in Code Builder.
  • CBF_TEST_IS_OPEN: Check if the file is opened in Code Builder.


OC: Need better support for accessing embedded matrix via LabTalk and OriginC

Added a new OC function:

int Worksheet::IsHolderSheet(PageBase& pg = NULL);

Check if the Worksheet is embedded page.


LabTalk: Getting the information about the cell link that is in a cell with labtalk

Imporve cell() function to return cell link imformation

  • cell(col,row,1): return cell link type
  • cell(col,row,1)$: return the raw reference string


Labtalk:  function Unique() to find unique members of a column in SCV

Unique(vs, [sort, occurence])

E.g.

Unique(A) – get unique value/strings in column A with ascending order

Unique(A, 2) — get unique values/strings in column A with descending order


Other

Support for naming of custom colors
In Colors dialog which is used to create custom color, a Name box is added to allow user to give the color a name.


Allow using English date format in Chinese/Japanese language setting

This will be useful for user who want to keep using English date format in C/J version

  • rename current "Use English in Reports" into "User English in Reports and Graphs" in change Language dialog
  • Add User English in Reports and Graphs checkbox in Numeric Format tab of tools options dialog


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.


Installed Apps can be updated automatically to make sure they are always the newest version
To make sure the installed Apps are always the newest version, user can turn on App Auto updating by setting @AUA = 1 in system variable dialog.


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.


Option to bring the newly pasted graph object to front


Easier way to modify symbol shape for special point
When customized a special point: 
  • Select a symbol shape from dropdown, will clear the "Custom Construction" checkbox
  • Select "Custom Construction" checkbox, options in custom construction group will affect the preview


Fix Window Properties dialog, GetN Graph preview dialog, and Peak Analyzer dialog show incompletely in High DPI or low resolution


Set Group Folder Location should not require run as admin


Hotkey Ctrl+D to control show tooltip or not


Add a new option to Object Manager
Right click the empty area or Graph level in Object Manager to switch view in order of Appearance or View in Drawing Order.


Origin 2018 Features

Origin Interface

Graph Samples tab is restructured and allow selecting a specific Plot Type category as well as keyword searching.


Images in worksheet cells now be viewed as enlarged popups when running mouse over the cell.

For example, when mousing over the following cells, an enlarged popup image will be displayed.

  • Sparklines cell.
  • A cell with Embedded graph.
  • A cell with Inserted Image from File.

A System Variable @CET is used to control the behavior:

@CET=0, use default size of 250x250
@CET=1 to 29, disable this feature
@CET > 30 is user defined size in pixel, scaled by DPI scale factor


Access to the Character Map in Worksheet cell edit mode.

Double click a cell to enter the edit mode.

Ctr+M or right-click and choose Character Map to insert symbol into cell using the font specified for the cell.

The benefit of this is that it allows actual Unicode characters to be inserted into Label rows, rather than codes used in previous versions of Origin. Hence, then the values in Label Rows are displayed elsewhere, those Unicode characters will be used.


Insert non-keyboard Unicode characters similar to MS Word and other apps using 4-digit code and Alt+X keyboard combination.

To insert a character that is not supported by your keyboard, find the relevant 4-digit Unicode code via Google. Then, when in edit mode, type in the 4 digits and hit Alt+X to convert it to the actual character. Note: If the font for the location does not support the relevant character, it may not display properly even though the character is valid.

This feature works in:

  • Worksheet cells even if rich text isn't enabled.
  • Axis titles, legend, and any regular text label on a graph.
  • Many Origin dialogs that support text entry such as those related to axis title, legend, and text objects. Also dialog like the Find in Projects and others.
  • Notes window.


File: Export: As PDF File...menu added for worksheet

In Origin 2018, File: Export: As PDF File... menu is added.

In previous versions of Origin, Export worksheet as PDF file is an option in File: Export: As Image File... dialog. But is not obvious.



Export Graph...menu shows under File: Export: if there is graph floating or embedded on active sheet. for example:.

Origin 2018, if there is embedded graph in workbook, Export Graph... menu shows under File: Export:

In previous versions of Origin, the user needs to double-click on a floating or embedded graph prior to exporting it. 


Remove the "Yes-No" confirmation dialog about saving changes to "Tools: Options" modifications.

After you make modifications in the Options dialog (accessible from menu Tools: Options) and click "OK" button, the changes will be saved directly WITHOUT the dialog to confirm.


App Central Dialog.

The new App Center dialog (keyboard shortcut F10) centralizes App discovery, installation, without having to leave Origin  and open a web browser (unless you choose to learn more about selected Apps).


Context menu to Hide Color List/Palettes and Show All to restore

Some of the color lists or color palettes may not apply to user. Then user can right click from the color list or palette list to hide it.

Chose Show All to make hidden ones visible again.

This also works for user-defined color list/palettes.


Tooltip Improvements on Color related toolbars
  • When mousing over a single color block, HEX number and (R, G, B) show


Bridge Chart/McKinsey-style waterfall.

Support Bridge chart with total and connecting lines.

  • Coloring bars based on Increase/Decrease and Total.
  • Set Data Indices for Total/Subtotal in Plot Detail: Bridge Chart tab.
  • Show Connect Line and Connect by Subset in Plot Detail: Bridge Chart tab.
  • Select a point in Bridge Chart, right click and you can select Set as Total/Subtotal. After select it, it will append data index to Data Indecies for Total/Subtotal in Plot Detail.
  • New Plot button group in Plot Main Menu: Bridge Chart, Stacked Bridge Chart, Stacked Total Bridge Chart, Horizontal Bridge Chart


Double Y Box Chart.

Plot: Box Chart: Double Y Box Chart menu is added.

In Origin 2018 because on Miscellaneous tab of Plot Details dialog → Graph level, Column/Bar/Box Gap Across layers is checked.

The checkbox used to work for column/bar plot only.

Note: This checkbox is only enabled if

  • layers are all linked.
  • For each linked layer, on Link Axes Scales tab, X Axis Link is straight 1:1.
  • For each linked layer, on Size/Speed tab of each linked layer, Unit is % of the linked layer


Plot multiple line plots with colors mapped to a palette. Corresponding color scale shows in legend.

It was doable before Origin 2018 but needs a lot of steps.

  • Plot: Multi-Y: ColorMap Line menu is added in Origin 2018 to quickly plot it.
  • Easy to change palette.


GUI to Customize Symbols in Legend.
  • Manually create a symbol+line legend entry with many customization options.



Customization symbol on left side of legend box.
  • Dumbell style line+symbol legend.
  • Scaling factor of symbol size, line thickness to be different from plot symbol size and line thickness.
  • Adjust the left part (legend symbol block) width and height.


Simplify Categorical Values Legend Dialog.

The "Combine Elements Indexed by Same Column" checkbox is hidden and on so such elements will always show as combined in Legend.

To bring back the old dialog, set system variable @LCC=1 and reopen the dialog.



Better Hint and Examples in Update Legend dialog.


Symbol like legend for customized single point in line plot and line+symbol plot.

Before Origin 2018, if user customized a single point in line graph, the symbol failed show in legend.

If user customized a single point in line+symbol graph, the special point legend showed as line+symbol.

In Origin 2018, both are supported. For line+symbol plot, if you want the single point legend show as line+symbol as before, set @lsl=0.


Use One Legend Type Only and Auto Update
Add a new menu option named Use One Legend Type Only and Auto Updateunder Legend context menu. When it's checked and select one type of legend in Legend context menu, all other types of entry will be deleted. When data point/data plot is added or deleted, the legend will be updated automatically.


Support leader line for Pie chart label.

Show a leader line between pie slices and labels.


Support Label for 2D Vector Plot.

Double click vector plot to go to Label tab of Plot Details dialog to add labels.

  • Label can customized to be from any column in same sheet with customization.
  • Label can be rotated and be positioned to arrow head, tail with offset, etc.


Control Decimal Separator for Labels & Annotations at Graph Page Level.

In the past, this is a global control in Tools: Options dialog so user can not set different graph windows differently.


Improvement to data labeling at specified Indices only.
In addition to manually entering specific indices, now specific columns may be selected that contain indices for the specific labels.


Use System Increment list when adding new plots into existing graph.

Origin 2017 supported customizing system color list, shape list, etc. for line, line+symbol, scatter plot.

But when user added more then 1 column of data to existing graph, the customized system color list wasn't used. Instead the color list defined in graph template was used. 

In Origin 2018, when adding more than 1 column of data to existing graph, the customized system color list will be used. 


Easier way to turn on and off active dataset indicator (red frame) in Legend via:

The red frame around plot part of legend is the activate dataset indicator. Analysis, etc. tools always work on active dataset by default. So it's useful to see it sometimes.

The control to turn it on or off is hidden on Legends/Titles tab of Plot Details dialog in the past and hard to find.


Keep Scale in mode untill pressing ESC.

User wants to Scale In toolbar button and keep on zooming in by drawing a rectangle.

Before 2018, after scale in once, need to click Scale In button again to zoom in further.


CInteractively pick data points from graph.

Interactively pick points and collect them in a workbook.

Mouse over the plot you want to pick point. A tooltip will show about the plot's X,Y info. Right click and click Pick  Data Points...

Click a point in graph and make sure it's the point you want to pick. Then press Enter or double click to confirm the selection. Continue it till done. A workbook will be created with x,y coordinates and row indexing, etc. 



Make new Layer Content dialog easy to use
Reorder the column order in left panel of Layer Contents dialog so Column Short Name with Plot designation can be more obvious. In Origin 2018, the default display order in left panel is: Short Name, Long Name, Book, Sheet.


Column Gap control for Double Y Column Plot.

For Double Y column plot, user can go to 1st plot's Spacing tab to set Overlap as a negative value to show some gaps between the the columns.

There is no such control in Origin 2017 and earlier so the bars are always connected in the past.


Show Total Label on Stacked Column/Bar.

Show total value on stacked column/bar or 100% stacked column/bar.

  • Check on the checkbox on Stack tab of Layer level in Plot Details dialog
  • Go to Label tab of plot level in Plot Details to customize diplay, such as decimal place, etc.


Symbol size increments for each plot in group.
  1. Specify the size increment by start size and increment step 5(6), or manually enter each plot's size.
  2. Read symbol size from column label row, e.g. a user-defined parameter row:Size


Use Cluster tool to easily change part of plot to a different color.

Cluster Gadget is improved so user can easily select a range of plot and color it.

User can use cluster gadget to create group for the region of interest and check Color Data by Category.

Then the region will be colored red.

Open Plot Details, user can go to Color List tab to change color.


Graph Theme support for Anti-Aliasing.

Before Origin 2018, there was Enable/Disable Anti-Aliasing toolbar button orpage.aa=1 property for user but it was tedious for user to do it for each graph.

A built-in graph theme AntiAliasing.oth is added on Graph tab of Tools: ThemeOrganizer.

User can apply it to existing graphs or set it as system theme for future graph creation.


Plot 2 Y columns with numeric X, columns will be plotted against row indexing by default.

If plotting one Y column as Columns/Bars with numeric X, it will be plotted as X value positions.

If plotting multiple Y column as Columns/Bars with numeric X, it will be plotted with row indexing by default. Use system variable @DRX>0 (default is 16) to enable this feature only if dataset size is smaller then this value. Set @DRX=0 to disable this change completely. 


Improve Preview for patterns and filled colors

Hover mouse over a pattern block, the preview of this pattern will show.


Allow drag-and-drop to add dataset into the group of Stacked Column
In 9.4, it is not possible to adding a dataset into a Stacked Column by drag-and-drop. Now you can add new dataset into the group of Stacked Column/Bar plot by drag-and-drop.


Distribute selected layers/graphic objects horizontally or vertically.

Two buttons are added in Object Editor toolbar.

Select all graphic objects and click it to keep begin and end positions of the objects and

distribute them evenly in one direction. E.g.

This also works for multiple Layers. User can press Shift key and select multiple Layers. Then click the button to distribute layers horizontally or vertically.


Control display of  masked data at graph page level.

Display of masked data on graph can now be controlled for individual graphs via the following Labtalk:

page.mask = 2; // Display masked data on active graph

page.mask = 1; // Hide masked data on active graph


Ctrl+A Keyboard shortcut Selects All in Graph and Layout window.

This feature is useful when user needs to select all layers in agraph or all objects in layout to move and/or resize together.

  • Ctrl+A to select all layers in a graph.
  • Ctrl+A to select all objects in layo


Support Arrow at axis begin and end in 2D graphs.

Arrow node on Line and Ticks tab of Axis dialog


Add custom reference lines to your graph:

Define Reference Lines based on statistics or expression and saved in graph template for future use.

  • Statistics

 

Click Details on Reference Lines tab of Axis dialog to define reference lines.

  • Expression


Change Filling color between Reference Lines with Alternate Fill.

Before Origin 2018, if Alternate Fill was checked for Reference Lines, user couldn't change fill color.

In Origin 2018, click Details... button on the tab. Then select all entries on the left panel and change Fill Color to change all fill colors together.


Show reference line in Trellis plot
You can control reference line show in specific panel in trellis plot through Reference Lines dialog's Show on Panel control. Label will show when open Reference popup to incicate panel index.


Support Reference Line for Polar(and other special plot types)
Polar graph, Radar chart and Ternary all support reference line.


Different ways to wrap tick labels.

Wrap based on layer length

Wrap by Minimum number of characters.

E.g. in the following example, set tick label display to Custom Display with MMM dd HH:mm:ss

And to wrap with by minimum 1 char. It will show Month, date and time each on one row.


Axis Break Improvements:

In Origin 2018,

  • When Anti-Aliasing toolbar button is pressed, axis break will look smooth as well.
  • Use Proportional Unit for Axis Break Positions checkbox is added on Display tab of Page level of Plot Details dialog.


Support not plotting filtered rows for text axis:

E.g. Some data are filtered in worksheet.

When plot column plot in Origin 2018, only those data in display will be plotted with their corresponding X axis.

Before Origin 2018, though the filtered data are not plotted, the x axis still kept their position with blank tick label.

Note: This only applies to X column that contains text and not set as categorical.


Allow number of Major axis ticks to be 0.

This will allow user to create a graph with only begin and end ticks and no ticks in between by:

  • On Scale tab, Set Major tick by Count and Number of Ticks to be 0.
  • On Special Ticks tab, choose Show in Show column of Axis Begin and Axis End.


No extra space after / or - when using /<U> and -<U> as axis unit.

Before Origin 2017, In Tools: Options →Axis tab, when specifying unit separator as /<U>, or -<U>, an extra space shows after / or -.

In Origin 2018, by default no space will be added after / or -. User can manually set it as / <U>, or - <U> to add a space.

We will continue to have space before units separators by default. System variable @ATSS is added to control space before unit separator.

1: space before unit separator (default)
0: no space before unit separator



Axis end doesn't look nice when zoomed in

Before Origin 2018, when zoomed in, Axis ends didn't look good.

In Origin 2018, the Axis ends will look nice even when zoomed in, depending on different coordinate system.

-2 (default): square for Cartesian (=90 degree) coordinate, round for other coordinates (!=90)
-1: follow @LCA
0/1/2 round/square/flat, 



3D XYZ Colormap Surface supports colormapping from another column.

In the past, we don't support this so user has to convert XYZ data and the coloring data into Matrix first since 3d colormapping surface plotted from matrix supports colormapping from another matrix object.



3D XYZ Colormap Surface supports custom boundary.

Contouring Info tab is added in Plot Details dialog to specify XY boundary.


Support no smoothing when set custom boundary for XYZ contour.

In Origin 2018, user can uncheck Smoothing checkbox when using Custom Boundary.

Before Origin 2018, the checkbox couldn't be unchecked so there was always some smoothing effect. Workaround: Set system variable @tcs=0 to minimize the number of smoothing data points


Support Lighting effect for 3D walls plot.

Before Origin 2018, Lighting was only supported for 3D OpenGL based surface and 3d Bars.

In Origin 2018, we added the support for 3D Walls.


Drag on graph to move light source.

Hotkey S is added on 3D graph to move light source.

  • S key + arrow keys
  • S key + drag
  • S key with + to zoom in. S key with - to zoom out


Analysis

Fitting: Add more Fit Statistics to fitting Result Table Quantities.

In previous versions, some Fit Statistics were excluded from list of available Quantities in Table. More items are available in Origin 2018.


Fitting: Null hypothesis footnote is added under ANOVA table of Nonlinear Curve Fit, Multiple Regression, and Polynomial Fit report sheets.
Requested by customer.


Fitting: FDF should include Category

Add new Category key to FDF General Information section.

  1. When D&D the FDF to Origin, FDF is automatically installed under the Categorys according to the Key.
  2. If this new key is empty or missing, it will pop up dialog to ask about which category to install.
  3. Operations in Fitting Function Builder and Fitting Function Organizer will update this Category key, such as Create/Move func.
  4. Fitting Function Builder allow to change category since 2018.


Fitting: Fit until converged supports all datasets for multiple data

In Nonlinear Fit tools, add All option in the Select data to iterate drop-down list which allow to iterate on multi datasets at the same time. 


Fitting: Put all weighting methods in dropdown items for all input datasets
  • In Nonlinear Fit tools, Data Selection page, all weighting methods are putted in the Weights drop-down list whichi allow to set multi datasets' weight mehod.
  • In Nonlinear Fit tools, Data Selection page, add Apply Weight to All menu to Range's context menu list. 


Fitting: Smarter Handling of NLFit X Data Type
When Iteration Algorithm is set as "Levenberg Marquardt" in Nonlinear Fit tools, Fitted Curves page, default X Data Type is changed as new method: Follow Curve Shape. (Note: except the Nonlinear surface/matrix fit tool)


Peak Analysis: Automatically set Area/Amplitude boundaries based on Peak Finding Direction.
  • If Peak Finding direction is Positive only, then Area boundary is >=0.
  • If Peak Finding direction is Negative only, then Area boundary is <=0.
  • If If Peak Finding direction is Both, then no boundary is set.


Statistics: Add grouping support for Statistics on Rows.

Statistics on Rows now allows grouping based on values in a columns label row. For example, in below illustration, results will be grouped by values in the Long Name label row.


Statistics: Discrete Frequency for categorical data needs to add zeros for if not found

Discrete Frequency dialog  adds a checkbox Show Zero Count Categories.


Statistics: Improve Weibull Fit with RRX method and Add Plot for survival function and hazard function for weibull fit - Origin Pro

Weibull Fit dialog adds below new items:


Statistics: Weibull Fit Calculate 100% Probability Which Can't Plot
Origin 2018 changed Weibull Fit tool's Score Methods from Kaplan-Meier to Benard, which also affects Distribution Fit tool's probability plot .


Statistics: Rename Weibull Percentiles into percentages

Weibull Fit tool's PlotData worksheet column label changed.


Statistics: Add ellipse coefficient to correlation matrix

From Origin 2018, the major and minor radius of the correlation ellipse in Scatter Matrix are exported to the result sheet. No matter you create the Scatter Matrix from Plot: 2D: Scatter Matrix or Statistics: Descriptive Statistics: Correlation Coefficient, you can find the major and minor radius of each correlation ellipse by A and B values in the Parameters column label row of the PlotData worksheet, where A is the major radius and B is the minor radius.


Statistics: Add Median Absolute Deviation, Robust Coefficient of Variationand Harmonic Mean for Statistics on Columns/Rows tool

Statistics on Columns/Rows dialog adds below checkboxes:


Statistics: Add option of Exclude cumulative counts plot to Pareto chart dialog

Add options to the Pareto Chart (Binned and Raw) dialog

  1. Add Show Cumulative Percent Plot checkbox to plot the cumulative counts plot.
  2. Add branch Combine Smaller Counts in One Category to group combine smaller values settings.


General: Set Default Digits for individual types of analyses.

Prior to Origin 2018, there is only global control of display digits via Digits in Report in the Numeric Format tab of Tools: Options.

In 2018, users can specify default Default Digits to apply for different types of analyses. For example:

After an analysis is done, right click in the table in the result sheet and choose Digits...  Set the Digits values and check Save as Default.

The default will apply to other instances of that particular analysis operation in the future.


To reset back to system default: Close Origin. Go to User Files folder and delete Defaults.XML.



General: Ignore Hidden column/plots when choosing all columns or plots for analysis.

A system variable, @AIP, is added to control whether ignore hidden column(s)/plot(s) or not when adding all as input(s) for analysis.

  • =1 (default), ignore hidden plots.
  • =0, include hidden plots.

For example, if some columns or plots on a graph are hidden, when opening an analysis dialog that supports multiple inputs and the user chooses All Colu


Data Processing

Worksheet Cell Formula.



Keep formula exactly as entered by user.

Before Origin 2018, formula auto expanded in some cases.

  • Sheet index in formula auto expanded to sheet name. E.g. user typed 1!A. It auto expanded to Sheet1!A.
  • If type A+0.5 in column A formula, it will become This+0.

System variable @SCVU is added in Origin 2018.  By default what you type will be what you see. If you want it to go back to 2017 behavior, set @scvu=0.


New X-Function wcellfmt added to set selected cells' format.

Run wcellfmt -h to see Help and examples.

E.g. the following example first uses wxt x-function to select all rows with B>0

Then set the fill color of the selected cells to green


Copy Full Precision change to text only

Since Origin 2018, when use choose Copy Full Precision, the copied content will be text only in clipboard, then it would be convenient for user to paste to another application.

Set @CPF = 0 to go back to 2017 behavior.


Rename sheet name and long name inNavigate Worksheetdialog.

For a workbook with many sheets, user can right click any sheet tab and choose Navigate to delete, order, duplicate sheet etc. But renaming sheet wasn't supported.

Added in Origin 2018 now.


System Variable to hide worksheet tab tooltip.

When mousing over a worksheet tab, worksheet short name, long name and comments show. But it can block other sheets.

A system variable @WTT is added. Default is 1 (enabled). Set it to 0 to disable worksheet tooltip.


Increase the Maximum number of Sheets per workbook.
  • Before Origin 2018, the maximum sheets per book was 255. Now in Origin 2018, it's 1024.
  • page.nlayers property is set to writable so run page.nlayers=1024 to quickly create 1024 sheets. It's faster than using repeat 1023 { newsheet; }.
  • If there are more than 255 sheets in a book, the project can't be saved as opj. Can only be saved as opju.


Increase the Maximum Undo times to 100.

In Origin 2018, the default maximum number of Undos is set to 100. Before Origin 2018, it was 10 times. Corresponding system variable: @UN.


Support carrying over column categories in worksheet query.
Support carrying over column categories during worksheet query data extraction to new book/sheet.


Better color syntaxing for LabTalk function and Spreadsheet column name notation in Set Column Value dialog.
In Set Column Value dialog, use Navy color for LT variable, Wine color for LT function, Pink color for Spreadsheet column name.


Importing

Support Undo for Import ASCII, CSV, and Excel.
After importing either ASCII, CSV, or Excel, user can choose Undo from the Edit menu or Ctrl+Z to undo the import.


To make Reimport and Clone Import more obvious, a new Import toolbar is created with more buttons.


Set Origin to be the default software to open data files.

In Origin 2018, if user right-clicks on a data file and set the file to open with Origin or set Origin to be the default program to open it,

data file will be imported into Origin directly whenever such a file is double-clicked.


Display imported file name in a new worksheet label row entitled "SourceFile".

A new checkbox "Add Filename User Parameter Row" in Import dialogs.

If checked, "SourceFile" label row appears in worksheet after import. This label row can be used in any place label rows can be used such as legends.



Importing specified columns and rows in ASCII, CSV, and Excel dialogs using specific syntax.

Under Partial Import node. See ASCII Import dialog for example syntax.

  • If Custom isn't checked, use From, To, Read, Skip buttons to construct the partial import.
  • If Custom is checked, user can import specified columns/row by following our syntax. Sample example hint is given. 


More options in Excel Import.

  1. More sheet renaming options: This is useful if user import sheets in different files and wants to rename sheet with Excel file name.
  2. Put Filename or Sheetname to Comments, SourceFile, or SourceSheet column label rows.



Support Skip Column when importing CSVfile.

This was already supported in some other import like ASCII, Excel, etc.

Added the Read Columns and Skip Columns in CSV Import.



Copy and Paste Excel cell(s) to Origin Graph will paste as text by default.

Before Origin 2018, if user copied some cell(s) in Excel and then pasted it into Graph window, it was pasted as Excel object by default. User must use Edit: Paste Special... to paste as unformatted text.

In Origin 2018, the cells will be pasted as text by default. If user wants to paste as Excel object, user can choose Edit: Paste Special... or context menu and choose to paste as "Microsoft Excel Worksheet".

Set system variable @PXLTXT=0 to change back to old behavior.


Import ASCII one row header line with special format
Change the Extract Long Name and Units from Same Line node to Composite Header Line No. node, when this node is check, we show the Composite Pattern node for specify the composite pattern of Long Name, Unit andComment, if it is <auto>, it will works as the old way.


Import Excel- Support Importing Sheets into Separate Workbooks
 Add a new option Start New Books for Each Sheet in "1st File" and "Multi-File" Import Mode, but currently re-import is not supported in this mode.


New impASC on GUI and related changes

Reconstruct the Import ASCII X-Function "impASC"(including the impASC setting dialog), and also it is compatible with the old one in LT script. However, we also add a system variable @IA for users who want to use the old one to roll back.

@IA = 1
File Menu: impASC_94
Tool Bar: impASC_94
LabTalk Script (run -xf impasc): impASC_94
Reimport (from old 94 .ogw): impASC_94
Drag and Drop (with old 94 .oif): impASC_94

@IA = 2
File Menu: impASC
Tool Bar: impASC
LabTalk Script (run -xf impasc): impASC
Reimport (from old 94 .ogw): impASC
Drag and Drop (with old 94 .oif): impASC


Support Partial Row Import for Excel

Suppport Partial Row Import for Excel import tool, add Partiial Rows branch with five nodes under Options: Partial Import:



Exporting and Presentation

Ignore hidden columns in ASCII Export.

Before Origin 2018, when exporting a worksheet as ASCII data, hidden columns were exported.

In Origin, by default hidden columns will be ignored and will not be exported.

To export hidden columns, set system variable @UHC=1. 


Define the region to export or copy page in Origin 2018.


Batch Processing

Improvements to Batch Processing:

Mini tutorial:

  1. Open Batch Processing dialog.
  2. Load Analysis Template under <Origin EXE folder>\Samples\Batch Processing\Sensor Analysis.ogwu.
  3. For File List, select Sensor01, Sensor02, and Sensor03.dat under <Origin EXE folder>\Samples\Curve Fitting\.
  4. Set Result Sheet as Result.
  5. Click OK. In Summary sheet, there is a graph image from the analysis Template on each row. Mouse over it to pop up a larger image of the graph.

How to include a graph image in each row or report sheet:

  1. Open the analysis template .OGWU file. e.g. <Origin EXE folder>\Samples\Batch Processing\Sensor Analysis.ogwu.
  2. Copy an embedded in the report sheet and Paste Link in a cell in the sheet that will be used as Summary Sheet in Batch Processing. 
  3. Save the analysis template and use it in Batch Processing dialog.


Batch processing support XYZ columns, worksheets, and data ranges.

1.XYZ column

support in both using existing xyz datasets or import from files.

2. Use existing worksheets

support using any sheet from opj as input, if selected it will copy all columns to data source in analysis template.this options should be useful for statistics tools not require column designation.

3.Use Existing Ranges

it will have two input range: Fixed Range and Batch Range, Fixed Range means those data which is fixed in each process. this options should be useful for statistics tools.


Improve Labtalk script to support exporting specified embedded graph(s) or graph sheet(s) during batch processing viaScript After Each Process inBatch Processingdialog.
Example scripts:
//To export a graph sheet with sheet name: Graph1

expGraph type:=pdf overwrite:=rename export:=specified page:=Graph1!;
//To export a graph sheet with is the 5th sheet
expGraph type:=pdf overwrite:=rename export:=specified page:=5!;
//To export embedded graph in result sheet by graph short and long name
expGraph type:=pdf overwrite:=rename export:=specified pages:="FitLine - Linear Fit";
//To export embedded graph in FitLinear result sheet by graph short name
expGraph type:=pdf overwrite:=rename export:=specified pages:=FitLine;

//To export embedded graph in worksheet cell
expGraph type:=png filename:="<long name>" export:=specified page:=col(A)[3];

//To export multiple graph cells or floating graph
 expGraph type:=pdf  overwrite:=rename page:=2!; //sheet index


New Project File Extension for New File Format and File Dialog
In Origin 2018, New File Extensions like OPJU, OGWU, OGGU, OTWU, etc are added to various opening/saving file dialogs drop-down lists.


Convert Origin to use Unicode for text and a new file structure for various Origin files including projects.

File extensions are changed to: OPJU, OGWU, OGGU, OTWU,, etc.

New structure allows file sizes to be reduced (sometimes greatly).

It also allows files to be loaded more quickly.


Support Preview and  thumbnail file images in Windows File Explorer for Origin Files. (Toggle Windows File Explorer Preview pane using the  Alt+Pkeyboard shortcut).


If Origin crashes, it will restart with last Autosaved OPJ/OPJU loaded

If an OPJ/OPJU file is opened and being worked on in Origin, it will be autosaved every 12 minutes by default and if Origin crashes, user can go to Autosave folder to find it. 

In Origin 2018, if Origin crashes, it will restart with last Autosaved OPJ/OPJU loaded so user doesn't need to manually find it in Autosave folder. 

Note:

  • If it happened that Origin crashes before 1st autosave happened, then the original OPJ/OPJU will be loaded. 
  • If you have worked on a new project file but never saved it. It is called Untitled.opj Origin doesn't autosave Untitled.opj
  • Old feature: User can control how often project is autosaved in Tools: Options dialog.


In the Projects tab, Origin projects that were modified and not actually saved can be reopened with the modifications in place via the Unsaved Files list.

Even if the user chooses not to save a project file (OPJU), an autosaved OPJU will be kept for 7 days by default. If the user actually saves the project after modifying it, the unsaved version will be removed.

  • The unsaved version can be opened from the Unsaved File list in the Projects tab.

  • The user can turn off this feature from Tools: Options: Open/Close tab.

  • The System Variable @USKT is used to control how many days to keep the unsaved OPJU file. Default is 7 (days).
  • The system Variable @USM is used to limit the maximum OPJU size for Autosave Unsaved Project. Default is 20 (MB).


Programming

Labtalk: Option to let graph source always plot all Y columns in worksheet.

With graph window active, run layer.group1.AllCols=1; in Script Window.

Then all Y data in the worksheet will be plotted and, as Y columns are added or deleted, they will be removed/added to the graph.

Note: This only applies to worksheet with XYYY... plot designation.


Labtalk: New X-Function wcellfmt added to set format of selected worksheet cells.

Run wcellfmt -h; in Script window to see Help and examples.

For example: The following example first uses wxt x-function to select all rows with B>0 and then set the fill color of the selected cells to green.


Labtalk: Diff() function supports padding in the begin or end of range.

Add optional argument to current function:

vec Diff(vec[,n]) //support length of vector is N

where n can be
0 default, output vector length is N-1
1, pad 0 at the end, output vector length is N
2, pad 0 at the beginning, output vector length is N
3, 1st value in v, diff(v,0), last value in v, output vector length is N+1

For example: Suppose there are 10 rows in column A and Set Column Values of B as

diff(A) – returns 9 numbers. No value in last row.

diff(A,1) – returns 10 numbers. 0 at the end.

diff(A,2) – returns 10 numbers. 0 at the beginning.

diff(A,3) – returns 11 numbers. The begin and ending values are original begin and ending values in A. In between are diff(A) values .



Labtalk: LabTalk Command to convert OriginC C and CPP files to become OCZ for distribution.

Syntax for the conversion command is is

file -ocz password srcpath destination;

srcpath can have wildcard in file name, and in this case destination must be a folder location and destination files will use source file name and extension changed to OCZ.
password must be between 2 to 20 characters and space is now allowed.

The Message Log will list each successful conversion and indicate at the end as "Done!" or "Failed!". If any errors occur, they will be displayed in a Messagebox.

For example:

file -ocz junk "%YOriginC\*.c??" "%Yabc"

file -ocz "aB12#$" "%YOriginc\test.c" "%Yjunk.ocz"


Labtalk: Better LabTalk access to plotting X-functions.

The X-functions below can be run  via LabTalk to create graphs.

  • plot_paretobin
  • plot_paretoraw
  • plot_gboxindexed
  • plot_windrose
  • plot_gindexed
  • plot_lineser
  • plot_kde2
  • plot_prob
  • plot_matrix

For  example:

plot_gboxindexed irng:=col(A) group:=col(B) theme:="test";


Labtalk: Support  -mfph switch for LabTalk Create command to create a hidden matrix from 2D loose datasets for 3D parametric function plot.

For example:

create myx -fp2 50 u 0 1 50 0 1;

create myy -fp2 50 1 0 1 50 0 1;

create myz -fp2 50 v 0 1 50 0 1;

create FuncRight -mfph myz myx myy "u,v";


Labtalk: LabTalk Function for Data Range of Plot

Add a new LabTalk function to get the data range of a plot in graph.

Syntaxdataset plotdata(index, designation, x = 0, y = 0) //x&y refers to panel index.

Also, two new LabTalk functions added to get the first point and last point of a plot.

Syntax

double FirstPoint(vector vec);
double LastPoint(vector vec);


Labtalk: LabTalk Save command updated to support new file format
  • save -i filename; //Save the active worksheet, graph, or matrix window to a file with new file format, file extension will be ogwu, oggu, ogmu 
  • save -ij filename; //Save the active worksheet, graph, or matrix window to a file with old file format, file extension will be ogw, ogg, ogm 
  • save -ik filename; //Save the active workbook as analysis template with the extension of ogwu 
  • save -ikj filename; //Save the active workbook as analysis template with the extension of ogw 
  • save -t windowName filename; //Save windowName into a graph or worksheet template with new file format, fill extension will be otpu for Graph, otwu for Worksheet
  • save -tj windowName filename; //Save windowName into a graph or worksheet template with old file format, fill extension will be otp for Graph, otw for Worksheet
  • save -di/-di1 filename; //Save the project as new file format with the extension of opju 
  • save -dij filename; //Save the project as old file format with the extension of opj 

Also, use option X to Save With Format Determined From Supplied File Extension. Following switches are supported, -ix, -tx, -dix.

For example, 

  • save -DIX %yMyProject.opj; //saves the project in the opj format with the name MyProject.opj
  • save -DIX %yMyProject.opju; //saves the project in the opju format with the name MyProject.opju
  • save -DIX %yMyProject; //saves the project in the opju format with the name M


OC: Additional dialog-related Win API functions

Support added for flashing dialog title bar, etc via the functions FlashWindowEx() and FlashWindow().

For example:

FLASHWINFO st;
st.cbSize = sizeof(st);
st.hwnd = s_pMyDlg->GetSafeHwnd();
st.dwFlags = FLASHW_CAPTION;
st.uCount = 3;
st.dwTimeout = 0;
 
FlashWindowEx(&st);{code}
EVENTS_BEGIN_DERIV(HTMLDlg)
    // Others events.
    OnActivate(OnActivate)
EVENTS_END_DERIV
 
BOOL OnInitDialog()
{
    HTMLDlg::OnInitDialog();
 
    HWND hwnd = GetSafeHwnd();
 
    // Add WS_EX_LAYERED to this window style.
    SetWindowLong(hwnd, GWL_EXSTYLE, GetWindowLong(hwnd, GWL_EXSTYLE) | WS_EX_LAYERED);
 
    // Make this window 60% alpha.
    SetLayeredWindowAttributes(hwnd, 0, (255 * 60) / 100, LWA_ALPHA);
 
    return TRUE;
}
 
void OnActivate(UINT nState, HWND hwndOther, BOOL bMinimized)
{
    HWND hwnd = GetSafeHwnd();
 
    if( WA_INACTIVE != nState )
    {
        // Window activated.
         
        // Remove WS_EX_LAYERED from this window style.
        SetWindowLong(hwnd, GWL_EXSTYLE, GetWindowLong(hwnd, GWL_EXSTYLE) & ~WS_EX_LAYERED);
 
        // Ask the window and its children to repaint.
        // Comment out if dialog flickers.
        RedrawWindow(hwnd, NULL, NULL, RDW_ERASE | RDW_INVALIDATE | RDW_FRAME | RDW_ALLCHILDREN);
    }
    else
    {
        // Window de-activated.
 
        // Add WS_EX_LAYERED to this window style.
        SetWindowLong(hwnd, GWL_EXSTYLE, GetWindowLong(hwnd, GWL_EXSTYLE) | WS_EX_LAYERED);
 
        // Make this window 60% alpha.
        SetLayeredWindowAttributes(hwnd, 0, (255 * 60) / 100, LWA_ALPHA);
    }
}


OC: OC to provide access to LabTalk LT properties on OriginObject

2018 will have general OC access to all the LT properties, this will include GraphObject, Column, Worksheet, etc

cc()
{
    vector<double> vPos;
    vector<int> vColor;
    int n=0;
    GraphLayer gly = Project.ActiveLayer();
    if( gly.IsValid() )
    {
        vector<double> xx;
        foreach (GraphObject go in gly.GraphObjects)
        {
            if(go.GetName().Left(4)=="Line")
            {
                vColor.Add(go.GetProp("color"));//color is integeter, can directly return
                double xPos=0;
                go.GetProp("x1",&xPos);
                vPos.Add(xPos);
                n++;
            }
        }
    }
    return n;
}


OC: CreateGraphObject()provides an option to replace existing

Add a bit, GROBJ_REPLACE_EXISTING,for  CreateGraphObject() to replace existing

void aa(double xx, int nColor, string strName = "line")
{
    GraphLayer gly = Project.ActiveLayer();
    GraphObject goLine = gly.CreateGraphObject(GROT_LINE, strName, GROBJ_REPLACE_EXISTING);
    goLine.SetProp("attach", 2);
    goLine.SetProp("direction", 2);//vertical
    goLine.SetProp("x1", xx);
    goLine.SetProp("y1", 2);
    goLine.SetProp("y2", 8);
    goLine.SetProp("color", nColor);
    goLine.SetProp("arrowEndShape",1);
}


OC: Add rgb calculation functions to OC
Add two OC functions RGBtoHSL() and HSLtoRGB() to convert RGB to HSL and HSL to RGB


OC: Provide function to get the short description name of DataRange

Function below is added

BOOL    DataObject::GetCustomEscapedString(string& str, LPCSTR lpcszCustom);
BOOL    DatasetObject::GetCustomEscapedString(string& str, LPCSTR lpcszCustom); /// for loose dataset
void test_GetCustomEscapedString()
{
    Worksheet wks = Project.ActiveLayer();
    XYRange dr;
    dr.Add(wks, 0, "X");
    dr.Add(wks, 1, "Y");
     
    Column colY;
    dr.GetYColumn(colY);
     
    string str1, str2;
    colY.GetCustomEscapedString(str2, "@U"); /// Longname & Unit
}


OC: DynaControl to Allow Multiple Controls in One Row
#include <GetNbox.h>
void GetNBoxMultiColumn()
{
    GETN_TREE(tr)
    //1 col
    GETN_BEGIN_BRANCH(PartImp0, "Branch0")  
    GETN_CHECK(Save, "Save Temp Files Save Temp Files Save Temp Files", false)
    GETN_CHECK(Save, "Save X Files Save X Files Save X Files Save X Files", false)
    GETN_CHECK(Save, "Save Y Files", false)
    GETN_CHECK(Save, "Save ABC Files", false)
    GETN_CHECK(Save, "Save CDE Files", false)
    GETN_CHECK(Save, "Save Junk Files", false)
    GETN_END_BRANCH(PartImp0)
 
 
    //2 columns
    GETN_BEGIN_BRANCH(PartImp, "Branch1 ++++++++++++++++++++++++++++++++")   GETN_MULTI_COLS_BRANCH(2, 0)
    GETN_CHECK(Save, "Save Temp Files", false)
    GETN_CHECK(Save, "Save X Files", false)
    GETN_CHECK(Save, "Save Y Files", false)
    GETN_CHECK(Save, "Save ABC Files", false)
    GETN_CHECK(Save, "Save CDE Files", false)
    GETN_CHECK(Save, "Save Junk Files", false)
    GETN_END_BRANCH(PartImp)
     
    //1 column
    GETN_BEGIN_BRANCH(PartImp2, "Branch2")
    GETN_CHECK(Save, "Save Temp Files Save Temp Files Save Temp Files", false)
    GETN_CHECK(Save, "Save X Files Save X Files Save X Files Save X Files", false)
    GETN_CHECK(Save, "Save Y Files", false)
    GETN_CHECK(Save, "Save ABC Files", false)
    GETN_CHECK(Save, "Save CDE Files", false)
    GETN_CHECK(Save, "Save Junk Files", false)
    GETN_END_BRANCH(PartImp2)
 
    //3 columns
    GETN_BEGIN_BRANCH(PartImp6, "Branch6")
    GETN_BEGIN_BRANCH(PartImp5, "Branch5 **********************************************************************************************") GETN_MULTI_COLS_BRANCH(3, 0)
    GETN_COLOR(FitCurveColor, "Fit Curve\n color", 1)
    GETN_COLOR(FitCurveColor, "Fit  color", 1)
    GETN_COLOR(FitCurveColor, "Fit Curve\n color", 1)
    GETN_COLOR(FitCurveColor, "Fit color", 1)
    GETN_COLOR(FitCurveColor, "Fit Curve\n color", 1)
    GETN_COLOR(FitCurveColor, "Fit  color", 1)
    GETN_END_BRANCH(PartImp5)
    GETN_END_BRANCH(PartImp6)
 
    //3 columns
    GETN_BEGIN_BRANCH(PartImp7, "Branch7 *************************************************************************************************") GETN_MULTI_COLS_BRANCH(3, 0)
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit  color", "STR1")
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit color", "STR1")
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit  color", "STR1")
    GETN_END_BRANCH(PartImp7)
 
 
    GETN_BEGIN_BRANCH(PartImp8, "Branch8 ") GETN_MULTI_COLS_BRANCH(2, 0)
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit  color", "STR1")
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit color", "STR1")
    GETN_STR(FitCurveColor, "Fit Curve\n color", "STR1")
    GETN_STR(FitCurveColor, "Fit  color", "STR1")
    GETN_END_BRANCH(PartImp8)
    if( GetNBox(tr, "Get Path", NULL, NULL, NULL) )
        out_tree(tr);
}


OC: Code Builder Should Handle UTF-8 files
Now Code Builder is able to handle UTF-8 files - loading, editing, saving, and debugging.


OC: Origin C compiler Must Handle UTF-8 Source Files

In Origin 2018, we support executing UTF-8 files in Code Builder.

1. All code files (*.c, *.ogs etc.) Origin ships (so it is placed EXE folder) is kept as ANSI.
2. When create a new empty code file, it is also ANSI. However, when saving, we will pop up msg to ask to if save as Unicode when Unicode characters appear.

This file contains characters in Unicode format which will be lost if you save it as an ANSI encoded file.
Click Yes to save as Unicode (UTF-8) encoding format.
Click No to save as ANSI.


HTML: Provide format option to convert variables in OC to string in html

Add a parameter in JSON.ToString( ), which converts variables in OC to string in html with full precision, to specify format

struct TestObj{
float ff;
double dd;
string str;
};
 
void test_json()
{
    TestObj obj;
    obj.ff = 1.234567890123456789;
    obj.dd = 1.234567890123456789;
    obj.str = "3.1415926";
    string strJSON1, strJSON2;
    OCJSONToString params;
    params.szFloatFmt = ".2";
    JSON.ToString(obj, strJSON1);
    JSON.ToString(obj, strJSON2, &params);
}


HTML:Change the z-index of controls

Enable popping up a message in an HTML dialog, it should be on top of graph control . Download the zip file below to see the sample codes

Alert on graph.zip


HTML:Show icon in the title bar of app dialog

Two new member functions are added to OC Window class:

HICON Window::SetIcon(HICON hIcon, BOOL bBigIcon = FALSE);
HICON Window::GetIcon(BOOL bBigIcon = FALSE);

A new util function is also added to make it easier to set the icon from given icon file:

HICON set_window_icon_from_file(HWND hWnd, LPCSTR szIconPath)

See below for the example of setting the icon of the HTML app dialog:

BOOL CMyHTMLDlg::OnInitDialog()
{
    HTMLDlg::OnInitDialog(); // Call base class.
     
    string strIconPath = __FILE__;
    strIconPath = GetFilePath(strIconPath) + "test.ico";
    set_window_icon_from_file(GetSafeHwnd(), strIconPath);
    return TRUE
}


HTML:HTML dialog support IE version checking
All HTML dialog and HTML based App support IE version checking to avoid Javascript errors when IE Ver < 9


Miscellaneous: LabTalk and OriginC  string functions can now operate on UTF-8 encoded strings.

Origin 2018 is Unicode-based with UTF-8 as the encoding method. For details on how this changes both LabTalk and OriginC text string processing functions, see this blog post:

http://blog.originlab.com/programming/labtalk-and-originc-changes-due-to-unicode-support-in-origin-2018


Miscellaneous:Improve Find and Find in Files in Code Builder.

Support User Regular Expressions and Append results in Find in Files dialog of Code Builder.


Miscellaneous:Allow graph object to be resized programmatically when horizontal and vertical movement is prohibited in Object Properties dialog.

Set system var @RRNM=1 to allow resizing when Disable Horizontal or Vertical Movement bits are set. (default is 0).


Miscellaneous:Warning when opening an opj which version is higher than your Origin

Implemented in Origin 2018. When opening an opj/opju which version is higher than your Origin, a smart hint show 

The file was created in a higher Origin version.
Some features may not be accessible.
It is recommended to upgrade your Origin to work on the file.


Miscellaneous:Reminder Message about saving OPJ as OPJU
When user opens an OPJ file and later Save As, by default the format is OPJU, and we should open a reminder message box to inform them earlier version of Origin will not be able to open such files and allow Cancel, so file not saved.


Miscellaneous:Stop shipping MOCA files
MOCA files are not shipped together with Origin 2018. If you need to build your MOCA DLL, please contact us: tech@originlab.com


Option to bring over 2017 Workspace and toolbar layout to Origin 2018.

When launching Origin 2018 for the 1st time, after specifying User Files Folder, a messagebox asks user if he/she wants to copy over Origin 2017 workspace and toolbar layout. Alternately, the user can go to View: Toolbars, click Reinitialize button to see the message again.


Options to Transfer 2017 User Files.

When launching Origin 2018 for the 1st time, a message box will popup asking user if they want to transfer User Files from Origin 2017. If "No" is chosen, the user can later choose Tools: Transfer User Files... to transfer them. 


Easier nodelocked (single or group) Licensing.

If user has valid Origin Maintenance, she/he can install 2018 with the same Serial number as Origin 2017 on the same PC as Origin 2017,

The Product Key for Origin 2018 will be automatically pre-filled with the one from the Origin 2017 installation. Just click Activate button once to activate Origin 2018. 



Important Origin-related folders are no longer in version-specific subfolders.

The following folders are no longer put into Origin version-specific subfolders making migration to future versions of Origin much easier.

  • User Files\
  • AutoSave\ 
  • Unsaved\
  • License\


 

© OriginLab Corporation. All rights reserved.