Origin 2017 Features

Origin 2017 Highlights

The table below only lists some highlights of Origin 2017. To see more features in 2017, please use the navigation bar on the left panel of this page.

Please download 2017_Graphing.opj and 2017_Others.opj to try some new features.

Please download 2017 LaTeX to use it in Origin 2017.

Origin Interface





Origin Central dialog

Origin Central dialog opens unpon launching Origin 2017 (F11)

  • Open section provides a lot of graph and analysis samples. Picking it will only open the corresponding folder with instruction. User can put their data into to see how graph and analysis updates.
  • Open section also provides ways to open new book or matrix.
  • Open Existing Files to open opj, ogw, otw, ogg files. 
  • Resources to see Apps. User can click the icon to go to file exchange page to download Apps. Learning Center will provide tutorials and videos, etc.
  • New Version button to check for available patch to update, new samples or new version Origin

Choose Help : Origin Central from the main menu or Press F11 to open the dialog. 

ORG-14889Plot menu shows plot type with larger icons.
More built-in plot types. E.g. box plot has many variatiions with can be plotted with one click from Plot menu.
  • Plot menu is reorganized with large menu icons to better locate plot types.
  • More plot types and variations are added.
  • Mouse over each plot group to see more plot types.

Note: If you prefer the old menu, go to Origin exe folder. Rename PlotPopup folder. Restart Origin. The Plot menu will go back to the old way.


Object Manager Improvements:

  • Bold active dataset 
  • Context menu to set as active

ORG-15060Mouse hover data plot to show plot tooltip

In the Graph window, mousing over the data plots to see the data information of each plot

System Variable : @PT to enable plot tooltip,

0 – disable plot tooltip

1 enable 2d plot tooltip only

2 – enable 3d plot tooltip only

3 enable both 2d and 3d plot


Help: Open Folders to easily navigate to the folder in Windows Explorer

  • Origin Folder – Origin central files, etc.
  • User Files folder
  • Autosave folder – if Origin is crashed, find the autosaved opj
  • Program folder — installation folder
ORG-15241Distribute more Origin samples via Check for UpdatesNew Origin samples can be downloaded and auto installed via Help : Check for Updates as an opx file.
ORG-14657Add tabs to Apps bar

Tabs are added on the top of Apps bar for easier navigating to apps. Users are able to create, remove or rename a tab.

Support Chinese GUI  (SR1)

Origin start to support Chinese GUI from 2017 SR1.


Show Object Manager by default  (SR1)Many user may not know we have a tool to easily manipulate plots, layers in graph. It's docked on top of Apps Gallery on the right side of Origin workspace.


Graph: Add Function Graph... is renamed as Add Function Plot... (SR1)So user understands this is to add function plot in current graph window.


Plot: Double Y: Double Y Column menu added (SR1)User can directly select two Y columns and plot as Double Y column plots.


Help: Programming submenus are brought back (SR1)

  • LabTalk
  • Origin C
  • X-Functions
  • etc

We hide them in Origin 2017 SR0 but user felt it's hard to find only LabTalk Helps, etc.

So we bring the submenus back.


Help: Live Support Chat... menu is added (SR1)User can choose to get help from Tech support online


Help: Contact Support... menu is updated (SR1)

User will bring to our webpage with many info. prefilled to submit the contact support form easier.


More Import data types are added to File: Importcollapsible menu by default (SR1)

CSV, Matlab, OPJ, Image to Matrix show by default under File: Import menu.


App Gallery Improvements.(SR1)
  1. Easier way to get updates of an APP.
    A red dot on an App indicates a new version is available. Right click to update


Improvements on Origin Central  (SR1)
  1. Version of current Origin Central dialog shows in bottom-left corner of Origin Central dialog.
  2. If new graph and analysis samples are available, when openning Origin Central dialog, a prompt is given to user to get the updates. Choose Yes will download new samples and update the Origin Central dialog to a newer version.
  3. Show big Origin Blog and User Forum icons in Learning Center tab.


Show Preview to the right of Image Analysis dialogs (SR1)

Before Origin 2017 SR1, the image preview for many XFs related to image processing is at the bottom of the dialog. This makes it awkward to use:

  • The dialog opens with controls hidden by image
  • When user starts stretching the dialog part, image gets smaller
  • When both are adjusted, the dialog plus preview can be really tall, and may cause issues on some monitors


New Graph Types





Box Plot Improvements
  • Show Statistics Bar such as mean, max, sum, etc.

  • Connect mean points, data points or other percentiles (after beta1)

Line Series Plot Improvements

The Line Series plot has been redone in Origin 2017 and is based on box plotNo hidden sheet is created. Changing raw data will update the graph. 

It has more customization options, such as

  • Indexing line/symbol colors by data in another column from the raw datasheet. 
  • Set symbol position by numeric values in column label row.

ORG-8205Trellis Plot
  • From Plot menu, there is a new plot type Trellis Plot in 2D category to plot multi-panel grouped plot.
  • In the dialog that opened, user can choose plot type and where the horizontal and vertical panel info. is from.
  • No extra sheets are created for such plot. 
  • New tick label type Panel Banner is added for trellis plot
  • Panel tab is added on plot level of Plot Detail dialog. User can further customize, such as
    • Add, delete, modify horizontal and vertical panel columns
    • Overlap panels and wrap panels
    • Add Gap between panels
    • Use Alternate Side to show ticks and labels

3D Bars, Stacked Bars, 100% Percent Stacked Bars
  • Different bar shapes for 3D Bars

  • Group plots in 3D XYZ scatter, XYZ bars and Matrix Bars

  • Stacked 3D XYY and XYZ Bars.

Labels, Legend, Color Scale and Bubble Scale

ORG-14396Hide left symbol part in Legend via context menu

ORG-15346Support %(?, @xx), %(?x, @xx) for Custom Column Name or Label or Custom Layer Banner

%(1, @LA), means the Y column long name of 1st plot

%(1X, @LA), means the X column long name of 1st plot

When there is a connection between tick and plot(major tick type=By plot column label. The position setting of plot is set to auto or the same column label of major tick type. ), ? means the related plot. Otherwise, ? will use the setting of Data Plot Index for Auto Axis Titles in Page level.

ORG-15292Categorical legend improvement related to connect line

For Box plot, if the connect line color of data points indexing by a column, Legend:Categorical values dialog should show Line Color checkbox, select it will show the categorical info of connect line.



Annotation Improvements
  • Annotation toolbar button is moved out of the Data Reader group to make it more obvious.
  • Double click annotation will show a new dialog with more controls: Text, Frame, Leader line, Position and Programming.
  • Press Alt key and drag annotation text to move it to new location with text updated.

ORG-14565Additional global custom legend format

For Plot Details and Updat Legend dialog, add 3 more entries as a separate group, when Translation mode of %1,%2 is set to Custom, to show the value of a praticular row or cell for each plot in the layer.

@L,n: n-th X value; n in additional format

@V,n: n-th Yvalue; n in additional format

@WT,col,row: (row, col) cell value; col, row in additional format

ORG-5537Simple consolidated Object Properties dialog for all graph objects

Properties dialog and Programming dialog are combined to a simple consolidated Object Properties dialog.

Users are able to control transparency features of graph objects in Object Properties dialog.

A new system variable is added to enable/disable old Object Properties/Programming dialog:@OPD: (0/1, default is 0), 0 to disable, non-zero to enable.

ORG-13876Improvement of copying Multiple Graph Objects

Copying multiple graph objects where layer has Fixed Factor != 1 or Scale with Layer Frame (and layer resized) may cause the objects to loose their scaling in the previous version, that is fixed in Origin 2017.

ORG-14835Add legend support for Connect Data SymbolWhen user select Data in Box Chart Component and Connect Data Points, the Connect Line show with symbol in legend.
ORG-14397Update for Legend Symbol Width(%)Setting the Legend Symbol Width to 0% in Plot Details dialog (Legend/Titles tab),  whole legend symbol will not be drawn.
ORG-16104Add an option to control the start of leader line of the labelFor labels generated by label tab, we can change the gap between symbol and the start of leading line by "set %C -gtl 0".


Set Color Fill Transparency for Text Object (SR1)

When Text object has Frame turned on, user can set fill color transparency to get this effect:


Allows half-point font size such as 10.5, etc. (SR1)

In the past, font size in graph could only be set as integer.


Better default for square ended line and rectangle objects (SR1)

Default values of the following system variables are changed in Origin 2017 SR1

  • @lcg to 2 – line object
  • @lca to 2 – axis line

New system variable @lcr (default is 1) to set the cap of rectangle or legend or text frame
0 = Line cap round 
1 = Line cap square 
2 = Line cap flat

ORG-15278Use only category legend and auto update (SR1)Add a option for Categorical Legend update dialog named Use only category legend and auto update. When it's checked, you can change the Makes filter and see plot and legend updated accordingly.

Plot Manipulation




Support hatching in contour plots for geologists, geophysicists, civil engineers and more fill patterns are added

In Plot Details dialog, Geology fill patterns are added in GUI as well as more normal patterns. Users are able to customize different hatching in contour plots, pie charts or area plots.

  • For column, area, contour and boxes, more patterns are supported, including Geology patterns.
  • Make your own pattern by emf file and put it under \User Files folder\\Patterns\Geology or \Patterns\Normal

ORG-14775Easier way to change custom color

Click color blocks in Custom color to open Color dialog, then easily enter HEX code to set custom color.

ORG-14518Provide none color for border line

Add option to select none color for border line


Better color scheme for graph system theme

We have used our default black, red, blue, green color scheme for many versions. Some users felt the default are not good.

A new system theme Candy Colors & Light Grids is created so when plotting common 2D graphs, e.g. line, scatter, line+symbol, column/bar, box chart, etc. the new color scheme will be used.

Note: All 3D graphs and some 2d graphs don't allow system theme to override so when plotting those, it will still use the old color scheme and color palette.

ORG-14593Map symbol size to an expression of a column

Sometimes the values in Size Column are very similar and user can't see the size difference. E.g. all are big values, etc.

With Size formula, user can specify some math expression based on values in Size column.


Subgroup control in Unbalanced Grouped Column Plot

  • Show major gridlines in unbalanced group column plot
  • Set Gaps between subsets by Column instead of fixed size


Adjust sub-group spacing between subgroups of stacked column plot

ORG-13699Control how each plot attributes increment in subgroups of a group plot


New system variable added to define filtering with categorical data

