Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Graphing

New Graph Types

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-29592

Icon improvements on left panel of Plot Details dialog

Much easier to tell a plot is a single plot or belongs to a group

In the past, when open a complicated graph to customize plot, it’s hard to tell if a plot is a single plot, or belongs to a group. For grouped plot, some Tabs only show when 1st member in the group is selected.

In Origin 2025, a single plot is denoted by image-20240823-142637.png, a plot blonging to a group is denoted by alternatingimage-20240823-142656.pngimage-20240823-142923.pngicons

image-20240830-204700.png

ORG-29715

Grouping plots gets easier

Group nonadjacent plots and create multi-groups

Change of behavior and context menus changes in Object Manager to make it easier to group plots in a layer

  1. New behavior of Set as Group Begin and Set as Group End: Right click a member in a group of plot and choose Set as Group Begin or Set as Group End will break the current group into two groups. In the past, plots before Set as Group Begin or after Set as Group End would become isolated single plots.

  2. New Move as a New Group context menu: Select adjacent or non-adjacent plots in a group to move them into a new group. In the past, many steps were needed.

  3. Group non-adjacent single plots: For isolated single plots, no matter same plot type or not, ctrl+ select them, right click and choose Group to make a new group with 1st plot’s plot type.

ORG-29949

System variable for no element rescale when making new graphs

System variable @SLF to set fixed factor 1 when making new graphs with built-in or extended graph templates

In older versions, if user resize the graph page, or resize the layer in graph, the text label font size, the plot line and symbol thickness, the axis line thickness will rescale accordingly. This Scale Elements setting is a layer level property controlled on Size tab of Plot Details dialog. The default is Scale with Layer Frame.

For users who want to keep font size, etc. no matter how you resize page or layer, go to Preferences: System Variables dialog. Set SLF value as 1. (0 by default).

Workaround in older versions:

  1. Choose Preferences: Theme Organizer…

  2. On Graph tab, right click it and choose Set as System Theme to apply it for all new graphs in the future.

Note: User can also select Layer No Element Scaling theme and apply it to all existing graphs. And there is Graph: Fix Scale Factor… menu to set fixed factor for single graph.

ORG-27177

Data Slicer on Graph

Add data slicer to graph to filter data

Three ways to add data slicer on graph. Slicer is on graph so source worksheet will not be filtered.

  • Data: Slicer… menu

  • Click the old Data Filter button. //button in pressed stage if there is filter on graph. Click it again will remove all filters in graph. Ctrl+Z to undo.

  • Click the Data Slicer button on page level mini toolbar

image-20240730-154029.png

Basic usage

image-20241003-135750.pngimage-20241003-135818.png

More options when right clicking on filter. E.g. right click a text type filter and check Multiple Selection so instead of a dropdown list, user can pick multiple items in column.

image-20241003-140006.png

image-20241003-140757.png

Or right click to disable filter, delete filter or change filter to be another column

image-20241003-140818.png

Right click in blank area to add another filter

image-20241003-140851.png

Compare plots with different conditions

For single layer graph, use Duplicate Plot option to add duplicate plots in same layer with different filter conditions for each plot

image-20241003-135032.pngimage-20241003-135104.png

Or duplicate into multiple layers with different filter conditions for each layer

image-20241003-135240.png

image-20241003-135340.png

Add Filter to control all layers in graph

For multi-layer graph, user can add filter to page level (check Common Filter for All layers/Plots) or to layer level (uncheck it)

image-20241003-134522.png

Set condition will affect all layers

image-20241003-134728.png

ORG-29671

Easy way to change all plot’s X data in a layer or whole page

Change X context menu on Layer and Page level

Right click in blank area within layer and choose Change X to change all plot’s X to be certain column.

Right click outside all layer frames and right click to change all plots in all layers' X to be certain column.

Note: There was only Change X context menu on when right clicking on a plot. User would have to click each plot to change the X data or go to Plot Setup dialog to change so. It’s cumbersome.

ORG-28659

Error bar tooltip

The error bar tooltip provides numerical details of the range of uncertainty around data points in a graph.

The x and y error info shows when mousing over data points plotted with error bars, or when mousing over error bars.

