Versions Compared

Key

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

...

Hint on blank Formula and Before Formula Scripts boxes Rename F(X) as F(X)= in Worksheet
Jira Legacy
serverJIRA (originlab.jira.com)
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-11558
 Image Removed 
Jira Legacy
serverJIRA (originlab.jira.com)
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-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
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
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-6077
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-11686
Jira Legacy
serverJIRA (originlab.jira.com)
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10733

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

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

  • 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.

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
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-6093
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10579
,
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-8781
,
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-10393
Jira Legacy
showSummaryfalse
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-11028
  • Search Functions button (same as select Function: Search and Insert...)

  • Search and Insert Functions dialog: Search by keyword. Double click to inset into Formula box. 
  • Click the function description to go to the detail function document page.

  • mod2() and rmod2()  (negative values returned positive dividends) 
  • Value() and Lookup() 
  • isText() function under Function: Miscellaneous: to test if a value is string or number. If string, returns 1, if number or empty, return 0.
  • Interp() function under Function: Math to calculation interpolation of XY based on giving some X values.
  • binopdf() binopdf under Function: Distributions: PDF menu
Some Menu ChangesRename F(X) as F(X)= in WorksheetAdd and reorganized examples under Formula: Load Sample menu
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
Jira Legacy
serverJIRA (originlab.jira.com)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
keyORG-114349471
  1. Move Variables and Constants to the top position of the Variables menu 
  2. Rename the menus under Variables menu to say Add ....  

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

    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
    serverIdde9745f4-6a46-3986-b6b4-6ec476a4c732
    keyORG-11435

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

    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.

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

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

    Image Removed 

     

    If the Set Column Values formula is totally row independent, user can check it to allow sorting worksheet.

     

    ...