...
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
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, or 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.
|
ORG-23417 | Protect Worksheet | Disable Editing of worksheet by adding a lock on sheet |
Lock icon shows in front of sheet name
|
ORG-14088 | Worksheet Cell Rich Text and Wrapping | Allow rich text wrap in worksheet cell | Origin 2023 allow wrapping rich text in worksheet cell. Use Wrap text context menu or Wrap Text checkbox on Format tab of Worksheet Properties dialog. Note: Text will not be wrapped in in-place edit mode. |
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
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 of disabling it. |
Reduce/Combine Duplicated Rows Improvement | Select multiple reference columns added | Select multiple reference columns for row sum. X-Function: wdeldup | |
ORG-25249 | Better default setting when export 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:
|
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, …. |
Analysis
General
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
ORG-24718 | Normalize in each group defined by Group Column | Group control added in Normalize Columns dialog to normalize data with in each group | E.g. Specify Column A (ID) as Group column and choose Normalize Methods as Devided by Max. Origin will find max within each group and divide each value in that group with the group max. |
Gadgets
JIRA | SUMMARY | DESCRIPTION | DETAILS |
---|---|---|---|
ORG-25325 | Control Gadget Button and Label Size | Support way to control default Gadget Button Size and label size | In User File Folder, open Origin.ini, find [Font], add below script to change default button size and label size. GadgetButtonSize=** GadgetLabelSize=** both default value is 16 |
...