Before filtering, please notice that GMC and Kia's color is Green and Cyan. With new system variable @GMHC, users are able to control whether keep original legend color or not. @GMHC = 0, means filtered data legend remains the same color as before filter, while @GMHC =1 means not.

ORG-14444-S1Dropline Direction Control in 2D and 3D graphs


Histogram Plot with Bin Counts or Percentage as Labels

Label tab is added in Plot Details dialog turn show Count, Percentage of both for Histogram plot.


Add AutoX as a fly-out option for Input:X in Plotting dialog

For some plot types, Origin will open a dialog first for user to specify input and settings before plot is made.

E.g. Trellis Plot, Stacked Plot, Grouped Column Plot - Index Data, etc.

In Input node, user can specify X to be <autoX> if user wants to plot against row indexing

ORG-13552Allow users to change the line color for Line Series plotImprove Line Series plot to allow users to change the line color.
ORG-12765Support Error Bars with Fill Area in Polar Chart

ORG-13835Support color mapping for inclusive broken optionFill Area now works for both inclusive and exclusive broken if have modifier.
ORG-14760Improvements for Box plots customization.

Improve auto coloring for lines inside box so that it will be shown as contract to the box fill color. Two new system variables are introduced:

@BAC: (default 1) works just like @DLC

@BACM: (default 1) to control the behavior of auto

Add an option to adjust the length of box chart line.

ORG-14117Improve debugging of Function plots

In both Function plot dialog and Function tab of Plot Details dialog of a function plot, undefined variable will be indicated in red. In addition, underline will be added to script when it interrupts.

In Y(x) dialog, add a Preview section that shows a table with two columns showing the actual XY values.

ORG-15389Update default speed mode threshold for 2D and 3D dataIncrease the default speed mode threshold for key templates.


Add a built-in Graph theme All Axes On (SR1)User can use it to easily turn all axes on in 2D Cartesian coordinate graphs.


Better Increment List control of different plot types when plotting multiple data together.(SR1)

When selecting multiple datasets and plot together, Origin will group them and use increment list of color, shape, etc. to distinguish them. In the past, user can set e.g. color list in Graph system theme so all graphs will have same color list. The disadvantage of this is that for different plot types, this may be not appropriate. E.g. for line plot, it's better to use some dark color list, while for column or area plot, it's better to use some light color lists.

In Origin 2017 Sr1,

  1. System Increment Lists tab is added in Theme Organizer dialog so user can easily set different color, shape, pattern, etc. list for different plot types.
  2. The order of plotting Origin graph is: first load the graph template to plot the graph, then apply system theme, finally apply the corresponding System Increment List. So you don't need to add color list in graph system theme now. Instead set it on System Increment List tab is more user-friendly and easy to understand. Of course other graph properties, e.g. tick directions, axis, etc. can still be set in system theme to get consistent look.
  3. If plotting with user-defined graph template, make sure when saving the template, checkApply System Theme & System Increment Lists to Override checkbox if you want system increment list applya to user-defined template.
  4. Context menu Set as System Increment List is added when modifying increment list onGroup tab of Plot Details dialog.
  5. You can also apply increment list to existing graph(s) on System Increment Lists tab inTheme Organizer, This only supports one list at a time and it will only apply to matching plot type.


Improvements in Floating bar to better make plotting the following kind of Energy Diagram easier. (SR1)

See more http://originlab.com/forum/topic.asp?TOPIC_ID=26067

User has X, Y and Label Data and wants to plot line+symbol graph but show each symbol as a horizontal bar and the lines should connect edges of the bars. It's hard to implement for Line+symbol graph since the line always connect to center of the points, plus even if implemented, horizontal bar width isn't adjustable.

We made the following improvements in Origin 2017 Sr1 so that user can achieve this by floating column graph.

Add Bar Graph show Zero Values checkbox on Graph tab of Tools: Options dialog to show an horizontal line if floating bar from and to values are the same.

page.BarShowZero=-1 (follow Tools: Options settings) , 0 (do not show), 1 (show)

Support connect lines between floating column/bars. Open Plot Details dialog. Select Layer on left panel. Go to Stack tab. Check Show Connect Line on Stacked/Floating Column/Bar checkbox. This checkbox was only working for stacked column/bars and was called Show Connect Line on Stacked Column/Bar in the past.

User can go to Spacing tab to and set Gap Between Bars to adjust bar width.

Graph Page and Layer


Easier way to push change layer drawing orders.

  • Context menu when right click layer icon or selected layer frame to
    • Bring o Front
    • Bring Forward
    • Push Backward
    • Push to Back
  • Buttons on Graph: Layer Management dialog.
  • Select a layer and click Back and Front buttons on Object Edit toolbar
  • Drag to move layer orders in Object Manager.

ORG-13470Exchange XY of Linked Layers togetherIn the past, if user has linked layers, such as Double Y, Multi-Y, multi-panel graphs, etc., when click Graph: Exchange X-Y Axes, it only changes current layer's X-Y axes. They are exchanged together now.
ORG-13834Support Fill to Grid Lines in Polar Contour

The default color fill setting for Polar Contour by Matrix is Fill to Contour Lines. Additional option is added as Fill to Grid Lines in Colomap/Contours tab


ORG-14416Better options for Merge Graphs

