Origin 2025b Features

Origin 2025b Features

Graphing

New Graph Types

JIRA

SUMMARY

DESCRIPTION

DETAILS

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-28452

Treemap Plot

support Treemap in plot menu

Plot: Categorical: Treemap

ORG-30655

Run Chart

A run chart, also known as a run-sequence plot is a graph that displays observed data in a time sequence.

The plot is under Plot > Statistical: Run Chart

Select at least one column to create run chart. For multiple columns, each row is one subgroup.

Origin's Run Chart plots the collected data by specified subgroups; each subgroup contains the observed data from the same time. All observed data will be plotted as vertically arranged dots by subgroups, and the mean or median of each subgroup will be plotted as Line+Scatter plot against the time series. A horizontal dash line at mean or median of whole input data will be added as the reference line.

image-20250623-074047.png

 

ORG-30666

Interaction Plot

The interaction plot looks like a Scatter Matrix, shows a matrix of interaction plots.

The plot is under Plot > Statistical: Interaction Plot

Select at least one data column and one factor column to create interaction plot by factors. In a Interaction plot, the number of rows and columns are both equal to the number of grouping variables(factors), each panel(except the diagonal panels) indicates the interaction of the row effect with the column effect.

When you select N factors, you will get N*N layers(cells). For the (N, M) cell, get the mean of data column by Nth and Mth factor. Then plot Mth factor in X direction against Y as line+symbol plot, Nth factor set to subset column. Note: Cell (N, M) and (M, N) share the same data in the result plot data sheet.

image-20250623-074513.png

 

ORG-30379

Symmetry Plot

Symmetry Plot can be used to determine whether the response data is symmetrically distributed.

The plot is under Plot > Statistical: Symmetry Plot

Select at least one column to create symmetry plot.

To create a symmetry plot, Origin will

  • sort your data in ascending order;

  • calculate the median value of dataset;

  • draw a scatter plot with the upper distance of the median on the X axis against the lower distance to the median on the Y axis;

  • add a reference line Y=X to represent a perfectly symmetric sample;

  • create a histogram plot to show the shape of distribution, with a reference line at median value

image-20250623-075008.png

 

ORG-30665

Main Effects Plot

The Main Effects plot is very useful when you have several categorical variables. You can use it to compare the changes in the level means to see which categorical variable influences the response the most.

The plot is under Plot > Statistical: Main Effects Plot

Select at least one data column and one factor column to create main effects plot by factor(s).

Origin's Main Effects plot allows you selecting multiple response data as Input data and multiple categorical varaibles as Factors. Each input column will be plotted as a seperate Main Effects plot, and each factor will be plotted as a graph layer. In each layer, each value of the factor will be plotted as a data point with its mean response values. The mean of whole response data will be plotted as a dash reference line.

image-20250623-091155.png

 

ORG-17608

Cumulative Distribution Function plot (CDF Plot)

CDF plot, fully-named as cumulative distribution function plot, is used to examine the distribution of a sample data

The plot is under Plot > Statistical: CDF Plot

Select at least one column to create Empirical CDF plot and/or Theoretical CDF plot.

Select multiple data and group column to compare cumulative distribution of different data/groups.

CDF plots shows the empirical and/or theoretical cumulative distribution function of the data. You are allowed to decide how to arrange multiple source data and their groups. And the distribution information values(mu, sigma and N) for each groups of each data will be output to the result graph(s) automatically.

image-20250623-091057.png

 

ORG-29624

Polar Vector θrAM

Polar Vector θrAM is a XYAM vector in the polar coordinate, the θRAM columns contain the angle and radial coordinates of start points, the offset angle and magnitude of the vectors.

The plot is under Plot > Specialized: Polar Vector θrAM

Select X(θ)Y(r)YY columns to create vector plot (or quiver plot) in polar coordinate. 2nd Y represents angle, 3rd Y represents magnitude.

