| 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.  Image Removed
This works in other dialogs with LT function support such as NLFit, Worksheet Query, Function Plot, Column Filter, Function Plot dialog, Plot Details dialogWorksheet Query, etc.  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. The parameter names are improved.
 Image Removed
 Image Added
This works in other dialogs with LT function support such as Worksheet Query, Column Filter, Function Plot dialog, Plot Details |
| Search and Insert Function | More Function Support in Set Column Value dialog |
|---|
| ORG-6093 | ORG-10579, ORG-8781, ORG-10393,ORG-11028,ORG-10768 |
| 
Image Removed- (same as select Function: Search and Insert...)
 Image Added
- Search and Insert Functions dialog
|
Image Removed
More Function Support in Set Column Value dialog | Some Menu Changes | Rename F(X) as F(X)= in Workshet- : 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) ORG-10579
- Value() and Lookup() ORG-8781
- 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. ORG-10393
- Interp() function under F(X)Function: Math to ORG-11028 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 ORG-10257 menu
- Rename the menus under Variables menu to say Add .... ORG-10663
Makes it clear user doesn't need to enter = as in ExcelIgnore = even if it's typed-
 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
|