format

Gets or sets the format of the cells.

Parameters

format String optional

The new format for the cells.

Returns

String the format of the top-left cell of the range. When used as a setter, format returns the Range object to allow chained calls.

More details about the supported format may be found in the cell formatting help topic.

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").value(12.3456).format("#.###");
    </script>

In this article