| Hint on blank Formula and Before Formula Scripts boxes | Rename F(X) as F(X)= in Worksheet |
|---|
| ORG-11558 | ORG-11434 |
 Image Added | - Makes it clear user doesn't need to enter = as in Excel
- Ignore = even if it's typed
 Image Added
|
| Coloring Brackets | Hint Function and syntax Help on Status bar and When Editing the Function | Search Function | as Smart Hint |
|---|
| ORG-10749 | ORG-6077 ORG-11686 ORG-609310733 |
This works in many other places that supports writing Script, such as Code Builder, Function Builder as well, Function Plot, Column Filter, Worksheet Query, etc.  Image Removed Image Added
| - When mousing over a function under F(X) Function menu, function explanation shows on Status bar.
 Image Removed Image Added
- When a function is selected or a function name is double clicked, smart hint shows to give function info . and example.
 Image Removed- The parameter names are improved.
 Image Added
This works in other dialogs with LT function support such as NLFit, Worksheet Query, Column Filter, Function Plot dialog, Plot Details dialog. |
| Search | Functions button
Image Removed
- Search Functions dialog: Search by keyword. Double click to add into Formula box.
Image Removed
and Insert Function | More Function Support in Set Column Value dialog | Some Menu Changes | Rename F(X) as F(X)= in Workshet |
|---|
| ORG-6093 | ORG-10579, ORG-8781, ORG-10393,ORG-11028ORG-10257,ORG-10663 | | 10768 |
- Search Functions button (same as select Function: Search and Insert...)
 Image 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.
- This same dialog also allow to find function in other dialogs
- NLFit: Function: <Search...>
- Fitting Function Organizer: Search button
 Image Added
| - 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
|
| Some Menu Changes | Add and reorganized examples under Formula: Load Sample menu |
|---|
| ORG-10257, ORG-10663 | ORG-9471 |
- Move Variables and Constants to the top position of the Variables menu
- Rename the menus under Variables menu to say Add ....
 Image Removed
Makes it clear user doesn't need to enter = as in ExcelIgnore = 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 variables | Context Menu for F(x)= label row cell |
|---|
ORG-11435 | 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.  Image Added
|  Image Added |
| Allow Sort Worksheet | Support define a range variable from matrix cell(s) in SCV |
|---|
| ORG-11276 | ORG-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
|