Page Comparison

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 SheetsSheets

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.

ORG-25211

Create Linked Matrix of ROI

Linked matrix of ROI in image window with proper XY coordinates.

In some cases, a calculation, analysis, or statistics of a region of interest in an image is required. But such operations may only be available in a matrix window.

This previously required 4 steps: add ROI, create linked image of ROI, convert to matrix, do the operation on the matrix.

In Origin 2023, the create linked image and convert steps can be skipped. A Create Linked Matrix context menu is added.

When dragging or resizing the ROI in image, the linked matrix will update accordingly.

ORG-25174

Intensity Profile with small ROI issue

Added Weighted ROI checkbox option to mroiprofile dialog for tiny coordinates ROI.

If this option is selected, each pixel is weighted by the area of the intersection of the pixel rectangle and the ROI polygon.

ORG-23789

ROIs from SVG files

Support creating graph object from SVG file, and create ROI from the graph object.

1.LabTalk command to create a gr. object(only work for Graph):

draw -paths objName <pathname of .SVG file>

2.LabTalk command to create a gr. object, and initially set the rectangle of the created object (only work for Graph):

draw -paths -s MyPath "<path name of downloaded 100960033.svg>"

3.LabTalk command to create a gr. object, and support creating ROI from the path in graph object(work for Graph, Matrix, Image):

draw -paths -d MyPath "<path name of downloaded 100960033.svg>"

4.OC way to add/remove SVG file to a matrix layer and associate it with the active matrix object by index:

4.1.Compile following code and execute load_svg_to_matrix("<svg pathname>") to add SVG file to the active Matrix object of matrix layer.

void	load_svg_to_matrix(string strPathName)
{
	MatrixLayer			matlayer = Project.ActiveLayer();
	if (!matlayer)
	{
		out_str("Matrix must be active!");
		return;
	}
	
	LPCOSTR				lpcszPathName = strPathName;
	OLP					olpRet = matlayer.PathsObjectsManagement(PATHSMNG_ADD_PATHS_OBJ, lpcszPathName);
	if (olpRet <= 0)
	{
		out_str("Failed to add SVG!");
		return;
	}
}

4.2.Compile following code and execute remove_all_svgs_from_matrix() to remove all SVG files from active Matrix layer.

void	remove_all_svgs_from_matrix()
{
	MatrixLayer			matlayer = Project.ActiveLayer();
	if (!matlayer)
	{
		out_str("Matrix must be active!");
		return;
	}
	
	OLP					olpCountRemoved = matlayer.PathsObjectsManagement(PATHSMNG_REMOVE_ALL);
	out_int("Paths objects removed: ", olpCountRemoved);
}

ORG-25600

More on ROIs from SVG files

1. Create ROIs with the sub-paths object’s name by Origin C

2. Origin C support defining sub-paths object’s name by json file

3. Set the transparency, rotation when loading the paths object by Origin C/Labtalk

4. List all sub-paths and create optional ROI by Origin C

5. Optionally highlight/select all sub-paths of one name by Origin C

6. Support showing tooltip when mouse over sub-path

7. More select and highlight feedback on SVG sub-path, set @PDBMI=1/0 to change view mode

8. Support rescaling the paths object along with window

9. Support relocating and resizing the paths object(Keep Aspect Ratio or not)

10. Support Copy Geometry and Paste Geometry context menu for the paths object

11. If paths object is attached to Layer and Scale, press Shift and choose Paste Geometry menu to open the dialog and adjust the geometry value.

1. Pls check the Jira for details about Origin C code.

1. LabTalk command to set the transparency of paths object

   Code Block
   draw -paths -d -t <transparency> objName <pathname of .SVG file>

1. LabTalk command to set the rotation of paths object

   Code Block
   draw -paths -d -r <angleof rotation in degrees> objName <pathname of .SVG file>

1. LabTalk command to skip <rect> element. If the first drawing element is <rect> and its width and height are the same as the width and the height of the root <svg> element, the <rect> element will be skipped.

   Code Block
   draw -paths -d -rr objName <pathname of .SVG file>

ORG-25854

X-Function pkfind supports filtering peaks by height percent

A 4th choice “Height %“ is added to the “Filter Peaks by“ combo

ORG-25799

Wrong ROI name if creating multiple ROIs

Support to use acronyms for ROI names created by SVG path objects

ORG-25385

Folder and Window Navigation

Added features to folder management to make it easier to navigate folders, Seesaw (toggle folders) and add shortcuts, etc.

Folder & Windows toolbar added

• Folder Back: – go to previous folder

• Folder Forward – go to next folder

• Seesaw (Ctrl+Alt+X) – toggle between recent two folders

• Add shortcut to previous folder(Ctrl+Shift+F7) – add active window as shortcut to previous folder

• Add shortcuts from previous folder – bring up a dialog to add windows from previous folder as shortcuts in active folder

• Arrange Windows - arrange windows in current folder using <last used> theme

• Pin Window - Pin a window so it will be excluded when arrange windows

Menu and context menu added

• Window: Seesaw (Ctrl+Alt+X) menu

• Context menu by right-clicking window title to add shortcut to previous folder (Ctrl+Shift+F7)

• Right-click a window title to pin the window.

ORG-25422

Folder Notes

Add Notes for a folder in Project

• Right-click a folder in PE and choose Folder Note… to add folder notes.

  

