Page Comparison

ORG-27177

Testing feature: Data Filter For Graph - hide by default @shdf=0

Graph based Data Filter without affecting worksheet

Turn on Data Slicer to set different filter condition on each graph without affecting worksheet data

• If there is already filter in worksheet before plotting graph, a prompt will be given

  

  • Show Data Slicer (old way) - changing filter in graph will affect worksheet and vice versa.

  • Convert worksheet filter to graph based will remove filter condition in worksheet and convert it into a graph based filter. Change filter condition will only apply to current graph

• Click Filter to change filter condition; right click on a condition for more options including moving the condition orders, deleting the filter, etc.; right click in blank area below existing filters to add more filter conditions.

  

• Related LabTalk Access

  • Command to convert graph with worksheet data filter to use graph based filter and take over the filters on worksheet

    Code Block
    language cpp
    page -df; //convert to SDF //data filter still shows in source worksheet and row is hidden page -df 1;//convert to SDF and remove filter from source worksheet //no data filter in source worksheet and no row is hidden

    Similar to page -df, you can also try below command

    Code Block
    int nUID = layer.plot1.DF(); nUID=;

  • To see datasets used in the dataplot, try below command

    Code Block
    list pl;

  • To show Graph Data Slicer pane, run below script

    Code Block
    page.cp.type = 5;

  • New LabTalk Object SDF is implemented to access the graph based filter used for the plot, says Shared Data Filters object.

    Code Block
    language cpp
    //Suppose active graph plotting with graph based filter int nUID = layer.plot1.SDF; SDF ff = nUID; ff.wks$ =;//read-only, worksheet range, "[book2]sheet1" ff.enable =;//to allow temp disable ff.nf =;//read-only,number of columns to have filter ff.f1.col =;//first filter on which col ff.f1.filter$ =;//query string ff.f1.filterx$ =;//the x variable used inside the filter ff.Set(D:3:"between(18,23)");//replace col(D) filter if already existed

  • To retrieves the state of data filters in the active graph, use command

    Code Block
    language cpp
    page -dfs nn; //nn = 0: no data filters detected //nn = 1: data filter present in at least one worksheet providing the data for at least one dataplot in the graph //nn = 2: shared data filter used by at least one dataplot in the graph //nn = -1: error

    or method

    Code Block
    nn = page.GetDF(str$); //str$ is a string variable to receive the worksheet range

  • When no data filter is used by any of dataplots, either as worksheet data filter or as a ShDF (execute the above command page -dfs nn; it must return 0), run below command to add a graph based filter.

    Code Block
    page -dfn ColNameOrNumber;

  • Create Shared Data Filters (ShDF)) from Worksheet

    • Define/Modify a Shared Data Filter from active worksheet

      Code Block
      language cpp
      worksheet -shdf uidShDF [[colname:filtertype:filtercondition]] //uidShDF is the name of the LabTalk variable which will receive the UID of the created ShDF

    • Create virtual datasets using existing ShDF

      Code Block
      create name -vsshdf worksheetrange uidShDF;

    • Example

      Code Block
      fname$ = System.path.program$ + "Samples\Statistics\automobile.dat"; newbook; impASC; worksheet -shdf uidShDF [[D:3:"between(16,23)"]]; create myshdfvsy -vsshdf col(F) uidShDF; plotxy iy:=(C,myshdfvsy) plot:=202;

  • Command to dump Shared Data Filters in worksheet

    Code Block
    worksheet -shdfd;

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.

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.

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

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.

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.

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

For column with sampling interval, 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

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.

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-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 , a plot blonging to a group is denoted by alternatingicons

ORG-29332

New sheet tab context menu and GUI 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.

Image Added