Page Comparison

Image Added

• Makes it clear user doesn't need to enter = as in Excel
• Ignore = even if it's typed
  Image Added

This works in many other places that supports writing Script, such as Code Builder, Function Builder, Function Plot, Column Filter, Worksheet Query, etc.

Image RemovedImage Added

• When mousing over a function under Function menu, function explanation shows on Status bar.

Image RemovedImage 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 RemovedImage Added

This works in other dialogs with LT function support such as

NLFit, Worksheet Query, Column Filter, Function Plot dialog, Plot Details

• Search Functions button (same as select Function: Search and Insert...)

Image RemovedImage 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.

Image Removed

• • ..>
  • Fitting Function Organizer: Search button

Image Added

• 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() 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

1. Move Variables and Constants to the top position of the Variables menu 
2. Rename the menus under Variables menu to say Add ....  

Image Removed

• Makes it clear user doesn't need to enter = as in Excel
• Ignore = even if it's typed
  Image Removed

Image Added

Select the Formula: Load Sample entry to see the example of operators.

Image Added

key,summary,type,created,updated,due,assignee,reporter,priority,status,resolutionserverIdde9745f4-6a46-3986-b6b4-6ec476a4c732keyORG-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.

Image Removed

Image Removed

Image Added

Image Added

Select the Formula: Load Sample entry to see the example of operators.

Image Removed

If the Set Column Values formula is totally row independent, user can check it to allow sorting worksheet.

Image Removed

 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