Versions Compared

Old Version 51

changes.mady.by.user Wall-E

Saved on

compared with

New Version Current

changes.mady.by.user Echo Chu

Saved on

Key

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

...

JIRASummaryDetails

ORG-9939

ORG-15402 S1

  • Indicator on upper-left corner of worksheet. Column Short Names case sensitive and not renameable, e.g. A, B, ...Z, AA, AB, ...
  • Window properties control




  • This is the default mode for Origin workbooks. Alphabetic short names will be used and not renameable.
  • Column formula can use Excel like A1 notation 
  • Refer to columns in other sheet or book is easier, e.g. Sheet1!B or 1!B, [Book1]1!B
  • Use Window Properties dialog to turn it off.

Image Added

Image Added

A new properties is added to Page object. Use page.xlcolname to control the Spreadsheet Cell Notation in current Workbook window.

A new macro clrx is added to globally turn off the Spreadsheet Cell Notation in Origin. Once the macro has been run, the Spreadsheet Cell Notation will be always off even restart Origin.


Info

@RCN can be used to enables or disables spreadsheet cell notation (SCN) in the workbook.

  • 0 = Cell notation is turned OFF for all new books.
  • 1 = Cell notation is turned ON for new books created from the New Workbook toolbar button.
  • 2 = When importing, cell notation behavior follows active book; if cell notation is OFF, then OFF in all new books. If ON, ON in all new books.
  • 4 = Most analysis X-Functions have an Auto Spreadsheet Cell Notation on New Book check box that is shown in X-Function Tree View mode (exceptions are wsplit, wsplit_book, merge_book, wmove_sheet). When this box is checked and this bit is enabled, any new workbook created for X-Function output will have SCN turned on (Auto On) regardless of the SCN-state of the active book..

Note that bit values are additive (e.g. @RCN = 7 means cell notation is Auto On for conforming analysis tools (4), import follows active book(2), and SCN is ON for all new worksheets from toolbar(1)).

Image Removed

Image Removed

A new properties is added to Page object. Use page.xlcolname to control the Spreadsheet Cell Notation in current Workbook window.

A new macro clrx is added to globally turn off the Spreadsheet Cell Notation in Origin. Once the macro has been run, the Spreadsheet Cell Notation will be always off even restart Origin

.


ORG-14598


Spreadsheet cell notation in Column Formula

    • A - refers to column A. e.g. sin(A)
    • A1 - refers to 1st cell of column A. E.g. sin(A)-A1
    • Sheet1!A - refers to column A of Sheet1 in current book. E.g. Sheet1!A-Sheet2A
    • Sheet1!A1- refers to 1st cell of column A of Sheet1 in current book
    • [Book1]Sheet1!A - refers to column A of Sheet1 in Book1
    • [Book1]Sheet1!A1 - refers to 1st cell of column A of Sheet1 in current Book1
    • 1!A - refers to column A of 1st sheet in current book
    • [Book1]1!A - refers to column A of 1st sheet in Book1



In F(x) cell or Formula box of Set Column Values dialog, use A3 instead of A[3] to refer to 3rd cell in column A.

System variable @XCA=0 to toggle this off


ORG-10977Formula updates when related column position is changed with Column Short Name Restriction is onSystem variable @DEFU = 1 to disable automatically update formula and return to the old code.
ORG-14364Improve F(x) row support

Lower case i and j refer to row number and column number respectively, while upper case I and J refer to column I and J respectively. Lower case letter, except for i and j, will be converted to its upper case automatically matching the existing column. New system variable @AUN = Auto UpperCase Name is added and default is 1 = ON.

XLColName is not only available to LabTalk script but also available in OriginC now.

...