Page Comparison

ORG-25449

Improvements on Export Graph (Advanced) - Beta2, Beta4

Added hotkey Ctrl+Alt+G to export with last used theme. Added a clickable link on messages log to view exported graph

• With Graph window active, press Ctrl+Alt+G to export graph with last used theme without opening the dialog.

• After exporting a graph, the file path is dumped to the Messages Log and is clickable to view the exported graph - Beta2

  

• System Variable to control output to message log.

0 = message with link
1 = no message
2 = link only

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

Toggle layer, plot & graphic object’s selectability

LabTalk command and mini toolbar button to set whether or not layer, plot, or graphic objects are selectable.

• Set plot, graphic object or layer to be unselectable so users can not click to select it in graph and edit it with mini toolbar or regular toolbars, etc.

• Clicking the item in Object Manager is always supported. Users can then use the mini toolbar button to turn selectability back on.

• Corresponding LabTalk property for graphic objects object.mouse=0 not selectable or 1 selectable

• For layers in graphs, selectability can also be globally (it is an Origin setting) prohibited by setting @GRLS=0.
  

  

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 user moves the function plot as 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-24990

Batch Plotting Short Name

Better handling of Batch Plotting Short Name numbers.

Short Name starting with G09 will increment to G10 instead of G010.

ORG-20137

Data highlight mode when switching to worksheet

System variable to quit data highlight mode when switching to worksheet

Set System Variable @QDHT=1, data highlight some data points in graph and switch to worksheet, escape the data highlight mode and allow to plot directly with partial data selected.

Default value is 0, data highlight mode kept when switching to worksheet.

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

Axis Reference Line improvements

Reference line label consider divide by factor

Reference line label will follow divide by factor of tick labels.

E.g. For scales from 1 to 10, if tick label is set to have divide by factor of 0.01, the tick labels will show as 100 to 1000.

When adding reference line at 700, the reference line label will show 700. Used to show 7 (original scale)

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

• In the past, 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.

• In the past, 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-25211

More Image Window ROI Tools

Recalculate ROI (Rectangle) to copy to matrix/graph with proper XY coordinates.

• Import an image and use Rectangle tools to select Region of Interest (ROI)

• Right-click ROI and choose Create Linked Matrix

• Drag the ROI and see the linked the image to show updated ROI

ORG-25350

Fit Layers to Page more accurate

Boundary is more accurate after fitting layers to page and LabTalk command is added

The margin for Fit Layer to Page is more accurate in graph.

Added LabTalk commands to specify each margin separately.

-ml value // for left margin
-mt value // for top margin
-mr value // for right margin
-mb value // for bottom margin

All the margin values can be negative if necessary. For example, using the following will make the graph look tighter to also accommodate for text object rectangles of the axis titles being too large.

page -FLS -u -c 3 -ml -0.005 -mt 0.001 -mb -0.005 -mr 0.001

ORG-25023

Keep Graph and Worksheet size in layout window when copying and pasting

Hold Alt key and then paste graph or worksheet in layout to another layout window to keep the size

Added the hot key Alt when copying and pasting images, graphs, and worksheet objects among layout or graph windows.

Hold Alt while pasting graph or worksheet objects from one layout to another will retain the size properties of the copied selection.

ORG-23765

More bracket shapes - Beta2

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

Column type in plotmyaex Dialog - Beta2

Support Column type in Multiple-Y Axis plot

In plotmyaxes dialog (menu: Plot>Multi-Panel/Axis: Multiple Y Axes)

Plot Type “Column“ is supported

ORG-25145

Move data point improvement

Keep plot customization when move data point

In the past, choosing Data: Move Data Points, plot customization are not kept. Plots changed to default black symbol.

In 2023, user can press Tab to toggle between using default scatter symbol or customized symbol.

ORG-24917

Layer Title Improvements

Center alignment, wrap text, etc.

When right clicking a layer and choose Add/Modify Layer Title, it will be center aligned and wrap text checked.

Use _TITLE.box= to set the width of layer title. E.g. _TITLE.box=100 means the width of text box is 100% the width of layer .

ORG-24822

Angle Annotation - Beta2

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

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

Improve Worksheet Cell Substitution Format - Beta4

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

When referring to worksheet cell in text label in 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-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.

LabTalk property for worksheet:

wks.band=

• =0, Off

• =1, On

System Variables to control banding color and if it shows on odd or even rows:

@WBC - RGB color

@WBE=0 -odd rows, or 1 - even rows

ORG-22868

Freeze Panes

Freeze rows and columns in worksheet

Freeze row or column makes navigating worksheet much easier.

• View: Unfreeze/Freeze Panes menu or Ctrl+Shift+F hotkey

• Click a single cell, column or row and use mini toolbar to freeze panes

• Click upper-left corner of worksheet to unfreeze panes

  

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 Sheet - Beta3

Hide sheets in workbook

• Right click sheet tab(s) to hide.

  

• Right click in Object Manager to hide/show

  

• Show/Hide sheets in Navigate Worksheets dialog

  

ORG-14088

