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

Sheets.sort

configuration

Defines the sort criteria for the sheet.

sheets.sort

Object

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        sort: {
            ref: "A1:B5",
            columns: [{
                index: 0,
                ascending: false
            }]
        },
        rows: [{
            cells: [{
                value: "Name"
            }, {
                value: "Age"
            }]
        }]
    }]
});
</script>

sheets.sort.columns

Array

Specifies the sort options for individual columns.

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        sort: {
            ref: "A1:C5",
            columns: [{
                index: 0,
                ascending: true
            }, {
                index: 1,
                ascending: false
            }]
        }
    }]
});
</script>

sheets.sort.ref

String

The sorted range, for example, A1:D5.

<div id="spreadsheet"></div>
<script>
$("#spreadsheet").kendoSpreadsheet({
    sheets: [{
        name: "MySheet",
        sort: {
            ref: "A1:D5",
            columns: [{
                index: 0,
                ascending: true
            }]
        }
    }]
});
</script>

Sheets.sort

sheets.sort

sheets.sort.columns

sheets.sort.ref

Related Members