Hint on blank Formula and Before Formula Scripts boxes | Rename F(X) as F(X)= in Worksheet |
---|
Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11558 |
---|
|
| Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11434 |
---|
|
|
| - Makes it clear user doesn't need to enter = as in Excel
- Ignore = even if it's typed
|
Coloring Brackets | Function and syntax Help on Status bar and as Smart Hint |
---|
Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10749 |
---|
|
| Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-6077 |
---|
|
Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11686 |
---|
|
Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | 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.
| - 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 Function | More Function Support in Set Column Value dialog |
---|
Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-6093 |
---|
|
| Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10579 |
---|
| , Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-8781 |
---|
| , Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10393 |
---|
| , Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11028 |
---|
| , Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10768 |
---|
|
|
- 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() under Function: Distributions: PDF menu
- SumIf(), CountIf() and AverageIf() under Function: Statistics.
- lookup() and table() under Function: Lookup & Reference.
|
Some Menu Changes | Add and reorganized examples under Formula: Load Sample menu |
---|
Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10257 |
---|
| , Jira Legacy |
---|
showSummary | false |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-10663 |
---|
|
| Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-9471 |
---|
|
|
- Move Variables and Constants to the top position of the Variables menu
- Rename the menus under Variables menu to say Add ....
| Select the Formula: Load Sample entry to see the example of operators.
|
Insert Mode for inserting variables | Context Menu for F(x)= label row cell |
---|
Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11435 |
---|
|
| Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-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.
| |
Allow Sort Worksheet | Support define a range variable from matrix cell(s) in SCV |
---|
Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11276 |
---|
|
| Jira Legacy |
---|
server | JIRA (originlab.jira.com) |
---|
serverId | de9745f4-6a46-3986-b6b4-6ec476a4c732 |
---|
key | ORG-11436 |
---|
|
|
If the Set Column Values formula is totally row independent, user can check it to allow sorting worksheet.
| Support range selection from Matrix when using Variables: Add Range Variable by Selection in Set Column Values dialog
|