Versions Compared

Old Version 27

changes.mady.by.user Cecilia Shi

Saved on

compared with

New Version Current

changes.mady.by.user Wall-E

Saved on

Key

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

Jira Legacy
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10636

...

Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10749

...

ORG-10636

de9745f4-6a46-3986-b6b4-6ec476a4c732ORG-6093serverIdORG-10579, key,summary, type,created,updated,due,assignee,reporter,priority,status,resolution ORG-8781, key,summary, type,created,updated,due,assignee,reporter,priority,status,resolution ORG-10393ORG-11028,ORG-11028,ORG-10768serverIdORG-11435

key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution

ORG-11563
Hint on blank Formula and Before Formula Scripts boxesRename F(X) as F(X)= in Worksheet
ORG-11558ORG-11434
Image Added
  • Makes it clear user doesn't need to enter = as in Excel
  • Ignore = even if it's typed
    Image Added
Coloring BracketsFunction and syntax Help on Status bar and as Smart Hint
ORG-10749ORG-6077 ORG-11686 ORG-10733

This works in many other places that supports writing Script, such as Code Builder, Function Builder, Function Plot, Column Filter, Worksheet Query, etc.

Image RemovedImage Added

  • When mousing over a function under Function menu, function explanation shows on Status bar.

Image RemovedImage Added

  • When a function is selected or a function name is double clicked, smart hint shows to give function info and example. The parameter names are improved.

Image RemovedImage Added

This works in other dialogs with LT function support such as

NLFit, Worksheet Query, Column Filter, Function Plot dialog, Plot Details

Search and Insert FunctionMore Function Support in Set Column Value dialog 
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId
key
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
de9745f4-6a46-3986-b6b4-6ec476a4c732key
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columns
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
key
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columns
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
key
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
key
  • Search Functions button (same as select Function: Search and Insert...)

Image RemovedImage Added

  • Search and Insert Functions dialog: Search by keyword. Double click to inset into Formula box. 
  • Click icon before the function description to go to the detail function document page.
Image Removed
  • This same dialog also allow to find function in other dialogs
    • NLFit: Function: <Search...>
    • Fitting Function Organizer: Search button

Image Added

Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10257
,
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10663
 
  • mod2() and rmod2()  (negative values returned positive dividends) 
  • Value() and Lookup() 
  • isText() function under F(X)Function: Miscellaneous: to test if a value is string or number. If string, returns 1, if number or empty, return 0.
  • Interp() function under F(X)Function: Math to calculation interpolation of XY based on giving some X values.
Some Menu ChangesRename F(X) as F(X)= in Worksheet
  • binopdf(), ksdensity(), ks2density() under Function: Distributions: PDF menu
  • SumIf(), CountIf(), AverageIf() , Correl() and Cov()  under Function: Statistics.
  • lookup() and table() under Function: Lookup & Reference.
  • logncdf() function under Functions:Distributions: CDF
  • logninv() function under Functions:Distributions: INV
Some Menu ChangesAdd and reorganized examples under Formula: Load Sample menu
ORG-10257, ORG-10663ORG-9471
  1. Move Variables and Constants to the top position of the Variables menu 
  2. Rename the menus under Variables menu to say Add ....  

Image Removed

  • Makes it clear user doesn't need to enter = as in Excel
    • Ignore = even if it's typed
    Image Removed

    Image Added

    Select the Formula: Load Sample entry to see the example of operators.

    Image Added

    Insert Mode for inserting variablesContext Menu for F(x)= label row cell
    Jira Legacy
    serverJIRA (originlab.jira.com)
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution

    		de9745f4-6a46-3986-b6b4-6ec476a4c732key
    Jira Legacy
    serverJIRA (originlab.jira.com)
    columns
    serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
    key

    The first time when user uses "Insert Range Variable by Selection" or "Insert Column Label Cell by Selection" , and finish hunting, shows Insert Mode dialog to decide the notation.

    Image RemovedImage Added

    		Image Removed
    Sample formula and menu entry for operators 
    Jira Legacy
    serverJIRA (originlab.jira.com)
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
    keyORG-9471
    		 

    Select the Formula: Load Sample entry to see the example of operators.

    Image Removed
     Image Added
    Allow Sort WorksheetSupport define a range variable from matrix cell(s) in SCV
    ORG-11276ORG-11436

     

     If output data is in a same worksheet as input data, "sort worksheet" will be enabled by default.

    Support range selection from Matrix when using Variables: Add Range Variable by Selection in Set Column Values dialog

    Image Added