User can go to the Vector tab of Plot Details to customize the vectors.

image-20250623-091046.png

 

ORG-29635

Polar Contour + Gradient Vector

Polar Contour + Gradient Vector graph is a polar contour graph with a gradient θrAM vectors plot overlaying.

The plot is under Plot > Specialized: Polar Contour + Gradient Vector

Select X(θ)Y(r)Z columns or matrix data to create gradient vector plot (or quiver plot) overlay contour plot in polar coordinate.

The X-Function plot_mquiver or plot_xyzquiver is used to create such graph, same as the graph Contour Line + Gradient Vector.

image-20250623-091027.png

 

Annotation

JIRA

SUMMARY

DESCRIPTION

DETAILS

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-30150

Elbow Arrow

Add elbow arrows like Prism

Single elbow arrow is added in Arrows group on Tools toolbar.

See hint when mousing over the toolbar button or on status bar. E.g. Press Shift key while drawing it will create segement with arrow horizontally.

Click on the arrow object to use mini toolbar for further edit.

ORG-29686

Specify the angle value for angle annotation directly

The angle of the angle annotation could be dynamically updated based on the angle value input by the user.

In Dimension tab, add Method option after Units, list

  • 3 Points: current method

  • Angle and Magnitude: New Default.

ORG-30307

Change add Asterisk Bracket Tool

Add Asterisk Bracket object like Prism

Dragging rectangle to create an Asterisk Bracket object, the rectangle decide the size of the bracket

System variable @bdm=0 to roll back old behavior, single click to create fixed size bracket

ORG-30036

@option to show page level filter

%(L, @GFP) to show page level filter info.

Click on page edge and choose Add Page Title. Enter %(L, @GFP) . Page level filter shows as page title.

image-20250210-163426.png

 

ORG-30729

Improvement on Box Chart tooltip

Sensitive tooltip e.g. percentile, mean, median, etc. depending on where mouse is on the box

Depending on where the mouse is, different tooltip shows, e.g.

  • Mouse over left/right edge of box - shows full tooltip

  • Mouse over mean symbol - shows mean value

  • Mouse over median line - shows median value

  • Mouse over data points - shows the index and data point value

ORG-30237

Change X and Change Y context menu on Data Slicer panel

Use the context menu to replace plots in all layers with a different Y or X.

Change Y context menu only shows if all plots are using same Y data.

Change X context menu only shows if all plots are using same X data.

image-20250226-205140.png

ORG-30923

Label for colormap value in Treemap and Sunburst

For Treemap and Sunburst graphs, if fill color is mapped to a column, can use $(cm) to show colormap value in labels

$(cm) to show colormap value as label.

Specify display format by 2nd parameter, e.g.

$(cm, .2) - show 2 decimal places

$(cm, *3) - show 3 significant digits

$(cm, .1*) - show 1 decimal place and trim 0’s at the end, e.g. 7 will show as 7 instead of 7.0

image-20250403-160726.png

ORG-31383

Panel Banner Support Custom Notation

Show layer info and panel info in same table row for grouped plot.

Support custom notation like %(?, @LA) for panel banner.

ORG-31382

Legend Notation for distribution curve for histogram

Add notation to indicate distribution curve.

For histogram with distribution curve, Origin show a parameter table to indicate the info of distribution curve. The notation is \l(1,DC) to indicate distribution curve.

ORG-30323

Custom Legend With Full Syntax

In Plot Details dialog’s Legends/Titles tab, Translation Mode option, add Full Syntax in dropdown.

When Full Syntax is selected, Full Syntax control shows.

Fill with full syntax of legend text. For example, %(?X, @LL) means long name of x column. ? represent plot index.

image-20250625-110855.png

 

General

JIRA

SUMMARY

DESCRIPTION

DETAILS

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-30447

Set Graph Defaults

Set axes, fonts, layout and legend defaults for graphs

Preferences: Graph Options… to open the dialog to set default settings common to all future graphs.

