New to Kendo UI for jQuery? Start a free 30-day trial

Input

methods

Gets or sets the value of the cells. This is similar to value, but it parses the argument as if it was entered through the text box:

if it starts with = (equal sign), a formula is set. This may throw an error if the formula is syntactically invalid. Example: range("C1").input("=A1+B1").
if it looks like a number, a numeric value (not string) is set.
if it's true or false (case-insensitive) the respective boolean value is set.
if it's a Date object, or a string that can be parsed as a date, it is converted to the numerical representation of the date.
if it starts with ' (single quote), a string containing the rest of the characters is set. Example: range("A1").input("'TRUE") — sets the text "TRUE", not the boolean.

input

Returns:Object

the current value of the top-left cell of the range.

<div id="spreadsheet"></div>
<script type="text/javascript" charset="utf-8">

    $("#spreadsheet").kendoSpreadsheet();

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    var sheet = spreadsheet.activeSheet();

    sheet.range("A1").input("1");
    sheet.range("A2").input("=A1*2");
</script>