image-20240531-201244.png

ORG-28723

Swap layers or swap graph objects

Select position of two layers, or two graphic objects

Swap position dropdown list is added on mini toolbar if two layers, or two graphic objects are selected.

It also shows on Object Edit toolbar on right side of workspace.

E.g. shift+select two layers and click the button.

image-20240716-082625.png

ORG-28721

Show Layer info in the Graphs list box

List Layer numbers in parenthesis after corresponding Graph name

This helps user to associate graphs and its layers in preview window when merging graphs

image-20240604-143759.png

ORG-29082

Add Note for Layout Window

Adding notes for layout window from Object Manager

Notes could only be added to graph window in Origin 2024b. In Origin 2025, notes can be added to layout window as well.

With Layout window active, click the Add Notes button on top of the Object Manager.

image-20240603-191939.png

If there is notes for a layout window, there will be + inside the icon. Click it to read the notes.

ORG-28263

3 List orders in Batch Plotting Dialog

More ways to sort available books and sheets in Batch Plotting dialog

There was no sorting order option in Batch Plotting dialog.

Before Origin 2024b, books show in creation order and sheets show in appearance order. In Origin 2024b, both books and sheets show in alphabetic order.

In Origin 2025, 3 sorting modes are added. Click the column header to toggle them.

  • Unsorted (default, old behavior before Origin 2024b)

  • Sort ascending (default in Origin 2024b)

  • Sort descending (similar sorting criteria as above type 2, but descending).

Note: Sheets in same book as source graph always show on top.

image-20240619-162850.pngimage-20240619-162938.pngimage-20240619-163002.png

ORG-28297

Plot Menu for Image Window

Support plot menu for floating image window.

Float the image window to the other monitor then check the Plot menu

ORG-29079

Remove the limitation of 16 color toolbar icon for custom toolbar

Supoort 32bit color toolbar icon in custom toolbar

Before Origin2025, only 16 color toolbar icons are supported. If you choose a 24bit or 32bit color image for custom toolbar and restart Origin, you will get Button group bitmaps must be 16 color message.

ORG-29031

Histogram Auto Binning improvement for arithmetic sequences

Histogram Auto Binning improvement for arithmetic sequences

When count(unique(input))<=10, we can sort the unique(input) and check if they are arithmetic sequences. In an arithmetic sequence, the difference between consecutive terms is always the same. If they are arithmetic sequences, assume the difference between consecutive terms is delta, bin size=delta, bin begin should be min-delta/2, bin end is max+delta/2.

Implemented in Origin2025.

ORG-16510

Smartly adjust ticks when zoom in the graph

Improve the rule of showing ticks to show better ticks values when zooming in

In Origin2025 before, improve the below case that sometimes too few ticks sometimes too many ticks

  1. Zoom in graph with hotkey/red dot

  2. Apply scale of ROI in image to graph

ORG-29207

Save To Cloud support for project files

Support saving project to cloud

Can save project to cloud by menu: File: Save Project to Cloud…

If there is existing opju file with same name on cloud, for OneDrive/SharePoint, will show dialog to ask replace or not; for Google Drive, save it directly.

ORG-29595

Enable Template Library Toolbar Button for Image Window

When image window is active, the menu “Plot → Extended Templates“ and Template Library button is available.

Import an image to image window then choose the menu “Plot → Extended Templates“ or Template Library button.

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-29644

Paste Link from Excel Files on Cloud

Copy from xlsx files on cloud and paste link to worksheet cells

Open excel files from cloud in MS Excel. Copy data and paste link to worksheet in Origin.

ORG-28316

Set Date/Time Sampling Interval

Define a sequence for time or date by a start value and an increment value

Select data column and click the Sampling Interval mini toolbar button or choose Column: Set Sampling Interval… menu to define Date/Time based sampling interval. (Only Numeric was supported before Origin 2025)

image-20240522-212746.png

For column with sampling interval, image-20240522-213025.png icon shows at the corner.

  • Double click to read sampling interval info.

  • Select the column and choose Column: Show X Column to display the Sampling interval column to the left of the data

image-20240522-213148.png

Note: When plotting a column with sampling interval, it will use the inclusive sampling interval for the column instead of any X column to its left.