Enable Merge Graphs toolbar button when active window is workbook since user can merge embedded graphs in workbook.

When Merge Type is Specified, enable ... button for for embedded graphs.


laymplot X-Function is added to move plot(s) to new y axis/layer (SR1)

Many times, user asks how to move a plot to right Y axis. Before Origin 2017 SR1, user needs to move the plot from existing layer, add new layer with right Y axis. Then add plot to it.

In Origin 2017 SR1, we added an X-Function so it's much easier.

With graph window active, choose Window: Script Window

In Script Window, run
laymplot -d
to open the dialog.

Specify which plot(s) you want to move, e.g. 2 means 2nd plot. 2 4 means 2nd and 4th plots.

Click OK to move it.

Note: Plot customization such as color, etc. can't be moved to new layer. So we recommend move plot(s) first and then customize plot in each layer.




Drag text in tick label table to adjust height of width of table

In the past, the table row width/height is minimize to wrap the text in it. There is no way to adjust the offset.

ORG-10204Switching Layers in Axis dialog

For multi-layer graph, user can open axis dialog and edit different layer's axis. See the layer dropodwn list on the upp-left corner of the axis dialog.

In the past, user has to close the dialog and open the correct layer's axis dialog.


More options in Rescale dropdown list on Scale tab

If user want to fix the From value and auto rescale axis when new data comes in, please choose Fixed From - Auto To.

Our old Fixed From option is now renamed Fixed From - Normal To, since it fixes from value. And not rescale to value till user click rescale to show all.



Easy way to add multiple reference lines and share in between.

References tab is added in Axis dialog

  • Multiple reference lines
  • Fill area between reference lines
  • Alternate filling
  • Show Label of reference lines



Set tick label to be a combination of column labels.

E.g. to display Long Name (Units), set Custom Display to be:


Leader Lines for Special Ticks 

ORG-14615Wrap tick labels in 3D graphs

Supports tick label wrapping for 3D graphs to display long tick label better

ORG-14560Improve the custom-positioned ticks after break

Add First Tick option at the end of Break Detail: Scale after Break: Major Ticks Branch to specify the first tick after break.The Custom Position box supports the standard format of date and time data as well.


Keep line slope through axis breaks

Run page.breaktype = 1 represent real slope before and after break



Support Copy and Paste Reference Line to another graph.
ORG-7901New axis dialog

New Axis dialog for Radar, 2D Waterfall, Smith Chart, Polar, Ternary and 3D Ternary.

To use old Axis dialog, turn off bit 0x00000010 of @ADL.


White Out support for Tick Labels (SR1)

White Out checkbox is added on Format subtab of Tick Labels tab in Axis dialog

3D and Contour




3D Bar plot different shape for XYY and XYZ bars

ORG-14444S1Dropline Direction Control in 3D graphs

ORG-14444S2Origin doesn't support 3d bars in projected planes. But user can turn on dropline and set big line thickness to make the dropline looks like bars. But in previous versions, dropline end cap will show as semicircle. Orgin 2017 added system variable @lc3p to control it.
@LC3P=-1, Default. Old behavior. Semi-Circle
@LC3P= 0, compatible with OLineCap. Round
@LC3P= 1, Square
@LC3P= 2, Flat

With this feature, users are able to use thick dropline in projection plane as 3D bars on projection.


Group plots in 3D

The following plot types are supported

  • 3D XYZ Scatter
  • 3D XYZ Bars
  • 3D Matrix Bars

So user can easily set group increments of plot attributes

ORG-8720Support stacked XYY 3D bar graphs

The following plot types are supported

Improve stack plots with the following features

  • Display column/bar plot by sorted order;
  • Normalize to Percent for Cumulative/Incremental;
  • Error bar for stack and percent stack.
  • Wall & Ribbon support stack as bar


Support all 2D objects in 3D OpenGL graph, such as

  • Table, such as result table after fitting
  • Image
  • Rectangle, Circle
  • Bubble Scale
  • OLE object
ORG-14500Enable Bubble Scale for OpenGL(3d Scatter)

Size formula not only works for 2D graphs but also works for 3D OpenGL graphs,

user can specify symbol size using some math expression based on values in Size column.

ORG-14699Enable Reconstruct Legend toolbar button for 3D plotUsers are able to add and edit legend for 3D plots using Reconstruct Legend toolbar button.
ORG-14629Support 3D Stack Bars with multiple objects from matrix sheetSupport plotting all matrix objects together from active layer for 3D Stack Bars plot.
ORG-14656Support Button object for 3D graphsSupport Button object for 3D graphs.


 Add hot keys to easily do rotation and resize in 3D graphs instead of using control buttons with layer frame selected (SR1)

Click anywhere inside layer frame to select the layer. Then

1. "tab" to switch among the operation buttons (the last fix position button is not operation type) .
2. "x" to fix in x direction (rotate, resize, skew)
3. "y" to fix in y direction (rotate, resize, skew)
4. "z" to fix in z direction (rotate, resize)
5. "q" to fix in screen rotate.
6. "w" to fix in all 3 directions resize or rotate.
7. "shift+z" to fix in xy resize; "shift+y" to fix in xz resize; "shift+x" to fix in yz resize.


ALT+dragging annotation in Contour graph (SR1)Alt+Drag annotation to new location is supported in Contour graph now.




