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

Sheets.sort.columns

configuration

Specifies the sort options for individual columns.

sheets.sort.columns

Array

<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.columns.ascending

Boolean

Indicates if the data in the cell will be sorted in ascending (true) or descending order (false).

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

sheets.sort.columns.index

Number

The index of the column within the sheet. For example, column C will have an index of 2.

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