ORG-29184

Improved hotkeys for data editing

Same hotkey combinations as Excel to highlight contents of a cell and select entire rows or columns

Highlighting Content Inside a Cell:

  • Ctrl + Shift + End, or Ctrl + Shift + Down to highlight from cursor location to end of the cell

  • Ctrl + Shift + Home, Ctrl + Shift + Up to highlight from cursor location to beginning of the cell

Highlighting Whole Column/Row:

  • Ctrl + Space to select whole column

  • Shift + Space to select the whole row

ORG-29058

Show/Hide All User Parameters Mini Toolbar

Show or hide all user parameters rows to leave more space for data area in worksheet

Single click on any user defined parameter row header and click the new Hide/Show All User Parameters button to hide all user-defined parameter rows. Click again to show all.

This provide a quick way to hide all user-defined parameter rows on top of data so you can see more rows in data area.

image-20240531-203133.pngimage-20240531-203239.png

ORG-29123

D0 for Last User Parameter.

D0 now refers to the last user parameter.

D0 is changed to refer to last created user parameter row instead of 1st user parameter row. E.g.

  • Col(B)[D0] and col(B)[D0]$ can be used to refer to column B’s last user parameter row value or text respectively.

  • wks.merge(D0, 1) - merge last user parameter row if neighbouring texts are the same

  • Substitution notations %(Sheet1!,1,D0), %(1@W,2,D0)

ORG-28891

Maximum column width for long name when importing data

System variable @MCWL=15 (default) to set long name max column width when importing data

@MCW and @MRH to control the max column width and max row height when importing data.

New system variables are added

  • @MCWL - controls the long name max column width

  • @IXFC is – controls if Import XF follows the connector or not. 1 (Default): follow the connector. 0: does not follow the connector.

ORG-29494

Make XF text2cols accessible on menu

Choose Column: Text to Columns main menu to open text2cols XF.

Add text2cols XF in main menu to split a single column of text into multiple columns.

ORG-29540

Reduce Columns Supports By Column Labels

Merge Columns by Column Labels

Add an option Merge by Column Labels for the Reduce Methods in the Reduce Columns tool. The columns with the same column header labels can be merged with the row statistics.

ORG-29636

Mouse wheel to scroll sheet

Support mouse wheel to scroll sheet tab for book window

When mouse over sheet tab, support mouse wheel to scroll the sheet tabs. So it is easier to navigate sheet when there are many sheets. Both workbook and matrix book are supported.

ORG-29332

Easier way to build Summary Sheet

Added new context menu on sheet tab named “Add Summary Sheet for Batch Analysis” right below “Add Notes as Sheet” to build Summary sheet.

Add_Summary_Sheet1.gif

ORG-29742

Enter value in F(X) applies to whole column

For columns with sub range set with values, enter F(x) will ignore subrange setting and apply to whole column

Sometimes user highlights a range of cells in column and set its value. Such sub The formula shows in F(x) cell but will only be applied to the specified sub range in the future. Later user may forget this and wonder why changing F(x) failed to apply to the whole column.

In Origin 2025, system variable @FXR (default 1) is added:

  • 1 - new behavior. Type new formula in F(X) will update the whole column

  • 0 - old behavior. Type new formula in F(X) will only update the subrange

ORG-29794

Update Book Name in Cell Formula When Duplicate Folder

Check all col/cell formula and identify references to a book in the same folder and update accordingly

If there are cell or column formulas refers to a workbook in same folder, when duplicating such folder, corresponding cell and column formulas will be updated to refer to corresponding book in new folder instead of the original folder.

ORG-29933

2nd level of Indirect Indexing

Specify row info. in other columns and use it in formula

Multi-level of indirect reference of row indexing is supported. Note: [ ] is used to specify row number.

  1. Start a new worksheet.

  2. Run the following LabTalk script

  3. wks.ncols = 7; range r1=1, r2=2, r3=3; r1=data(1,32); r2=data(5,20,5); r3=data(2,3,1);

  4. A[10:15] and A[B2:B3] in Fx cell of column D and E will put data from row 10-15 of Column A into the column.

  5. Multi-level of indirect indexing in [ ] not supported in the past. E.g. A[B[C1]:B[C2]] and A[B[C[1]]:B[C[2]]]. They are supported in Origin 2025 to get same output.

Import

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-28665

Import all sheets with Excel Connector

<All> option added in Excel Sheet dropdown list in Excel Connector

In Origin 2025, user can choose <All> import all sheets at once.

Drag an drop Excel file uses <last used> settings. So if you pick <All> to import all sheets and later drag other Excel files, all sheets will be imported as well.

Note: If you pick a specific sheet to import and later drag and drop another Excel file without such sheet name, 1st sheet will be imported.

ORG-29128

Connect Multiple Files into Same Sheet

Append files row wise or column wise in same sheet

In Connect Multiple Files dialog, options to import multiple files into same sheet are added.

  • Append to Same Sheet as New Rows or New Columns.

  • Insert the full file name or extract meaningful information from a specific part of the file name.

image-20240620-161321.png

ORG-29211

CSV Connector Recognize Date Format for England Date Time

Added system variable @IDT and improve CSV Connector to auto detect “dd/MM/yyyy HH:mm” date format.

1.Added system variable @IDT=0(default), when set @IDT=1, will import date and time data as text.

2.When import “dd/MM/yyyy HH:mm” date format data, will auto detected it as date and imported it into column as date format.

ORG-29160

Better handle for date conversion without time part for 00:00

Improve CSV Connector to support auto detect the iso date data without time part and append “ 00:00:00”.

For below iso date data, will append “ 00:00:00” to “1998-01-01” and import as “yyyy-MM-dd HH:mm:ss”.

Code Block
1998-01-01
1998-01-01 01:00:00
1998-01-01 02:00:00
1998-01-01 03:00:00
...

ORG-28512

Data Connector Undo and Redo

Supported undo and redo for Data Connector.

Data Connectors support undo and redo for following actions.

  1. Remove data connector

  2. Remove data connector from all books

  3. All Navigation Panel Context Menu

    1. Connect as New Sheet(s)

    2. Connect by Duplicating Active Sheet

    3. Delete Connected Sheet(s)

    4. Add to Active Sheet

    5. Remove From Active Sheet

ORG-28648

CSV connector save Post Import Script as Default

Improved CSV Connector to support save Post Import Script as default settings.

Save post import script as default.jpg

ORG-28981

Better way to indicate project files opened from cloud

When open project from cloud, should show the cloud path on title bar.

Cloud path on title bar.jpg

ORG-29162

Google Sheet Connector App

Introduced GoogleSheets Connector to support import Google sheet(s) from Google drive or Google sheet(s) URL

  1. Select Data: Connect to File: Google Sheets to import google sheet from google drive.

  2. Select Data: Connect to Web… to import google sheet from google sheet URL.

ORG-27049

CSV Connector supports append columns from script

Added a bit 128 for LT wks.dc.flags to support append columns to import.

Example:

Code Block
string next, fname, path$=system.path.program$ + "Samples\Batch Processing\"; 
findfiles fname:=fname$ ext:="*.csv";
wbook.dc.add("CSV");
wks.dc.flags=128;	// turn on append cols mode
loop(ii,1,2)
{
	next$ = fname.GetToken(ii, CRLF)$;
	wks.dc.source$=next$;
	wks.dc.import();
}

ORG-29757

CSV connector default to not open CSV Import Options dialog

Use CSV Connector to import ASCII file will not show CSV Import Options dialog by default.

When start CSV Connector by following ways, Show Options checkbox will be not checked by default.

  1. Choose menu Data: Connect to File: Text/CSV

  2. Clicking Import Single ASCII (Ctrl+K) toolbar button

  3. Click app icon.

APPS-1582

New LiDAR Data Connector

New Data Connector allows LAS or compressed LAZ files to work with LiDAR data.

The LiDAR Data Connector accepts .las and .laz files. These files are structured to contain 3-D x,y,z-tuplet point cloud data.

ORG-29694

Excel Connector issues on Excel Cell Comment

Improved Excel Connector to support importing cell comment.

Import cell comment from Excel sheet as inserted note in Origin.

...