image-20250516-202151.png

 

Apply to button to apply the default settings to existing graphs, e.g. active graph, all graphs in folder, …

Click OK to apply to future new graphs.

Reset button to reset to preshipped Default, Classic and clear all to <auto>

System variable @GGO to control types of graph templates to apply settings

  • 1 = system templates

  • 2 = user defined template

  • 4 = app templates

  • 5 = extended templates

These numbers can be combined. E.g. set to 13 to apply the graph options when plotting graphs from built-in graph templates, app’s graph templates or downloaded extended graph templates.

ORG-30728

Easier way to add reference line

Insert: Reference Line… menu and mini dialog

Select the Insert: Refernece Line… menu to open a mini dialog to add reference line(s)

image-20250311-193426.png

Click on a reference line to delete it.

Mini toolbar to edit and set default format

image-20250311-193533.png

ORG-30440 S3, S5

Group plots when drag and drop more data into Graph

When adding more plots to an existing graph, by default group them with existing graphs

Group when Drag and Drop Plot checkbox is added and checked by default on Graph tab of Preferences: Options dialog. Corresponding system variable is @DDG.

Rules:

  • If there is a single plot in existing graph, drag and drop more column(s), group them together.

  • If there is a group of plots in existing graph, drag and drop more column(s), group them together.

  • If there are multiple groups of plots or a mixture of single and grouped plots in existing graph, then still use old mechanism: If drag a single column, add as a single plot, if drag multiple column(s), add as a new group.

 

ORG-30440 S2, S4

Easier grouping/ungrouping of plots

Mini toolbar and context menu added to easily group/ungroup plots in Object Manager

Group/ungroup context menu and mini toolbars in Object Manager.

Cases supported:

  • Ctrl+select multiple group nodes E.g. g1 and g3 to group together as a new group

  • Ctrl+select group node(s) and single plot(s) E.g. g1 and a single plot to group together.

  • Ctrl+select group node(s) and member(s) of another group e.g. g1 and e.g. D from g2 to group together.

  • Ctrl+select members in different group nodes e.g. B from g1 and D from g2 to make a new group

  • Shift+select adjacent plots to group together.

 

ORG-30779

Minimize button in Plot Setup dialog

Click Minimize button on Plot Setup dialog title bar to temporarily minimize this modal dialog

Sometimes there are many books/sheets in workspace to plot. User can’t check book/sheet contents with Plot Setup dialog open since it’s modal dialog.

In the past, user would have to close it. Check books and sheets and then reopen the dialog to plot.

In Origin 2025b, user can click Minimize button on the dialog title bar to temporarily minimize it to take a look of different books and sheets. Then clicke the minimize button again to restore the Plot Setup dialog.

image-20250331-214124.png

 

ORG-30664

Layer Icon indicator for Multi-layer graph customization

Show layer indicator for multiple layers when Plot Details dialog is opened to customize graph

Sometimes when editing graphs in Plot Details dialog on multi-layer graph, it’s hard to tell which layer is which. Layer icon indicator shows on graph in Origin 2025b to make it easier to find the corresponding layer in Plot Details dialog.

image-20250312-171743.png

 

ORG-30023

Save Theme as should Fill Theme name by default

preset the original theme name in save as dialog

  1. open theme organizer dialog

  2. go to last theme in Graph tab, right click All Axes ON, select edit

  3. uncheck show checkbox, click save as

    → All Axes ON show as Name of New Theme, then user could modify the name.

In Theme Preview app, we provide themes like Custom Page Size, Custom Font etc. User just need to change the property setting, and save the theme in same name, the quick style will use the new theme.

ORG-28969

Draw Rectangle With Rounded Corner

In toolbar, add Rounded Rectangle after Rectangle.

Select it and drag to rectangle should create rectangle with rounded corner. Anchor point could decide the radius for rounded corner.

ORG-29960

Extract, Create Copy of ShDF Data

