SpreadsheetEventBuilder

Methods

InsertSheet(System.String)

Triggered when a sheet is inserted. Introduced in the 2017 Q1 release.

For more information see InsertSheet event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the insertSheet event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.InsertSheet("onInsertSheet"))
            )

RemoveSheet(System.String)

Triggered when a sheet will be removed. Introduced in the 2017 Q1 release.

For more information see RemoveSheet event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the removeSheet event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.RemoveSheet("onRemoveSheet"))
            )

RenameSheet(System.String)

Triggered when a sheet will be renamed. Introduced in the 2017 Q1 release.

For more information see RenameSheet event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the renameSheet event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.RenameSheet("onRenameSheet"))
            )

SelectSheet(System.String)

Triggered when a sheet will be activated. Introduced in the 2017 Q1 release.

For more information see SelectSheet event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the selectSheet event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.SelectSheet("onSelectSheet"))
            )

UnhideColumn(System.String)

Triggered when a column will be shown. Introduced in the 2017 Q1 release.

For more information see UnhideColumn event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the unhideColumn event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.UnhideColumn("onUnhideColumn"))
            )

UnhideRow(System.String)

Triggered when a row will be shown. Introduced in the 2017 Q1 release.

For more information see UnhideRow event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the unhideRow event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.UnhideRow("onUnhideRow"))
            )

HideColumn(System.String)

Triggered when a column will be hidden. Introduced in the 2017 Q1 release.

For more information see HideColumn event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the hideColumn event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.HideColumn("onHideColumn"))
            )

HideRow(System.String)

Triggered when a row will be hidden. Introduced in the 2017 Q1 release.

For more information see HideRow event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the hideRow event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.HideRow("onHideRow"))
            )

DeleteColumn(System.String)

Triggered when a column will be deleted. Introduced in the 2017 Q1 release.

For more information see DeleteColumn event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the deleteColumn event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.DeleteColumn("onDeleteColumn"))
            )

DeleteRow(System.String)

Triggered when a row will be deleted. Introduced in the 2017 Q1 release.

For more information see DeleteRow event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the deleteRow event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.DeleteRow("onDeleteRow"))
            )

InsertColumn(System.String)

Triggered when a column will be inserted. Introduced in the 2017 Q1 release.

For more information see InsertColumn event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the insertColumn event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.InsertColumn("onInsertColumn"))
            )

InsertRow(System.String)

Triggered when a row will be inserted. Introduced in the 2017 Q1 release.

For more information see InsertRow event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the insertRow event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.InsertRow("onInsertRow"))
            )

Select(System.String)

Triggered when the Spreadsheet selection is changed. Introduced in the 2017 Q1 release.

For more information see Select event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the select event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Select("onSelect"))
            )

ChangeFormat(System.String)

Triggered when the range format is changed from the UI. Introduced in the 2017 Q1 release.

For more information see ChangeFormat event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the changeFormat event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.ChangeFormat("onChangeFormat"))
            )

Changing(System.String)

Triggered when a value or validation in the Spreadsheet is about to be changed upon user interaction.

For more information see Changing event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the changing event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Changing("onChanging"))
            )

Change(System.String)

Triggered when a value in the Spreadsheet has been changed. Introduced in the 2016.Q1.SP1 release.

For more information see Change event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the change event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Change("onChange"))
            )

Render(System.String)

Triggered after the widget has completed rendering. The event will also fire when a cell is selected or when the Spreadsheet's tools (bold, italic) are used, as the target element is re-generated with new styles (e.g background-color, box-shadow, font-weight, etc.).

For more information see Render event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the render event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Render("onRender"))
            )

ExcelExport(System.String)

Fires when the user clicks the Export to Excel toolbar button.

For more information see ExcelExport event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the excelExport event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.ExcelExport("onExcelExport"))
            )

ExcelImport(System.String)

Fired when the user clicks the Open toolbar button.

For more information see ExcelImport event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the excelImport event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.ExcelImport("onExcelImport"))
            )

PdfExport(System.String)

Fired when the user initiates the export to PDF.

For more information see PdfExport event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the pdfExport event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.PdfExport("onPdfExport"))
            )

Copy(System.String)

Fired when a range of a sheet is about to be copied.

For more information see Copy event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the copy event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Copy("onCopy"))
            )

Cut(System.String)

Fired when a range of a sheet is about to be cut.

For more information see Cut event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the cut event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Cut("onCut"))
            )

Paste(System.String)

Fired when a data is about to be pasted in a sheet.

For more information see Paste event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the paste event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.Paste("onPaste"))
            )

DataBinding(System.String)

Fired when the data retrieved from a DataSource is about to be bound to a sheet. Available only if DataSource has been defined for at least one sheet.

For more information see DataBinding event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the dataBinding event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.DataBinding("onDataBinding"))
            )

DataBound(System.String)

Fired when the data from a DataSource is already populated in a sheet. Available only if DataSource has been defined for at least one sheet.

For more information see DataBound event.

Parameters

handler - System.String

The name of the JavaScript function that will handle the dataBound event.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Events(events => events.DataBound("onDataBound"))
            )