General: Not save mask info. in Analysis template by default

Save Analysis template will not save masking info. in input data since mask should really be associated with the data.

To save mask in template, set @atcm=0


General: Improvements on Results Log output (SR1)

Output quantity names in results log are consistent with names in dialog

E.g. Integrate tool. names used in results log are very simply, e.g. y0, x0, dx and user doesn't know what quantities they are. They are actually "Maximum Height", "X Value in Maximum Height" and "Peak Width at Half Height". So now in SR1, the Results Log output names contains both e,g. y0 (Maximum Height) = 15.6239....


General: Ignore hidden columns on analysis (SR1)

In the past, if we hide a column and then make a plot or do analysis, the graph or analysis result still contain the data which belongs to the hidden column(e.g. may not show in graph, but just unchecked).

In Origin 2016, we could directly ignore the data in hidden column when making a plot. And now, if we do analysis using tools with input as XY Range or XYZ Range, such as Average Multiple Curves, Nonlinear Curve Fit, Nonlinear Surface Fit tool, the data in hidden column will not show in the result.

ORG-16290General: Output sheet should be locked (SR2)

For operation that output result to a whole worksheet and locked, following operations are disallowed on the result sheet.

  • Insert column
  • Create new column
  • Set Column Value


Fitting: GUI changes on allowing initialize fixed parameters

In Fitting Function Organizer dialog (F9), add a checkbox "Allow Initializing Fixed Parameters" (default unchecked) above Parameter Initialization editbox; inFitting Function Builder dialog (F8), add a same checkbox on Parameter Initialization Code page, under "Always run Initialization Code before Fitting". This checkbox is designed to allow initialization code to modify the fixed value. When it is on, initialization code can read/write the values for fixed parameters.


Fitting: Easier Initial Formula for parameters in Fitting Function

  • In Fitting Function Builder, dropdown list to specify what initial formula to use based on X, Y data info, such as
    • XMin, XMax, YMin, YMax, XatY50, etc.
    • Simple calculations, e.g. YMax-YMin, etc.
    • Using Metadata from X and Y Data, such as Long Name, Comments, User-Defined Parameters
  • In NLFit dialog, for both built-in and user-defined functions, user can edit initial formula




New, Add and Search function buttons on Settings → Function Selection tab.

Show Recalculation Mode dropdown list above all tabs


Fitting: < and > two buttons in Parameters tab to switch between sets of parameters to compare fitting result

E.g. if you click 1 Iteration multiple times, you can click < and > buttons multiple times to see parameter value changes.

ORG-14335,ORG-14417,ORG-14964Fitting: More Built-in Fitting Functions

Add more Exponential association fitting functions with time offset parameter: ExpAssoc1, ExpAssoc2, ExpAssocDelay1,ExpAssocDelay2 under Exponential category.

Add three fitting functions for Photosynthesis Irradiance (PI) curve : PIPlatt, PIPlatt2, PIWebb under Exponential category

Add 3d Curve Functions: Helix and Line3 under in Multiple Variables category.

ORG-15001Fitting: Add result table for embedded report graphs

Users now have options to add result table to embedded report graphs, no matter whether fit was done from worksheet or graph.

ORG-13201Fitting: Compare Model supports global fitCompare Model now supports comparing the results from Global Fit.
ORG-15050Fitting: Update built-in FittingWithExternalDLL example with VS2012The old example was based on VC6 and didn't show how to create 64 bit version. A new example has been updated using VS2012.



Statistics: Two Way ANOVA supports Means Plot  Two Way ANOVA supports Means Plot



Statistics: Add conclusion to survival analysis, distribution fitting (Good-of-fit test)

ORG-16047   Statistics: Improvement for Power and Sample Size, One-Way ANOVA (SR1)Power and Sample Size, One-Way ANOVA adds Maximum Difference between Means option for  Specify Group Means Difference.

Data Processing



ORG-15402 S1

  • Indicator on upper-left corner of worksheet. Column Short Names case sensitive and not renameable, e.g. A, B, ...Z, AA, AB, ...
  • Window properties control

  • This is the default mode for Origin workbooks. Alphabetic short names will be used and not renameable.
  • Column formula can use Excel like A1 notation 
  • Refer to columns in other sheet or book is easier, e.g. Sheet1!B or 1!B, [Book1]1!B
  • Use Window Properties dialog to turn it off.

A new properties is added to Page object. Use page.xlcolname to control the Spreadsheet Cell Notation in current Workbook window.

A new macro clrx is added to globally turn off the Spreadsheet Cell Notation in Origin. Once the macro has been run, the Spreadsheet Cell Notation will be always off even restart Origin.

@RCN can be used to enables or disables spreadsheet cell notation (SCN) in the workbook.

  • 0 = Cell notation is turned OFF for all new books.
  • 1 = Cell notation is turned ON for new books created from the New Workbook toolbar button.
  • 2 = When importing, cell notation behavior follows active book; if cell notation is OFF, then OFF in all new books. If ON, ON in all new books.
  • 4 = Most analysis X-Functions have an Auto Spreadsheet Cell Notation on New Book check box that is shown in X-Function Tree View mode (exceptions are wsplitwsplit_bookmerge_bookwmove_sheet). When this box is checked and this bit is enabled, any new workbook created for X-Function output will have SCN turned on (Auto On) regardless of the SCN-state of the active book..

