Page Comparison

...

JIRA	SUMMARY	DESCRIPTION	DETAILS
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	Move Reduce Duplicate X Data, Reduce by Group, Reduce to Evenly Spaced X to Worksheet menu. Move Subtract Reference Data,Subtract Straight Line to Analysis: Mathematics menu 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. Image Added
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.