Page Comparison

ORG-24917

Layer Title Improvements

Center alignment, wrap text, etc.

Mini toolbar on layer level to add Layer title. A new text box similar to those in PowerPoint and Word will be added. It is center aligned horizontally and wrap text is enabled. The size of the box is defined instead of determined based on wrap text result. Changing the font size will keep title box width. It’s much easier to set title width and align it.

Click on the layer title, and then the mini toolbar button to set box width

LabTalk property to show/hide layer title:

layer.title=1 (show) or 0 (hide)

Wrapped layer title or text box width:

• _title.box=80 //default, title box width is fixed to 80% of layer width. Click on layer title. Box width button is added on mini toolbar to set width. The button only shows if _title.box is bigger than 1.

• _title.box=1 //Powerpoint/Word like text box but can drag the handles around box to resize it.

• _title.box=0 //old text object. The size of text box can’t be very precise, It will be decided by wrap result. It’s hard to position text in expected position especially if contents change.

This <textobject>.box property also applies to regular text object and legend box. By default, it’s 0 though. The box width mini toolbar also only shows if <textobject>.box value is bigger than 1.

ORG-25630

Page Title

Mini toolbar button on page level to add a center-aligned title on top of graph

1. New mini toolbar on page level. A new text box similar to those in PowerPoint and Word will be added. It’s center aligned horizontally and wrap text is on. Size of the box is defined instead of based wrap text result. Change font size will keep title box width. It’s much easier to set title width and align it.

   

2. By default the size is 70% of page width. Click it and use mini toolbar to change width.

   

3. Labtalk access: The page title name is _PTITLE. Use _PTITLE.box to set width, etc. similar to layer title.

ORG-24822

Angle Annotation

Measure the angle between two lines and annotate it

Select Angle Annotation toolbar button.

Single-click 3 times to pick arm, vertex and the other arm. If an arm is close to a data point, it will snap to it.

Click angle and drag anchors to adjust.

Mini toolbar for angle and label for common edit.

Double-click angle or right click and choose Properties to see all options.

Double-click to modify the syntax, e.g. $(v, .3) to show 3 decimal places, $(v*pi/180, .2) to convert degree to radian and show 2 decimal places.

ORG-25362

Custom format to show plus sign for number

We can show positive or negative sign in custom format

In custom format. Add more options to show signs for numbers:

.3 ----- 3 decimal places. old way
+.3  ----- 3 decimal places, always show sign for numbers, if positive, show +, if negative, show a short minus sign -
-.3 ----- 3 decimal places, if positive, no sign, if negative, show LONG minus sign
-+.3 -----  3 decimal places, always show sign for numbers, if positive, show +, if negative, show a long minus sign -

ORG-25376

Show Function Plot and Equation in Legend or Label Improvements

Function plots, used to shows F1 in the legend. Now it shows the Function Formula

ORG-25289

Restore Positon under Graph: Legend menu

Add a submenu under Graph: Legend: to restore legend position

Selecting it would not change user’s customization in legend but move it to default legend position in graph template.

ORG-25354

Hide Legend for Function Plots

Option to hide function plot entries in legend

In previous versions, function plot would always show in legend. In Origin 2023, a context menu is added to Hide Function Plots in legend.

ORG-25355

Avoid using Function plot as Axis title unless it’s the only plot

Data Plot Index for Auto Axis Titles should exclude function plot unless it's the only one

When there are multiple plots (no matter data plot or function plot), Origin uses the 1st plot’s long name, unit as axis title. See the Data Plot Index for Auto Axis Titles dropdown list on Legends/Titles tab of graph node of Plot Details dialog.

So if the function plot is the 1st plot in graph window, F1 will show as axis title. In Origin 2023, we will skip using function plot as axis title unless it’s the only plot in the graph.

Use system variable @FPT=1 to roll back to the old behavior.

ORG-24719

Sort Point by Point legends

Options to sort point by point legend by X, Y, or alphabetical order