Copy Values from plot or create slicer copy as new book.

Right click the plot with slicer to choose Copy Values or Create Slicer Copy as New Book context menu.

ORG-30772

X button on Slicer panel gives options

Options to Destroy or Hide the slicer is given

In Origin 2025 when data slicer is introduced, X can only hide the panel. To destroy the slicer, user had to click the Data Filter toolbar button.

In Origin 2025b, click X button gives options to destroy or hide.

image-20250311-214928.png

ORG-23052

Auto initialize Dark Mode Preview

When @RBA=1, we added a new entry to put dark mode template icon.

When save template as with a template with dark mode preview, we will initialize the dark mode preview in dialog.

ORG-30596

Make similar Copy Plot/Copy for Plot functions have same icon and placement on MT

Copy Plot/Copy for Plot mini toolbar in Graph and Worksheet use the same icon and location, the last button of 1st row

ORG-30596.png

ORG-30598

Graph Protection

Prevent graph being edited or deleted

With Graph window active, press Ctrl+F3 or choose Tools: Protection: Graph Protection menu to specify which action to prevent.

image-20250318-201540.png

Lock shows before Graph name in window title bar, Project Explorer and Object Manager.

image-20250401-200323.png

 

ORG-30324

Graph: Fixed Scale Factor menu improvements

Scale factor will be set to 1 without need to open dialog

By default many graph types are set so text, line, etc. graph element scales with layer frame. When a layer is shrunk, the text or line resizes. That’s why when you select text in graph, on status bar, it shows two Size (actual) = 22 (10.1)

Most users just want to set the Scaling factor to 1 so element doesn’t resize with layer. There is really no need to popup a dialog which most users just click OK to close it.

ORG-29685

Insert equilateral triangle, equilateral pentagons and etc.

Support Triangle, Parallelogram, Trapezoid, Diamond, Pentagon, Hexagon, Heptagon, Octagon, Decagon, Dodecagon.

Parallelogram has red anchor point to change shape. But we do not support edit point mode for all shapes. For Trapezoid, in object MT, we support a checkbox button Isosceles Trapezoid in the end of 1st row, uncheck it will show two anchor points to change distance of left right separately.

ORG-30528

Show/Hide Masked Points on single graph window

Mini toolbar on each graph to control masked points show or not

There was only global control of show/hide masked points on all graphs.

In Origin 2025b, there is Show/Hide Masked Points mini toolbar button on page level to control individual graph.

Auto -- follow global Show/Hide Masked Data Points setting on Mask toolbar button at the bottom of Origin workspace

image-20250224-220602.png

ORG-30813

Create Heatmap from Single Text Column

Create Heatmap from Single Text Column

Before make plot, we need to set text column as categorical.

ORG-30340

Want P-P plot support Batch Plotting

Support batch plotting for P-P plot.

Make a Probability Plot, and right click the graph title bar and select Batch Plotting.. to do batch plotting.

ORG-31037

MT for Graphs in Report Sheet

Support two kinds of Mini Toolbar in Report Sheet

  1. When select an embedded graph from report sheet

  2. When click in report sheet is not inside cell

ORG-30317_.png

ORG-31145

Report Sheet Graph Size Dialog

Change Report Sheet Graph Size and Arrangement

Two way to open the Graph Size dialog:

  1. Right click the report table’s header to choose Graph Size context menu.

  2. Click the report graph then choose the Change Graph Size and Arrangement… mini toolbar button.

GraphSizeDlg.png

 

ORG-31193

Consistent window size in system template

Add system variables to make sure all system graph template have consistent window size.

@GPW=700 added for default window width, set to <100 to disable this feature. 700 means 700 px in normal DPI screen for graph width.

@GPWM=0x0D added, 0x1 for system templates, 0x2 for user templates, 0x4 for add templates, 0x8 for extends templates

For window view, we should not apply this size.

ORG-31067

