Edit this page

input

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.

Parameters

value String |Number |Date optional

The value to be set to the cells.

Returns

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

Example

    <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>

Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy