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

Data Filter For Graph

Graph based Data Filter without affecting worksheet

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

image-20240730-154029.png
  • If there is already filter in worksheet before plotting graph, a prompt will be given

    image-20240730-154112.png
    • 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.

    image-20240730-182529.png

  • 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
      languagecpp
      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
      languagecpp
      //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
      languagecpp
      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
        languagecpp
        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.

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

Analysis

General

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-29391

Copy All Open Branches as Image In Report Sheet

Context menu added on the hierarchical result sheet to copy all open branches as an image

Right click anywhere on result sheet and copy all open branches as an image. Then paste it to Word, Powerpoint, etc.

image-20240813-214813.png

 ORG-26576

Export Table on Hierarchical Report Sheet to ASCII

Context menu to directly export table as ASCII file

 Right click on any table you want to export to ASCII and select Export ASCII….

Click the path created on Messages Log on left side of workspace to open the file.

image-20240605-162417.png

ORG-29511

Analysis on Graph Data Filter

The graph with data filter will create virtual dataset. And the analysis will be performed on the virtual dataset.

  1. Analysis on the graph with data filter and the result will be output to new hidden book by default.

  2. Support duplicating the operation or not when duplicating the graph.

  3. Click the operation lock and choose Go to Source and then the graph with data filter will be activated.

  4. The result book will be deleted when graph/plot/data filter is deleted.

Limitation:

  1. Ignore Hidden Rows is not supported when analysis on graph with data filter.

  2. Output option in analysis tool is disable when analysis on graph with data filter.

...