Update Multi-Vari Chart as hierarchical report sheet

Update Multi-Vari Chart as hierarchical report sheet.

After the change, hierarchical report sheet will be generated when make multi-vari chart.

ORG-31048

Colormap and bubble plot default improve

Change the default plotting rule for Color Mapped scatter (based on the 3rd column) and Bubble + Color Mapped (based on the 4th column)

For Color Mapped scatter,

  • if 3rd column is text column(base on general rule to decide if a column is text column or not), set color index to 3rd column and color use system increment list color for symbol edge.

  • if 3rd column is not text column, add color scale object

For Bubble + Color Mapped

  • if 4th column is text column, reconstruct legend to get categorical legend

  • if 4th column is not text column, add color scale object, template should set proper position for color scale bubble scale and legend.

ORG-31127

Online Templates for 2025b

Added more online template for 2025b. You can get the latest online template by selecting menu Tools: Template Center.

Heatmap with Group

ORG-30969

ORG-30974

ORG-31042

ORG-31085

 

More options for grouped box chart-Indexed Data

  • Rename Group Columns to Group Plot by

  • Add Split Panels by control

  • Add Split Pages by control

  • Add Multiple Data control

  • Add Color Increment

  • Add Additional Info in Tick Labels control

  • Split Panels by: Once this check box has been checked, you can select another grouping column to enable horizontal panels which show a grouped box chart for each grouping value seperately. Wrap Panels will be enabled, ticks and labels will be shown on alternate sides by default.

  • Split Pages by: Once this check box has been checked, you can select another grouping column to split the input data and created gouped chart boxes in different graph pages. Each page only plots the columns within the same page related group. Page related group info will be shown in layer title, separated by comma if there are multiple factors

  • Multiple Data control: Overlay on Same Graph, Separate Layers on Same Graph, Separate Graphs

  • Share Y checkbox will be show when Separate Layers are selected

  • Color Increment: Specify how to color the grouped boxes with the color increment list, within subgroup or between subgroup.

  • Additional Info in Tick Labels: each notation will be shown in different table rows. All these info will be shown after group info table rows.

ORG-30889

Support Time Stamp in Statistic Process Control: Control Charts

Support Time Stamp in Statistic Process Control: Control Charts

  1. Group Label Column checkbox for Control Charts: Variables Charts for Subgroups and Time-Weighted Charts

ORG-30889_GLC.png
  1. Observation Label checkbox for Control Charts: Variables Charts for Individuals

ORG-30889_I.png
  1. Sample Label Column checkbox for Control Charts: Attributes Charts

ORG-30889_P.png

ORG-31000

Fewer number of ticks when auto rescale

  • Less Ticks when create graph

  • Tick labels from label row consider data format

By default Origin 2025b only show no more than 10 ticks for numeric data

You can set @ARUR=0 to disable it

Graph Customization

JIRA

SUMMARY

DESCRIPTION

DETAILS

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-30011

Dot Plot Mini Toolbar

Mini toolbar is added for dot plot for easy customization

Click on dot plot will show mini toolbar to customize dot color, shape, size, edit range, etc.

ORG-30584

Failure to disable rotation, resizing for line & arrow object

Hold Shift key to keep angle of line when editing point for existing object

hold shift key and edit any point for existing line/arrow object, the angle of the line is maintained.

This change should apply to line& arrow& polyline.

ORG-30620

Dendrogram Support Subset

When there is subset gap, all the leaves nodes within this subset should move towards subset center with (subset gap/2).

Add Subset tab in PD of dendrogram.

ORG-30637

Automatically Adjust Tick Positions for Heatmap with Uneven Gaps

When there are uneven gaps, the axis ticks will be positioned at the center of the heatmap blocks.

Ticks automatically adjust to be centered.

image-20250217-213903.png

ORG-30619

Heatmap Gap after Some Cells

We can modify gap between cells in Display tab.

