It would be nice if we can programatically call the cell functions (AND, IF ELSE, VLOOKUP etc) directly from code. An example would be, say on a button click, I want to call one of the Excel type functions on all the cells or a select group of cells.
This should be possible using the spreadsheet.range.formula method from the widget's API, Kumar. See this section of the documentation for further reference: http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#methods-formula