Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

  • 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

  • Choose Preferences: Protect Sheet Options menu to customize protection exceptions.

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

  • 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 of disabling it.

ORG-25369

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:

  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, ….

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.

Image Added

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

...