In previous versions, when displaying point by point legend, it would always show by row index order.

Sort by options are added to sort by Alphabetical Order, X or Y.

ORG-16929

Add Color block in Legend

Add User defined color block in legend

Can now add user-defined color block in legend

• Right-click Legend and choose Properties to open Text Object - Legend dialog.

• Click Add Legend Symbol button.

• Check the newly added Color Block node in Add legend Symbol dialog and customize as you like.

• Click Add.

• Add Text at the end of the inserted symbol.

ORG-25300

Symbol Map Dialog Improvements

Gear icon on top-right corner of the dialog to manage symbols on each tab

• Add… - Opens a small dialog to enter space separated Unicode codes. Found symbols will be appended to the end of current tab.

  

• Delete… - Opens a small dialog to enter space separated Unicode of symbols you want to remove from current tab. Or click Select button to pick symbols to remove.

  

• Reorder - Drag cell to reorder it. click Done button to accept the change. Note: In this mode, all other operations are disabled.

• Reset to Factory Default - Reset the current tab to default symbols shipped with product.

• Append from Factory Default - If you have deleted some symbols shipped with product, select this will bring them back to original location, while still keep those you added at the end.

ORG-22079

Support UTF32 for custom Unicode Symbol

In Symbol Map: Add Symbol dialog, enter UTF-32 unicide symbol to custom

ORG-25285

In-place edit for wrapped text object

For wrapped text, if not long, double click will enter in-place edit mode. For very long text, open Text Object dialog

• Previously, if text was wrapped, double click it would always open Text Object dialog. In Origin 2023 System Variable @TLIP (default 80) is added. If text length is not more than it, double click will allow in-place edit.

• Previously, if text wasn’t wrapped, double click would always enter in-place edit mode. In Origin 2023 System Variable @TLIPN (default 60) is added for text not wrapped as well. If text length is longer than it, Text Object dialog will open.

ORG-23765

More bracket shapes

Round and brace bracket shapes added

• Dropdown list to pick which bracket/brace to add on Add Object to Graph toolbar.

  

• Use the Mini toolbar to change bracket shape.

  

• Drag the red anchors for curvation and brace.

  

ORG-25512

Improve Worksheet Cell Substitution Format

Keep cell display format in column labels and when using plot index when using W as last argument

When referring to a worksheet cell in a text label in a graph

1. Keep display format in column label cell: e.g. using %([Book1]Sheet1,@WL, B[D1],W), to show user-defined parameter 1 in column B as label, where last argument is w, it will keep display format in that cell

2. Keep display format when using plot index to specify a worksheet cell. E.g.

• Using %(1, @WT, 2, 4, W) - 1st plot’s worksheet, 2nd column, 4th cell, using display format.

• Using %(1@W,2,D1,W) or %(1@W,2,D”mean”,W) - 1st plot’s worksheet, 2nd column’s 1st user-defined parameter, or user-defined parameter row which is named “Hello”, where last argument is w. It will keep display format.

• 

ORG-24940

Separator button added in Text Object dialog

Add Separator button on Text tab of Text Object dialog to easily add an extra space between lines

Added a separator option for all text labels in graph, including legend, axis title, etc.

ORG-14802

Box Chart Legend with Box Style

Add New box chart legend style. And you can customize the box scale via control dialog.

1. In the Box plot, box scale could be added in any of the following ways: Select Insert: Box Scale in the menu, or click the Add Box Scale button on the Add Object to Graph toolbar

   

2. Box Scale Control dialog: This dialog is used to control and customize the style of the box scale.

• Double-click on the box scale to open the dialog. Or right-click on the box scale to select Properties... from the context menu to open it.

• In the box scale, it shows Box Range, Whisker and Median by default. And the displaying of other symbols that depends on they whether selected in the Plot Details dialog.

• And label of these components whether to show that can be controlled in this dialog. Except Box Range, Whisker and Median, if the symbol is not selected in the Plot Details dialog, the label option also will not show in this dialog.

• 

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.