Note that bit values are additive (e.g. @RCN = 7 means cell notation is Auto On for conforming analysis tools (4), import follows active book(2), and SCN is ON for all new worksheets from toolbar(1)).

ORG-10977Formula updates when related column position is changed with Column Short Name Restriction is onSystem variable @DEFU = 1 to disable automatically update formula and return to the old code.
ORG-14364Improve F(x) row support

Lower case i and j refer to row number and column number respectively, while upper case I and J refer to column I and J respectively. Lower case letter, except for i and j, will be converted to its upper case automatically matching the existing column. New system variable @AUN = Auto UpperCase Name is added and default is 1 = ON.

XLColName is not only available to LabTalk script but also available in OriginC now.

ORG-14394More samples for custom data filter

In Custom Data Filter dialog → Filter → Load Samples list, add the following statistics filters

  • Discard Min and Max (for "Modified Mean")
  • Within Interquartile (Q1-Q3)
  • Within Interdecile (10%-90%)
ORG-14498Treat Hidden Rows as Skipped

In previous version, hidden row is treated as missing value. Now we improved it to treated as skipped by default.

System variable @GMH has been changed to have 3 options: -1 (default), 0, 1. -1 means to follow the hidden rows option on Worksheet Properties dialog.

Almost all analysis tools are well support hidden rows now. Please note that, when creating output, the output data will be placed in visible rows on destination sheet only.

For LabTalk access, hidden row is not considered in previous version. Now we changed it to follow the @GMH value, which meanshidden rows will be skipped by default.

ORG-11259Split Worksheet by values in reference column(s)

Split worksheet by reference columns in

ORG-14333Speed up deleting columns or workbook to a large extentDeleting thousands of (non-contiguous selected) columns or even a large worksheet no longer takes a very long time.
ORG-14661Support for Virtual Matrix duplication and transposing

Allow to duplicate or duplicate as transpose context menu in the Virtual Matrix Manager dialog


In workbook make it easy to add User Parameter row or move contents to it  (SR1)

User may not know they can they can  right click on column label row header to add user parameters. 

In Origin 2017 SR1,

  1. Double click on Long Name, Units or Comments (row header) will open Move to User Parameter dialog. User can specify User Defined Parameter name and contents will be moved there.
  2. Double click on User-defined parameter rows will open Rename dialog so user can rename it.
  3. Right click a row header and choose Add User Parameters will open a dialog for user to specify name. In the past, it will create a UserDefined row and user needs to right click to rename.


Split worksheet Improvement (SR1)

Support splitting partial range in worksheet. When splitting worksheet, user may only want to show some columns in the result sheets. In the past, all columns will be kept in result sheets which will not really needed and will cause slowness.

Allow presetting result sheet names. In the past, the result sheets were named as Sheet1, Sheet2, etc. Now a new option is added so user can preset the result sheet name. For example, use reference column's values, or dataset name, etc. as sheet name.


Support This keyword in Set Column Values dialog (SR1)

When turn on Spreadsheet Cell Notation in workbook, user can use This keyword in Set Column Values dialog to indicate current column itself. E.g. Total(This) will calculate the sum of current column. Also, This can have numeric suffix for cell reference, so This1 is the 1st cell, similar to A1.

In Set Column Values dialog, This keyword is also added under the Variables menu for easy access.

ORG-15968Matrix Image Crop on multiple object (SR1)Support cropping on multiple matrix/image objects in the same matrix sheet.





Excel Import: New Excel Import dialog without using COM support

Excel Import has been redone and no longer relies on the COM for import of *.xls and .xlsx/.xlsm files.

In practical terms, this means that you no longer have to have MS Excel installed to import your Excel files into Origin.

It only supports "Excel 97-2003" and "Excel 2007 and later"



Excel Import: New Excel Import dialog without using COM support

Excel Import has been redone and no longer relies on the COM for import of *.xls and .xlsx/.xlsm files.

In practical terms, this means that you no longer have to have MS Excel installed to import your Excel files into Origin.

It only supports "Excel 97-2003" and "Excel 2007 and later"

ORG-12950Excel: Import: Avoid DDE message if linked Excel is open inside opjSkip Excel DDE dialog if the linked Excel is open inside opj as well as the opj contains no Excel book that is not relative.

ORG-14358CSV Import: Support Sparklines for CSV import

For CSV import, Sparkline is turned on by default.

ORG-14502JCAMP Import: Import more metadata when import JCAMP fileimpJCAMP is improved to keep more metadata from the imported book.
ORG-15565TDMS Import: Improve precision of importing tdms fileMore accurate on converting system time to julian date.
ORG-14608Better third party file meta data import supportBetter treenode name for file info.
ORG-14505Short name will not be modified from import toolsProper handle metadata so that column short name will not be affected when "Excel-like column short name restriction" is ON.
ORG-14611Prompt Workbook Organizer for checking Meta DataA smart hint will be shown.
ORG-6175Support import multi-channel .wav file (SR1)

Data in multi-channel wav file can be imported in Origin 

Note: Partial Import and meta data(long name ect) have not been supported yet

ORG-14420Support appending file name without extension as column Comments (SR2)

From SR2, when user choose Append Filename to Column Comments in the import setting, the file name will be appended without extension.

