Page Comparison

ORG-25363

Plot Data by Sorted X

LabTalk command to change line plots by worksheet order or sorted X

Perform automatic X value sorting of data in line or line-symbol plots without having to sort the worksheet columns. This is particularly useful when you have multiple columns in a worksheet and want to plot any two columns against each other, without having to reorder the worksheet rows.

Apply x value sorting to a particular data plot with this LabTalk script command:
layer.plot1.line.sortx=1; //sort X of 1st plot in current layer

Once sorted, the graph can be saved as a template for future use, if desired.

ORG-25298

More skip data points options in plot

Smart skip point options based on data density and shape

For scatter plots and line+symbol plots, go to the Drop Lines tab.

Two Smart Skip options are added:

• Smart Skip (Total Points Kept) keeps the number of points set and skips the other points based on data density and shape.

• Smart Skip (% of Points Skipped) keeps the percentage of points set and skips the other points based on data density and shape.

  

System Variable @SMM determines the method used for Smart Skip:

^{0: Largest Triangle}

^{1: Y-threshold}

^{2: Data Distance Threshold}

^{3: Douglas-Peucker-Hull}

^{4: Largest Triangle for Segments(default)}

LT controlled can be used to specify starting skip points. In the example below, 10 means start to perform skip from the 10th row in the workbook data.

layer.plot1.symbol.skipstart=10

ORG-25213

Enable auto rescale on Mini Toolbar

Auto Rescale control for 2D and 3D layer level mini toolbar.

Once it’s enabled, when data are changed, graph axis will auto rescale to reflect it.

Previously needed to go to Axis dialog to set the rescale mode to Auto.

Or click the Rescale button (Ctrl+R) to manually rescale to show all.

For 3D, it’s a dropdown list

For 2D, it’s a checkbox

ORG-25580

Alternate Sides to Show Ticks and Labels

For multi-panel graphs arranged in 1 row or 1 column, added option to alternate sides to show ticks, tick labels and axis title

Use Alternate Side to Show Ticks and Labels Checkbox is added in:

• Stack… plot dialog

• Merge Graph Windows dialog (if either the number of columns or number of rows is 1)

• Arrange Layers dialog

ORG-25214

Smaller Z axis length Allowed

Extended minimum Z axis length to 10%

In previous versions, Z axis length could only be as small as 25% of full length. In Origin 2023, the minimum value can be as small as 10%.

ORG-25374

Contour Plot Improvement

Insert multiple levels and customize single level’s label style

• Insert… button to manually add multiple levels

  

• Add Auto to plot level label color option of contour plot. Auto means follow contour line color.

• Single click on contour line twice to select that level. Mini toolbar shows to customize line, label and extract contour line’s coordinates of that level.

  

ORG-25610

Set different spacing gap for different sets of linked layers

For each set of linked layers, different spacing can be set

E.g. In the following graph, the column/bar width and gap in top (layer 1) and bottom panels (layer 2, 3&4) can be set to set differently.

1. Check Column/Bar/Box Gap Across Layers on Layers tab of Page level so column/bars in overlapped layers 2, 3&4 will be organized together.

2. Set Layer 2 to not be linked to layer 1. Set layer 3 and 4 to be linked to layer 2 with straight 1:1 x-axis. So there are two sets, Layer 1 vs Layers 2, 3&4

3. Pick plot in 1st layer and go to spacing tab to set column/bar width and gap.

4. Pick plot in 2nd layer (parent of 2nd set of linked layers) to set column bar width and gap of layer 2, 3&4.

@GALL=1 by default, 0 is for old behavior

Notice that we need to be enable Column/Bar/Box Gap Across Layers if want to share same spacing setting

In older versions, the spacing tab is only enabled for 1st layer in whole graph and it will affect all layers. If setting the column/bar width on top panel to be narrower, the bottom 2 columns will be very thin.

ORG-25147

Sunburst/Doughnut Improvements

Modify independent ring width in doughnut and sunburst plots

In doughnut or sunburst plots, set Group Edit Mode to be Independent and then select a single ring to set independent width.

