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

Improve data format conversion on Copy Paste Column

Smartly change column format on pasting whole column with Date data

When copy whole column with Date data, and pasting to a new column, Origin will do a smart checking and set column as Date format.

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

Improvement on convert a range of worksheet to matrix

Improve the r2m x-function tool to support conversion options

Introduce converstion options in r2m tool to specify where x and y is.

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

In Origin 2024, we introduced a new column format called Binary. It only allow two values (1 and 0).

To set a column as Binary format, you can do it with the column properties dialog, or set from LabTalk script like wks.col1.format = 9.

By default,

• If you enter numeric data, "0" will still display as 0, and "1" still 1. Any values other then 0 and 1 will display as missing(“--”).

• If you enter text, “yes” and “true” will display as 1, “no” and “false” display as 0. Any other texts will display as missing.

ORG-26541

Apply user-defined parameter row(s) to other sheets

New mini toolbar button to apply user-defined parameter row(s) to other sheets

When select column label, a new mini toolbar button called Apply User Parameters to is added. Select it will duplicate selected user parameter to other sheets of selected range. And for user parameter with formula, the formula will also apply for all columns in target sheet.

ORG-26884

Copy Transposed Support

Support Copy Transposed based on selection

Copy Transposed is supported for selected range, and it copies in Text format only.

ORG-27118

Insert discontinuous rows or columns

Support inserting discontinuous rows and columns

From Origin 2024, user could highlight multiple discontinuous whole rows, or multiple discontinuous range blocks, or multiple discontinuous whole columns to insert new rows/columns.