Note: To revert back to old way, use system variable @IFE=0 

Exporting and Presentation

RG-13992Support paste plain text when copy text from other applications like Office

Add Unformatted Text option in Edit - Paste Special dialog to allow user paste plain text when copy text from other applications like office.


Export graphs in subfolders of project to corresponding subfolders under project File folder in Windows Explorer

Suppose i have test.opj with graphs in Folder1, Folder2 and Folder3 subfolders. I can directly export all graphs in project to corresponding subfolders under test\ folder in Windows Explorer.

Suppose user has graphs organized in multiple subfolders in a project. When export graph, choose Path to <Project Folder>\<PE path>. Exported graphs will be put to corresponding subfolders in OPJ file folder.

ORG-14664Hide Adobe Illustrator graph export

Adobe Illustrator (*.ai) is hided by default as an exporting image type option. If users want to edit graphs in Adobe, Enhanced MetaFile (*.emf) export is recommended. Or set system variable@HAI = 0 to show Adobe Illustrator option. By default @HAI = 1.

ORG-14505Short name will not be modifed from import toolsProper handle metadata so that column short name will not be affected when "Excel-like column short name restriciton" is ON.
ORG-14774Add Grayscale button in Print Preview

Add Grayscale button in Print Preview to help users to check the B&W effect of graphs quickly.

Batch Processing



Apply graph theme to all graphs in subfolders and specified graphs only

In the past, in Theme Organizer, user can only apply graph theme to Current Graph, Graphs in Folder and Graphs in Project. More options are added for user to apply theme to subfolders, embedded graphs, or specified graphs only.

ORG-14419Copy/Paste Format improvements

Add an option Paste Format (Advanced)... in both Edit menu and context menu of graph to allow user open Apply Formatdialog.

ORG-14899S2Batch plotting allow lower level meta elementExtend the batch plotting with option to duplicate plots from specified source.


Sequentially initialize parameter values in batch peak analysis


Add match modifiers by option to Batch plotting dialog (SR1)This option will affect the Match Modifiers by option of new created clone graph. 
But it should not affect the option of source graph.


Rescale Axes and Colormap Controls during Batch Plotting (SR1)

Project and Data Management



Add Latex in Axis Title and Legend

Try 2017 LaTex

\q() escape sequence for LaTex, e.g. \q(\alpha+\beta)

Double click Axis Title and then click LaTex app to add LaTex

Add Raw LaTex in worksheet column long name, units, comments, etc and see them in legend and axis titles in graph.

Right click column label row header and set Style to Rich Text to see LaTex in worksheet.


Allow customize column designation bySet As context menu or Column menu.

Right click multiple columns and choose Set As: Custom... to customize the column designations

E.g. L(XY) will customize columns to Label X Y X Y ...

This syntax is also used in Import dialogs. () means repeat.

ORG-14604Embed layout in worksheet

Support layout for Graph Browser so that not only graph but also layout could be added or inserted through Add Graph as Sheet, Insert Graph (into a cell) and Insert Graph toolbar button.

ORG-14395More options for displaying sheet name in Worksheet Browser

Add 3 more columns: "Name" (i.e SN), "Long Name", and "Comments", by default hidden, to better distinguish different sheets.

Programming and Connectivity



OC: support for dialogs using HTML and Java Script

We have added support for dialogs using HTML and Java Script.
Several examples are provided in this zip file. Extract the zip file to a folder on your computer.

Brief explanation on the examples and how to execute them:

  1. Dialog with a Graph
    1. Load and compile the file  HTMLGraphDlg.cpp into Code Builder, right click the User Folder and choose Add Files..
    2. Set up a worksheet with XY columns with data, and select the two columns
    3. From script window, call the function: HTMLSample
  2. Google Map
    1. Load and compile OGoogleMap.cpp to Code Builder User folder
    2. From script window, call the function OpenGoogleMapDlg
      NOTE: This example uses IE, and may have issues with specific versions of IE. We are looking into it.
  3. Simple Calculator
    1. Load and compile Calculator.cpp to Code Builder User folder
    2. From script window, call the function OriginCalculator_Main
  4. Stock Chart
    1. Open the Origin Project: Apple.opj
    2. Press the Dialog button
ORG-14540OC: Easier way to open specific page of CHM file

Origin C GETN supports opening specific page of CHM file.

X-Function supports opening specific page of CHM file by ID.

ORG-14499OC: Provide Origin C function to get the number of major ticksTo get the number of major ticks in a graph, call Origin C function: int GetAxisTickData(vector& arrTicks, int nType = OC_MAJOR). This function returns arrTicks size; if fails, return -1.
ORG-15364OC: Allow saving opj while dialog is up

Add Origin C command to save the active project

BOOL Save( LPCSTR lpcszFilename = NULL, BOOL bRename = true)
ORG-14652OC: Support color setting for the wizard navigator in Origin CAllow users to change the background color in the navigator control of a wizard in Origin C


OC: OC Function to Convert HTML Color to OCOLOR (SR1)Add a new OC function okutil_HTML_to_ocolor(LPCSTR lpcsz) to convert HTML color string (e.g. "#00FF00") into Origin OCOLOR.
ORG-14343Labtalk: Support passing over vector string to StringArray when calling X-Functions using LabTalk