The following settings dependent or not in Independent mode is controlled by system variable @PGI

0 (default) - dependent/shared.

1 - independent (it's rare since usually they will share same gap, rotation, etc).

• Horizontal Offset (sunburst and doughnut plots),

• Rotation group (sunburst plot)

• Doughnut group (sunburst and doughnut plot)

3D View group on the Pie Geometry tab of the Plot Details dialog are hidden in Origin 2023 since 3D doughnuts are not supported.
It is hidden to avoid confusion.

ORG-25537

Box chart Improvements

Set %c -hadj 0 to set no gap between half violin or split violin to center

Note: If it’s multiple layer graphs, it needs to be set for each layer.

ORG-25020

Color Each Data Point in Grouped Box Chart Types with data points showing

When plotting Grouped box chart with data points showing, Data Points Color by option is added.

Under Plot: Categorical menu, there are multiple variations of grouped box chart, e.g. Grouped Column - Scatter, Grouped Mean Bar - Indexed, Grouped Half Violin - Indexed, Grouped Half Box - Indexed, they all open plot_gboxindexed dialog. User can also change it by change the variations by Graph Theme dropdown list in the dialog.

As long as there is data points showing, Data Points Color by control will show for user to specify which column will be used to color the points.

The following graph also set legend to show Categorical Values so coloring info. show in legend.

ORG-25188

XY coordinates issues on special NetCDF

Support XY Coordinates Mapping on Matrix for heatmap plot

ORG-25567

Add Line Connect style such as Spline to 3D line symbol plots

In Line tab of 3D scatter plot/trajectory/vector, we can add Connect option on top of Style. dropdown could be Straight/Spline/B-Spline. Default is Straight. Spline/B-Spline should be same as Cubic Spline/B-Spline in interpxyz XF.

If it is not available to do analysis, data points will be connected with straight line.

It is not supported for 3D Ternary/Tetrahedral scatters plot.

ORG-25085

Gradient filled colormap bar

In Pattern tab, add More Colors option in Gradient Fill dropdown.

Select the More Colors option to show the Palette option.

For column/bar/histogram/area/ribbon/wall/waterfall plot, add checkbox By Y Value after gradient fill, enable when gradient fill is not none. For 3D Bar, the label could be By Z Value.

ORG-20843

Improvement of color scale object size

1. Support Color Scale Position in Color Scale Control dialog.

2. Support drag object edge to resize width of color bar.

ORG-25793

want specify 3D plane position by cell value named range

We support to use project scope named range for Percent/Value edit box

1. define project scope named range

2. make 3D plot, open PD dialog, go to layer level, planes tab, select one plane, then you can set at position=named range

3. named range also can be used as formula in 3d function plot

ORG-24709

Add distribution name and parameters to graph for histogram plot

Add checkbox Show Parameter Table on the right side of Curve Type in Distribution tab.

When the option is enable, parameter table will show on top-right corner of the graph, with curve type, parameter name and its value.

ORG-22637

Banded Rows in Worksheet

Alternate row column fill color

Click on upper-left corner of worksheet to turn on/off banded rows and set Banded Rows Color and show color on even or odd rows.

Set Default Banded Row Colors.

LabTalk property for worksheet:

wks.band=

• =0, Off

• =1, Odd Rows

• =2, Even Rows

wks.bandcolor access the banded row color

ORG-22868

Freeze Panes

Freeze rows and columns in worksheet

Freeze up to 10 beginning rows and columns to keep them visible while scrolling in worksheet

• If a column header is highlighted and freeze pane is used, Origin will freeze all columns to the left of it

• If a row header is highlighted and freeze pane is used, Origin will freeze all rows above it.

• If a cell is selected and freeze pane is used, Origin will freeze all rows above it and columns to the left of it

Ways to freeze/unfreeze

• Hotkey Ctrl+Shift+F to freeze/unfreeze

• Mini toolbar when clicking column, row or cell to freeze

• View: Unfreeze/Freeze Panes menu to freeze/unfreeze

• Mini toolbar when clicking in upper-left corner of worksheet to unfreeze

  

ORG-23417

Protect Worksheet

Disable Editing of worksheet by adding a lock on sheet

• Mini toolbar bar button is added to disable/enable editing of sheet. Lock icon shows in front of sheet name

• Select multiple sheet tabs and right click to protect

• Context menu in Object Manager to protect sheet(s)

• Choose Preferences: Protect Sheet Options… menu to customize protection exceptions.

  

• System Variable @WPO for exceptions (default 11 - allow mask, sort, and resize col/row and change colors)

@WPO = 0 will lock up all except to change filled color etc.

WPO_COLOR_AND_RESIZE = 0x01,
WPO_MASKING = 0x02,
WPO_SET_DESIGNATION = 0x04,
WPO_REORDER = 0x08,
WPO_CELL_NOTES = 0x10,

ORG-25445

Hide Sheets

Hide sheets in Workbook

• Right-click sheet tab(s) to hide.

  

• Right-click sheet(s) in Object Manager to hide/show

  

• Show/Hide sheets in Navigate Worksheets dialog

  

ORG-25593

Stack Worksheets Improvements

Skip Hidden Sheets when stacking worksheets

Skip Hidden Sheets checkbox is added in Stack Worksheets dialog.

ORG-14088

Wrap rich text in worksheet

Allow wrapping rich text in worksheet cell

In previous versions, rich text in worksheet cells couldn’t be wrapped.

It can be wrapped in Origin 2023 and is set as default.

Ways to set as rich text and wrap/unwrap

• Format: Worksheet… menu. Go to Format tab to set rich text, or to turn on wrap/unwrap of each level, e.g. long name, comment, data…

• Set Style: context menu. Depending on the location of the right-click, it may be called Set Long Name Style, Set Data Style, etc.

• Mini toolbar when click column label row header

Note: When double clicking text to edit (in-place edit mode), text will not be wrapped

In Data cell area, if rich text and wrap are both checked, the text will be center aligned vertically. Adjust the height of the cell to see the effect. System variable @DCWRVC=1

Set @DCWRVC=0 so text is top aligned.

ORG-25184

Managing Sheets in Workbook Improvements

Make moving sheets in book easier.

• Shift+Select or Ctrl+Click sheet tabs to select multiple sheets. Then:

Drag them to another book to move them there..

Drag to workspace to move them to a new book.

There is also Move to New Book or Selected Book in Navigate Worksheets dialog.

Set system variable @SDMS=0 to roll back to old behavior so multi-sheet will not be allowed to drag.

• Drag and drop multiple sheets in Object Manager to reorder them.

• Auto scroll sheets when keeping dragging sheet tabs in one direction as in Excel. In older versions, it would be impossible to drag a sheet to a certain location since the sheets couldn’t auto scroll.

ORG-25467

Support Deselect Cells with Ctrl Key

Hold Ctrl key and click on those already selected cells to deselect them

Ctrl+Click the already selected cells will unselect the cells.

Previously, there was no way to unselect already highlighted cells.

ORG-25458

Ctrl+Shift+Arrow keys for column/row selection

Support Ctrl+Shift+ Arrow key for whole row or column selection similar to Excel

Select a cell in worksheet and choose:

• Ctrl+Shift+right arrow – highlight from current selection all the way to the right

• Ctrl+Shift+left arrow – highlight from current selection all the way to the left

• Ctrl+Shift+up arrow – highlight from current selection all the way to the top

• Ctrl+Shift+down arrow – highlight from current selection all the way to the bottom

With Ctrl+Shift pressed, press right arrow first and then down arrow to select from current selection all the way to bottom-right corner.

ORG-25349

Alignment of URL Linked Cells

Alignment toolbar buttons are enabled for hyperlink cells

E.g. enter http://originlab.com homepage in a worksheet cell.

Select the cell and set alignment on Format toolbar.

It’s also supported in other links, e.g.

• range://[book1]sheet2 here

• path://"C:\Program Files\OriginLab\Origin2023\Samples\Image Processing and Analysis\bamboo.jpg" open

ORG-19861

More Merge by options for reduce columns

Support merge columns by median and also support output multiple quantities

• Choose Worksheet: Reduce Columns… menu

• Set Merge by as Custom to specify multiple quantities to output (space separated).

• Note: SD column will be set as YErr automatically.

ORG-25402

Intellisense/Auto complete improvements

Shows Auto Complete hint for the syntax of function argument.

When typing function formula in cell, Set Values dialog, or Command window, the auto complete hint will show the parameters of the function for ease of use.

ORG-25395

Autofill for Column Formula Improvements

Enumerate column part with Ctrl+Drag

Example 1:

Enter B-B1 as formula in column E. Ctrl+Drag the F(x) cell corner to the right will fill C-C1, D-D1

Drag without holding Ctrl key, it will fill with B-B2, B-B3 (only incrementing number at the end)

Example 2:

In Book3, set column B’s F(x) as [book1]1!B+[book2]1!B, then Ctrl+Drag the tiny bottom-right corner of the F(x) cell to the right, it will column C, D, … 's formula as [book1]1!C+[book2]1!C, [book1]1!D+[book2]1!D, ….

ORG-25475

Show stats of column label row selection

On Status bar, show statistics when doing selection in column label area

Select cells in column label area, statistics such as count, average, sum, min, max, etc. show on Status bar.

This used to only work for selections in data area.

ORG-25548

Improvement to Cell URL Link notation

New notations are added to execute LabTalk script, open external file.

• labtalk:// notation to execute LabTalk Script

  • labtalk://";ty -b hello" Hello World – it runs script in quotes

  • labtalk://";work -r" Click to run script – It runs the script in Worksheet: Worksheet Script… dialog.

The ; is not needed if the script does not open dialog.

• path:// notation to open external file

  Code Block
  path://[C:\Windows\Web\Wallpaper\Theme2\img11.jpg] img11.jpg

Also, support Alt + Double click to edit URL link in cell.

ORG-20565

Select Column… Improvements

Select columns by LabTalk Script

Support select/hide columns by running some conditions defined by LabTalk Script

Examples: x refers to column, j refers to column index

• x[10] = 2.5 //check if column’s 10th row is 2.5

• mean(x)> 2 //check if column’s mean is bigger than 2

• j==2 or j==7 //if it’s 2nd column or 7th column

Other minor improvements:

• Add Select Columns… menu under Column as well. It used to be under Edit: menu only— which was not obvious.

• Renamed the Test - Select if True button to Select button

ORG-25549

Worksheet cell insert Image from files supports direction

Right-click a worksheet cell and choose Insert Images from Files to open insertImag dialog, a new option Insert Direction is added to choose the direction to insert images.

Default Horizontal First will insert images row-wise, which works same as before. The Vertical First will insert images column-wise.

ORG-25450

Unstack columns Improvements

When unstacking columns, choose Custom option to specify where each grouping info. is output to

This feature is useful when there are multiple group columns.

When unstacking, there is an option specify where each grouping info. should be output to.

E.g. in the following example, age is output to User Defined Parameter (D1), while gender is output to Long Name (L)

ORG-25616

Move rows in worksheet

Mini toolbar to move row(s) up or down

Click mini toolbar buttons to move selected rows up or down

LabTalk Script

• worksheet -sou mr 2 //move selected rows down 2 rows

• worksheet -sou mr -2 //move selected rows up 2 rows

Note: For data imported by data connector, choose Unlock Imported Data to temporarily unlock data so you can edit or move data.

For analysis output sheets with locks, this will not be allowed either. You can set Recalculation mode to None to move data. But the result sheet will not be updated if input data is updated.

ORG-25657

Improvements on Cell Formula Cache

Improve the handle of cell fomula cache for better performance

Cell formula would be calculated from time to time in the previous versions, so if the source data is huge, it will be slow. There is a value cache for cell formula though, but it will be cleared after time limit is reached, which is control by @SCNT (time interval as milliseconds, default is 5000). So if your project is slow with cell formula, can set @SCNT to be a huge number to avoid recalucation.

Since Origin 2023, cell formula will keep using cache result until data change, so it will not recalculate frequently. And then if you want to force clear the cache to force cell formula values to update, press F5 to refresh or set @SCNT = -1 to do it.

ORG-25251

Improvements autofill for cell formula with row index

Improve autofill behavior for cell formula with row index

For cell formula like “=A[1]”, “=sum(A)[1]“,

• Autofill will do repeat

• Ctrl + Autofill will do enumerate

ORG-25719

Insert Worksheet into Layout Improvements

Improvements when inserting workbook into layout window

• Directly insert worksheet without need to drag in layout

• Hide column header, row header, empty rows at bottom

• No margin around worksheet.

• Mini toolbar to set border, font, fill color, font color, etc.

• Support insert worksheet in graph via menu Insert: Worksheet…

ORG-25628

Copy Worksheet as HTML/EMF

Support copy whole sheet as HTML table or EMF image without any selection

New menu Edit: Copy: Copy Sheet as HTML/EMF is added for Worksheet.

Also, Frame Thickness and Margin options are provided in Worksheet Properties: Print/Export page for copy as EMF usage.

ORG-25634

Worksheet Print, Export and Copy EMF Improvements

Improvements on Print/Export tab of Worksheet Properties

1. Gridline in Printout and export should be WYSIWYG. So removed grids settings on the tab.

2. Add Frame and Margin settings when copying sheet or selection as EMF (from Edit: Copy: submenu)

ORG-25249

Better default setting when exporting GeoTIFF files

Default GEO information setting Export image dialog when exporting as TIF file type

Default settings of exporting GeoTIFF in Export image dialog from both matrix and image window:

1. GT Model = Geodetic

2. EPSG = 4326

3. Angular Units = Degree

4. Linear Units = Meter

5. Vertical Units = Meter

ORG-25047

Matrix Export to Image to better support GeoTIFF

There is an option in the dropdown list and default to it if we detect matrix has that info.

Besides geo info, Origin will check file extension as well:

i.e. import *.jpg into image window, export dialog will default to jpg too. while matrix window does not now.

ORG-25589

Export Worksheet as Image Improvements

Ignore hidden rows, show border, etc.

• Empty rows at the bottom of the worksheet will be ignored when Export Area is set to Whole

• Added a border around sheet in exported image. System variable @ESB to set border width. 1(default) - to turn it on, > 1 will increase thickness, 0 will turn it off

ORG-24994

Preview button in Simple Graph Export dialog

Add preview button in expG2img dialog

Click the button will open the graph in internal preview tool.

• Zoom in/out by Ctrl+mouse wheel. Zoom % will show on bottom left corner of status bar at the bottom of Origin workspace.

• Drag to pan.

• Ctrl+W to reset

It does not support for SVG.

ORG-25269

Raster Export Misinterprets Middle Colors of Colormap Temperature Palette

Higher default color depth on export

BMP, PSD, TGA: from 256 colors to be 24-bit color.

PDF (Basic Object - Resolution): from 72 to be 96.

ORG-25240

Support export image, graph window as Video, GIF, TIFF

1. We support export multiple frames as TIF.

2. Export Browser Graph as Video or Multi-frame TIFF

3. Export Image Window All Frames as Video

1. When Image Type is set as tif and multiple pages are selected, there is checkbox "Export as multi-frames TIF file"

2. XF expg2video can be used and we can select type as AVI/GIF/TIFF.

3. Image window can be exported as AVI in cvExport dialog

ORG-25398

Excel Export supports cell formatting

Add checkbox “Export Cell Formats” in expExcel dialog

The following formats are included:

1. Font, including color and size

2. Cell color, including fill color

3. Cell alignment & merge

4. Numeric decimal places

Note: Excel and Origin has different syntax. For those not matching, it will not be supported. E.g. fraction in Origin will show as decimal in Excel.

ORG-25120

Import Export Issues with GeoTIFF in Image Window

Support export Multiframe TIF with GeoTIFF info

Export multiple frames tif file from image window will also export the GeoTIFF info like XY mapping.