Jira Legacy | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Jira Legacy | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
...
ORG-10636
Hint on blank Formula and Before Formula Scripts boxes | Rename F(X) as F(X)= in Worksheet | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ORG-11558 | ORG-11434 | |||||||||||||||||||||||||
| ||||||||||||||||||||||||||
Coloring Brackets | Function and syntax Help on Status bar and as Smart Hint | |||||||||||||||||||||||||
ORG-10749 | ORG-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. |
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 | |||||||||||||||||||||||||
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 | 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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
- Search Functions button
Search ,ORG-11028,ORG-10768
- Search Functions button (same as select Function: Search and Insert...)
- Search and Insert Functions dialog: Search by keyword. Double click to add inset into Formula box.
- Click icon before the function description to go to the detail function document page.
- This same dialog also allow to find function in other dialogs
- NLFit: Function: <Search...
- >
- Fitting Function Organizer: Search button
Jira Legacy | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Jira Legacy | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
- 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.
- 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
- 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.
ORG-11435
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.
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