All dataset variables in LabTalk used to be numeric. "dataset -a name" is used to create a StringArray dataset for users getting dataset names back from X-Functions.

ORG-14660Labtalk: Support more LabTalk options for Fill Area Under Curve

Support more options for set -pfv command in LabTalk. For example, Fill to next data plot - one color is now can be generated using "set %C -pfv 8; set %C -pf 1;". Note: set fill mode first then turn the fill area option on.

To control fill to next mode, use "set %C -pfn nn;" where nn = 1 for Common X Area and nn = 2 for Area Enclosed by End Points.


Labtalk: wclear XF adds ability to clear label areaIt is mapped to a new bit CWOD_CLEAR_LABEL_ROWS allowing clear the label area.

Labtalk: LabTalk command added to set fill pattern by name

set %c -tb -PFPN "filenamewithoutext"
ORG-13891Labtalk:Create LabTalk callable function to calculate the great-circle distances between two points.

double HaversineDistance(double lon1, double lat1, double lon2, double lat2, double r, bool bDegree)

This function takes the longitudes and latitudes of two points on a sphere with radius r, returns the great-circle distances between them. Option degree determines whether to use degree or radian as the unit of longitudes and latitudes.

ORG-15402Labtalk:LabTalk command to save a system variable same as entering into the system variable dialog

add_sys_vars function is added which needs to be used after run -oc, like run -oc add_sys_vars XCA|RCN 0|0

macro clrx is now defined as doc -e WW {page.xlcolname=0;};run -oc add_sys_vars RCN 0;

ORG-15339Labtalk: LabTalk command to hide/show image thumbnails
page.activedataIndicator=0;  //hide image thumbnails


Labtalk: page level variables v1 to v4 (SR1)

Introduce page level variable page.v1$ ~ page.v4$ (both numeric and string are supported), User can use it to associate a variable with a page.

One example: User has multiple workbook and user want to define a workbook level variable to use in set column value calculation.

E.g. in Set Column Values dialog

Write page.v1=1.1; in Before Formula Script

In Formula box, enter e.g. page.v1*A to get the product of column A times this v1 variable.

ORG-16265LabTalk access for Show at Specified Indices Only of plot label (SR2)

New switches are introduced to access the Show at Specified Indices Only option for plot label in set/get command.


  • set name -qmie value: Turn the Show at Specified Indices Only checkbox on or off
  • set name -qmi dataset: Set specified indices


Python: Support adding permanent system path for Python.When external Python is installed, their path will be added to the embedded Python path list.


Python: Update Origin to latest PythonPython version is upgraded to 3.5.2 and 2.7.12.
ORG-14696X-Function: Improvement on X-Function frameworkSupport tab-changing event and tab style for X-Function bar.
ORG-2968Mathematica Link: Support communicate with individual instance of Mathematica

Update sequencer.exe to 64-bit so that users are able to work between Origin and Mathematica (v7,v9,v10).

ORG-14759ocz file support pro only and current user onlyAdd two checkbox pro only and current user only in in password dialog when creating new ocz file.




Undo support after customizing graphs in Plot Details dialogAfter closing Plot Details dialog, Ctrl+Z or Edit: Undo to undo the changes.
ORG-15213LaTex App Improvements

Download and Install 2017 LaTex App

Support Latex in Axis title, legend, worksheet column label area

  • Double click Axis Title to go into in-place edit mode. Click LaTex app to add LaTex
  • Use \q() escape sequence to add LaTex.
    • Adding LaTex with \q() in column long name, units, comments, etc and see LaTex in legend and axis titles in graph. See column long name and legend below.
    • Check Rich Text for column label row style to see rendered LaTex in worksheet. See Comments below.
    • Use \q() to add laTex in any text object.

In LaTex Equation Editor, click f(x) to load Latex equation of fitting function

New Apps
•Manhattan Plot for GWAS
•General Linear Regression (PRO)
•Means Plot (PRO)
•3D Stacked Histograms (PRO)
•Enzyme Kinetics (PRO)
•Piecewise Fit (PRO)
•Logistic Regression (PRO)
•Simple Time Series Analysis (PRO)
•Principal Component Analysis (PRO)
… and more

View more apps: www.OriginLab.com/Apps


System Variable:The read-only system variable @OLCID is added

New system variable @OLCID is added to return the locale of the resource which Origin is currently running. In English mode @OLCID = 1033; in German mode @OLCID = 1031; in Japanese mode @OLCID = 1041.

ORG-14689System Variable:Remove system variable OCSENew generated OP files will be encrypted. Remove the way to generate un-encrypted OP files.
ORG-16137System Variable: Add a system variable to disable MRU menu (SR1)

A new system variable @MRU is added to disable the most recent used menu item. Default is @MRU = 7, means all enabled.

  • 1 = Enable plot menu MRU
  • 2 = Enable analysis menu MRU
  • 4 = Enable loading theme into menu
ORG-16188System Variable: Add a system variable to control closing down (SR1)

A new system variable @EC is added to control the closing procedure. Default is @EC = 0, means exiting Origin normally.

  • 0 = Normal
  • 1 = Do not close current project
  • 2 = Do not exit current instance
  • 4 = Do not dump closing message about @EC to Message Log

Note: @EC can be a combination of these controlling bits to produces cumulative effects.