Page Comparison

ORG-27279

Split Worksheet and Append Worksheet Improvements

Put value in output sheets label when split worksheet by value change , and use sheet label when appending sheets

• When splitting worksheet by reference column’s value change, the info. was lost in result sheets. In Origin2024, the value will be put to sheet label of each output sheet.

• When appending worksheets and stack worksheets, sheet Label can be used as Data Identifier.

ORG-27301

Join multiple worksheets by matching column with merge option

Support Merge Multiples By option in the wjoinbycol and wjoinbylabel XF tools

• Rename original menu Join Worksheets by Column as Join Two Sheets by Column, which calls wjoincols XF

• Add Join Multiple Sheets by Column menu, which calls wjoinbycol XF.

• Add Merge Multiples by option in the wjoinbycol and wjoinbylabel XF.

ORG-27245

ORG-27538

Smart Paste from Excel

When paste data from Excel, Origin will do a smart checking to detect heading rows and paste to column label.

Also, when paste or import to column label, if there are at least three cells with common Date/Time format, then the label will be set as Date/Time format.

See below, copy all data from Excel. In Origin, new a workbook, paste to A1 cell or highlight column A to paste. Origin will detect the 1st row is heading and paste to Long Name label smartly, and the other data will still paste to data area.

ORG-27538

Support set format for column label row

Support set format for the Long Name, Units, and Comments label row

Starts from Origin 2024, user can set format for the Long Name, Units, and Comments label row in the Worksheet Properties dialog

ORG-27203

Rearrangement of Data Manipulation menu

Move Data Manipulation menu items to other menu

1. Move Reduce Duplicate X Data, Reduce by Group, Reduce to Evenly Spaced X to Worksheet menu.

2. Move Subtract Reference Data,Subtract Straight Line to Analysis: Mathematics menu

3. For graph window,those 3 reduce XFs are still kept in Data Manipulation menu.

ORG-27143

Worksheet Menu Restructure

Add a new main menu Restructure to put data restructuring tools together

For better worksheet data processing, add new main menu Restructure next to Worksheet, and rearrange the menu items.

ORG-27339

Set as Categorical for Column Label Row

Support setting column label row as categorical

In Origin 2024, we supports color plots by column label. But if you plot 2 groups or 2 layers, the column label like “aa” in layer 1 will map to 1st color, but “aa” in layer 2 may map to 2nd color. So “aa” could not refer to same value in different plot groups or layers. With the categories supports, column label with same “aa” can map to same color in different plot groups or layers.

ORG-25662

More Clear options in Worksheet

Add Clear mini toolbar button for single worksheet cell or worksheet range

When user select a single worksheet cell, block of cells, column label row, or click the left-top corner of worksheet, a new mini toolbar button Clear will be shown, allow to clear format, contents, or cell notes.

ORG-27288

Improvement on the Fill Column with dialog

Support Apply button and switching columns in Fill Columns With dialogs

Support Apply button and Switching columns ability in the Fill Columns with dialog, includes patternN, patternT, patternD.

ORG-27642

Convert to XYZ Support Text Z

Convert to XYZ tool supports Text value for Z data

When convert worksheet data to XYZ format, Text value will be allowed for the Z data now.

ORG-27792

Increase Number of Sheets in Book

Increase the limitation of sheets in a book

In the past, only 1,024 sheets is allowed in a book, now user can add up to 4,096 sheets.

ORG-27894

Color column mini toolbar improvements

Load Color List and Edit Color buttons added

Load Color List button is added when clicking on color column header to quickly load color list or palette file.

Edit Color… button is added when clicking on a color cell to open standard Colors dialog to edit or change color easily.

ORG-27857

Worksheet status bar show more info

Show more info for worksheet in the status bar

• Show Range (Maximum - Minimum) statistics info.

• Show column format and data range info when a column is selected, like col(1): Text & Numeric [1:32]

ORG-26812

Provide Rank() function in the SCV

Add a new function Rank() and show it under the function menu in SCV dialog

New function Rank(vd[, n]) is introduced, which return same result of sort.rank() method.

In Set Column Values dialog, you can find it under Function: Data Manipulation category.

ORG-27691

Add Column Type Binary

New column format Binary is introduced