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 |
---|
|
|
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg5/92_SCV_static_hint.png) | - Makes it clear user doesn't need to enter = as in Excel
- Ignore = even if it's typed
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_FX_wksheet.png)
|
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. ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg3/92_ColorBrackets.png)
| - When mousing over a function under Function menu, function explanation shows on Status bar.
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_hint_status_bar.png)
- 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.
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_Smart_hint.png)
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...)
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_Search_button.png)
- 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.
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_Search_Function.png)
| - 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 ....
![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_Variables_menu.png)
| Select the Formula: Load Sample entry to see the example of operators. ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_operator.png)
|
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. ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_InsertMode.png)
| ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_Fx_cell.png) |
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. ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg4/92_SCV_Allow_Sort_Worksheet.png)
| Support range selection from Matrix when using Variables: Add Range Variable by Selection in Set Column Values dialog ![](https://dl.dropboxusercontent.com/u/69449127/WikiImg5/92_SCV_add_range_from_matrix.png)
|