Worksheet Cell Rich Text and Wrapping

Allow rich text wrap in worksheet cell

Origin 2023 allows wrapping rich text in worksheet cell.

Use Wrap text context menu or Wrap Text checkbox on Format tab of Worksheet Properties dialog.

Also, add a mini toolbar button for label row to easily turn on/off wrap text.

Note: Text will not be wrapped in in-place edit mode.

If both rich text and wrap are checked in data cell, the text will be center aligned vertically.

Set @DCWRVC=0 to so text is top aligned.

ORG-25184

Drag and drop multiple sheets

Move multiple sheets to another book or new book by drag and drop

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

• Drag them to another book to move it.

• 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 to disable it.

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, Command window, etc., the auto complete hint will show the parameters of the function for easily enter.

ORG-25369

Reduce/Combine Duplicated Rows Improvement

Select multiple reference columns added

Added the ability to select multiple reference columns for row sum.

X-Function: wdeldup

ORG-19861

More Merge by options for reduce columns - Beta4

Custom option is added to reduce columns by average + sd, etc.

Worksheet: Reduce Columns…

Set Merge by Custom so user can specify multiple quantities to output.

Note: sd column will be set as YErr automatically.

ORG-25249

Better default setting when exporting GeoTIFF files

We have a default geo information setting in the exporting matrix as image dialog when it is tif type.

Default settings of exporting GeoTIFF, from both matrix and image window, are updated as following:

1. GT Model = Geodetic

2. EPSG = 4326

3. Angular Units = Degree

4. Linear Units = Meter

5. Vertical Units = Meter

ORG-25395

Autofill for Column Formula Improvements

Enumerate column part with Ctrl+drag

E.g. 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 label row selection - Beta3

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 selection in data area.

ORG-25450

Use Column Long Name as User Parameter Name for Unstack Column Group Info Row

For unstack column, when choose Put Grouping Info to Custom, and select user parameter for Labels to Store Grouping info, then the long name (if not empty) of group column will be used as user parameter label name.

ORG-25549

Worksheet cell insert Image from files supports direction - Beta4

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

Default Row Major will insert images to same row first, which works same as before. The Column Major will insert images to same column first.

ORG-25548

Improvement to Cell URL Link notation - Beta4

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

• labtalk:// notation to execute LabTalk Script

  Code Block
  labtalk://";ty -b hello" Hello World

• path:// notatoin 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-25526

Other Options in Data Connector - Beta4

Click Other Options button in Data connector for more options

Options includes

• Add Sparklines

• Rename book & sheet – only available for CSV Connector

• Post Import Labtalk Script

ORG-25069

Support importing Shapefiles in geodetic format

Added checkbox “Convert to WGS84” to dialog.

If “Convert to WGS84” is selected on import, thenthe XY values are converted from meter to longitude and latitude.

ORG-25314

CSV and Excel Connector to allow LabTalk script post import

Added Post Import LabTalk Script option to Other Options dialog in Import Options dialog for CSV Connector and Excel Connector.

To run a LabTalk script to process the imported data after import, enter the LabTalk scripts into Post Import LabTalk Script editbox in Other Options dialog. Only available for CSV Connector and Excel Connector.

ORG-25113

Import Excel with merged cell improvements

Different treatment of merged cell in column label row and data area

If a merged cell is in data comments area, the cells will be merged vertically but duplicated horizontally.

Merged cells in data area will duplicate in each cell.

System variable is @XMD (default 1 to duplicate in data area)

ORG-25322

GUI to edit user defined type Import Filter

Improve iwfilter X-Function to support edit Python or LabTalk code from user defined import filter.

Open iwfilter dialog and then load user defined type Import Filter, it will show User Defined branch, underneath will be 3 branches with checkbox to enable, Python Code, Python File, Origin C.

ORG-25508

Connect to Web Issues

separate out the “Recent URLs” menu in Connet to WebRecent URLs dialog into two menus “Sample URLs“ and “Recent URLs“

Preshipped sample URLs will be list in “Sample URLs“ menu, and the recent used URLs will be list in “Recent URLs“ menu.

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 when right click 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 folder in PE and choose Folder Note… to add folder notes. - Beta2

  

• Ctrl+Mousing over folder to view folder notes - Beta3

  

ORG-25498

Mini toolbar on folders in Project Explorer- Beta4

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

3 buttons exist on mini toolbar.

• Add/Edit Folder Note

• Duplicate Folder

• Open Folder Properties dialog

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 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 shows 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 for user to pick window types there to bring to active folder as shortcuts.

4. Click OK.

5. → Such windows in other folder show as shortcuts (see Home button on title bar)

6. Afterwards, user can delete such shortcut windows. 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 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 non-maximized window size and position

After arranging window layout in a folder, user may resize or move a window.

User can choose Window: Restore window size (Ctrl+Shift+Z) to restore the window to original size and positon.

ORG-24937 -Beta2

Easier hot keys to zoom and scale in

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

Press 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 Save Window As dialog, click File Path list.

Two extra path are added related to Project Path so user can easily save window to same folder as project file or 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.