• Hold Ctrl and hover the cursor over the folder to view folder notes with Origin rich text syntax

  

• Added System Variable @FNS to set default syntax for folder note. Default is 3 = Origin Rich Text

ORG-25498

Mini toolbar on folders in Project Explorer

Mini toolbar on folders on top panel of Project Explorer for common manipulation

If not current folder, click either folder icon or folder name will show the mini toolbar.

If it’s current folder, please click the folder icon part to show the mini toolbar. Click folder name will enter the rename folder mode.

The three buttons on the Mini toolbar are:

• Add/Edit Folder Note

• Duplicate Folder

• Open Folder Properties dialog

There are context menu for these as well when right clicking a folder.

ORG-25451

Default toolbar layout in Origin 2023

1. Put the Folder and Window toolbar on top, right above PE, and below the Standard toolbar, in the second row, and push the ones there to the right

2. Remove Arrow and Layout toolbar

ORG-25253

Arrange Window Improvements

More improvements are added such as include minimized window or exclude pinned window in window arrangement

• Checkbox to include Minimized window option in the Arrange Windows dialog

  

• Pin a window so it will be excluded when arranging windows — Right-click a window to pin it or click Pin Windows button on Folder and Windows toolbar.

  

ORG-24746

Improve Shortcuts to Show Pages from two folders

Add shortcuts of windows in another folder to activate the folder for comparison

Only windows in active folder show in workspace.

To compare windows in active folder with some windows in other folder:

1. Go to Project Explorer.

2. Right-click the non-active folder and choose Add Shortcuts…

3. It will open a dialog to pick the window types there to bring to the active folder as shortcuts.

4. Click OK.

5. Notice such windows in the other folder show as shortcuts (see Home button on title bar)

6. Afterwards, these shortcut windows can be deleted. Or right-click the folder in Project Explorer and choose Remove Shortcuts.

ORG-25423

More on Improve Shortcuts 2023

Window menu add new items for Shortcuts

1. Seesaw: Return to previous folder

2. Add Shortcut from Last Folder to Current Folder

3. Remove Shortcuts.

4. Added a new LabTalk Command:

   doc -rs; //remove only current folder's shortcuts

   doc -rsr; //this is from the menu and will remove sub-folder shortcuts as well.

ORG-25343

Restore window size

Window: Restore Window Size to restore window size and positions

After arranging window layout in a folder, a window may be temporarily or accidentally, moved or resized.

To return to the previous arrangement, select Window: Restore Window Size: (Ctrl+Shift+Z) to restore the window to original size and positon.

This also works to restore maximized or minimized child windows

ORG-25372

Tooltip on Menu Items

Show menu hint as tooltip and F1 for Help

• Support pressing F1 when mousing over menu item and toolbar buttons to open corresponding Help file. In the past user would need to open the tool first and then press F1 to open Help.

• When mousing menu item, tooltip shows. In the past when mousing over menu item, hint showed on Status bar at the bottom of Origin workspace. It’s far from the menu so user may not even notice it. Tooltip used to show only for toolbar buttons in Origin.

ORG-24937

Easier hot keys to zoom and scale in

Hold Z key, right-click and drag to change the scale.

Hold Z key, right-click and drag to change the scale.

• Right-click and drag up/down to rescale y-axis in/out.

• Right-click and drag right/left to rescale x axis in/out.

ORG-25453

Easier way to save window to project folder

Provide <Project Folder> in built-in File Path list of Save Window As… dialog

In the Save Window As dialog, click File Path list.

Two extra paths are added related to Project Path to easily save a window to same folder as the project file or a subfolder based in Project Explorer structure.

ORG-25448

Recent Project History

OriginProjHistory.txt in UFF

OriginProjHistory.txt created to list recent Origin files, e.g. project, graph, workbook, etc.

System variable @MHF=1000 (default) : max number of entries to keep

Set it to 0 or less to stop adding entries.

ORG-25528

Stop saving project as OPJ format

Only support saving as OPJU format

OPJ files saved in Origin 2023 will not be able to be opened in older versions that don’t support OPJU.

So we removed saving OPJ files from the menu and OriginC.

Old OPJ files can still be opened in 2023.

ORG-25442

Support decimal place customization of the result label of Graph Maker

Implemented support for adding number after * to set decimal places

ORG-25756

Add App Tutorial web page for app

add context menu for user to open App Tutorial web page

1. Rename “Open File Exchange Page“ context menu to “Open App Webpage“

2. Add “Open App Tutorial Webpage“ context menu to open App Tutorial page, if tutorial is not existing, origin will open Request App Tutorial page, user can easily to post request if needing tutorial for complex app.

ORG-25432

Change OPJU File Type to Origin Project

Change OPJU File Type to Origin Project

In Origin 2022b and earlier versions, File>Open dialog, users are not sure which file type is the Origin project file because currently OPJU files are listed as “Unicode Origin Graph”, which is confusing.

In Origin 2023 version, opju and oggu show as “Origin Project”; while opj and ogg still shows as “Origin Graph“.

ORG-25546

Hot key to Return the MDI child window

Press Ctrl+Enter to Retun the MDI child window

For a worksheet, Add Graph as Sheet, double click the Graph sheet, now support Ctrl+Enter to accept changes and close, the same behavior as the Return button in top-right corner.

Note: The hotkey works for other window type, like image etc., and works in Project Explorer: Comment