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

    Open In Dojo
        <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