We allow gap by

  • every N cells

  • after Nth cell

  • by column/row

ORG-24000

Change page DPI

Support menu to change page DPI to increase the pixel on a fixed size canvas

Can access by Format: Change page DPI

System variable to reset: @DPIF=0, default is 8, default DPI will become 4800 from current 600

ORG-30164

Extract the value at a specific coordinate on a ternary contour plot

Support extract data from graph or location define by worksheet

Right click on the plot, there is option Extract Data Points…

In mini toolbar, there is Extract Data Points button

ORG-29813

Fill Area between Plot with Same Name

Add a new option Plot with Same Name after Next Plot in Data Plot dropdown, under Plot Details dialog’s Line tab. You can see it when Fill Area Under Curve is enable, and set to Fill to Data Plot.

Select Plot with Same Name, Show Name option to select a label row to be plot name. Name dropdown would list Long Name, Units, Comments and shown parameters and user parameters.

When there are multiple same name plots, Origin will fill from 1st to 2nd, 2nd to 3rd, etc, until the last one in group.

ORG-30789

Add Outlier labels for box plot

Add Outliers checkbox in Percentile Labels group in Labels tab.

Add a Leader Line for Outliers group under Additional Labels group.

Now user can add Outlier labels for box plot. When Outliers is selected, Leader Line for Outliers is selectable.

image-20250624-105900.png

 

ORG-30960

Support Absolute Value to Create Error Bar

Value Type Control is added for Plot Details' Error bar tab. It has two options: Offset and End Value.

In most statistics report, for CI, the output is Lower Limits and Upper Limits. But when create error bar, Yerr value is distance from center point.

Offset is current mode, end value means error cap use absolute value of column. When value type is End Value, direction group only show x error bar checkbox, one error bar only plot one cap.

ORG-30349

Easy way to add reference line at X value of Y's min, max, percentile, etc.

Add vertical reference line based on Y’s statistics.

In reference line dialog, when Axis=Vertical, Value Type=Statistics, new options are added:

  • X at Minimum Y,

  • X at Maximum Y,

  • X at Y Percentile: 10%

ORG-30951

Auto darker border color base on fill color

For column/bar plot, floating/stacked bar, histogram, area plot, Origin now support auto color for fill color, so it is lighter version of border.

You can rollback to old behavior by setting @ACPLD=0

Data Handling

Worksheet

JIRA

SUMMARY

DESCRIPTION

DETAILS

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-30699

Interactive cell referencing through selection in cell formula

When using = to define cell formula, click a cell or range to refer to it similar to Excel

Fill column A and B with row numbers.

In C1 cell, enter =, then click on A1 will add A1 after = sign. Then enter + and click B1. The formula will be generated as =A1+B1. Press Enter to accept it.

In C2 cell, enter =sum(, then drag A1 to A10. Press enter. The formula will be generated as =sum(A1:A10). Press Enter to accept it. Note: In previous version, need to enter =total(A1:A10)

The selected cell/range shows with a light green background.

Referencing to different sheet in the same book is also supported. Different book is not supports yet.

ORG-31032

Insert copied cells similar to Excel

Edit: Paste (Insert) and context menu are added

Insert the copied data and push original data downwards

System variable: @WPI to copy how to paste insert if cells copied is more than the number of cell selection in destination

  • 0 (default) – No replacing. Insert all copied cell and push selection downwards. E.g. Copy A1 to A4 (4 cells). Select B2, B3 (2 cells) to paste (insert). A1-A4 will be pasted to where B2-B5 is. Original selection B2, B3 and all data below will be pushed to B6, B7 and on.

    image-20250505-165206.png
  • 1 – Selection will be replaced. E.g. Copy A1 to A4 (4 cells). Select B2, B3 (2 cells) to paste (insert). A1-A4 will be pasted to where B2-B5 is. Original selection B2-B3 will be gone. Original B4, B5 and all data below will be pushed to B6, B7 and on.

    image-20250505-165414.png

ORG-30517

Conditional Format: Highlight Min and Max Values

Support highlight Min and Max values row-wise or column-wise

Select Columns or a region

Right click and choose Conditional Formatting → Highlight Min Max sub menu

Choose Column-wise to color min and max values column-wise, e.g.

image-20250319-191315.png

Choose Row-wise to color min and max values row-wise.

image-20250319-191814.png

Choose Open dialog to customize colors or only highlight min or max

image-20250319-191927.png

Click > button and choose Generate Script to see corresponding X-Function.

//C1R1-C0R0 means from column1,row1 to last column, last row //min.use=0 means don’t highlight min wcolorbycr name:="C1R1-C0R0" min.use:=0;

ORG-30516

More statistics options for conditional formatting, similar to Minitab

Conditional Formatting: Top/Bottom, Pareto, Outliers are added

image-20250319-192758.png

Open dialog for more options e.g.

image-20250319-192844.png
image-20250319-192923.png
image-20250319-192955.png

ORG-30534

XF to Show Multiple Menu Entries Improvement

Show saved theme in Worksheet: Conditional Formatting: Highlight Min Max menu.

MinMaxTheme.png

ORG-2174

Improved Shortcut Keys and Worksheet Functionality

Hot key to insert/delete rows.

Highlight a row(s), then

Insert Rows: Use Ctrl + Shift + = or Ctrl + Num+

Delete Rows: Use Ctrl + - or Ctrl + Num-

ORG-20245

sum function in cell formula

Improve sum() function to get sum of a range of cells when used in cell formula

Total( ) function is used to get sum of region, while Sum( ) is used to get cumulative sum for a column.

In Origin 2025b, when sum() function is used in cell formula, it will get the total of the region. E.g. sum(A1:A10), sum(A1:D1), sum(A1:D10), sum(A1:B1, E1:F1).

Note: sum(A1:B1, E1) not supported still.

ORG-30825

Support autofill on absolute reference in cell formula

Autofill better supports for absolute reference in cell formula

When use absolute reference in cell formula like below, drag and drop to autofill formula will be failed in previous version. Now, this is supported in Origin 2025b.

=total(A1:$A$13)-total(B2:$B$10)

ORG-30528

Reduce Rows Delete Entire Row Improve

Options are added in Remove Rows dialog to remove masked/missing value cells only or remove the rows with masked/missing value cells.

Cell Only and Rows in Selection options are added under Delete Entire Row.

E.g. Choose Cell Only option to only delete cells and shift rows upwards.

image-20250304-224919.png

 

ORG-30648

Query data from Multiple Sheets

Query data from multiple sheets with same structure

 

In the past, Worksheet Query… dialog can only be used to extract data from one sheet. In Origin 2025b, Multiple Worksheets checkbox is added to extract data from multiple sheets with same structure. E.g.

  1. With any of the worksheet or workbook active, choose Worksheet: Worksheet Query…

  2. Check the Multiple Worksheets checkbox.

  3. Click the > in the table below to pick multiple sheets

  4. Set Condition using short name of the column. Click Test - select if true to verify the query result.

  5. In bottom-left table, pick which column to extract by check the corresponding checkbox.

  6. Specify the Output and click OK

image-20250306-190229.png

The result will look as follows, with Data Identifier column to know which workbook & sheet the corresponding row is from

image-20250311-124822.png

ORG-30337

Change Column Format with Mini Toolbar

New mini toolbar button to change column format

Add a new mini toolbar button for column to quickly set the format.

ColFmt.png

ORG-30910

Single line paste to a cell change to Keep Space

Default change to keep space when paste single line with text to a cell

If single line and not all except 1st is numeric, then paste into single cell.

E.g. Copy single line text like “1 2 3 a”, paste to A1. In previous version, it will be pasted to 4 cells. Now, since Origin 2025b, it will be pasted to A1 cell only.