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"))
            )

InsertSheet(System.Func)

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

For more information see InsertSheet event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.InsertSheet(@<text>
                           function(e) {
                           // Handle the InsertSheet event 
                           }
                           </text>)
                        )
            )

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"))
            )

RemoveSheet(System.Func)

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

For more information see RemoveSheet event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.RemoveSheet(@<text>
                           function(e) {
                           // Handle the RemoveSheet event 
                           }
                           </text>)
                        )
            )

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"))
            )

RenameSheet(System.Func)

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

For more information see RenameSheet event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.RenameSheet(@<text>
                           function(e) {
                           // Handle the RenameSheet event 
                           }
                           </text>)
                        )
            )

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"))
            )

SelectSheet(System.Func)

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

For more information see SelectSheet event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.SelectSheet(@<text>
                           function(e) {
                           // Handle the SelectSheet event 
                           }
                           </text>)
                        )
            )

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"))
            )

UnhideColumn(System.Func)

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

For more information see UnhideColumn event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.UnhideColumn(@<text>
                           function(e) {
                           // Handle the UnhideColumn event 
                           }
                           </text>)
                        )
            )

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"))
            )

UnhideRow(System.Func)

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

For more information see UnhideRow event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.UnhideRow(@<text>
                           function(e) {
                           // Handle the UnhideRow event 
                           }
                           </text>)
                        )
            )

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"))
            )

HideColumn(System.Func)

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

For more information see HideColumn event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.HideColumn(@<text>
                           function(e) {
                           // Handle the HideColumn event 
                           }
                           </text>)
                        )
            )

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"))
            )

HideRow(System.Func)

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

For more information see HideRow event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.HideRow(@<text>
                           function(e) {
                           // Handle the HideRow event 
                           }
                           </text>)
                        )
            )

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"))
            )

DeleteColumn(System.Func)

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

For more information see DeleteColumn event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.DeleteColumn(@<text>
                           function(e) {
                           // Handle the DeleteColumn event 
                           }
                           </text>)
                        )
            )

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"))
            )

DeleteRow(System.Func)

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

For more information see DeleteRow event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.DeleteRow(@<text>
                           function(e) {
                           // Handle the DeleteRow event 
                           }
                           </text>)
                        )
            )

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"))
            )

InsertColumn(System.Func)

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

For more information see InsertColumn event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.InsertColumn(@<text>
                           function(e) {
                           // Handle the InsertColumn event 
                           }
                           </text>)
                        )
            )

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"))
            )

InsertRow(System.Func)

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

For more information see InsertRow event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.InsertRow(@<text>
                           function(e) {
                           // Handle the InsertRow event 
                           }
                           </text>)
                        )
            )

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"))
            )

Select(System.Func)

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

For more information see Select event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Select(@<text>
                           function(e) {
                           // Handle the Select event 
                           }
                           </text>)
                        )
            )

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"))
            )

ChangeFormat(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.ChangeFormat(@<text>
                           function(e) {
                           // Handle the ChangeFormat event 
                           }
                           </text>)
                        )
            )

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"))
            )

Changing(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Changing(@<text>
                           function(e) {
                           // Handle the Changing event 
                           }
                           </text>)
                        )
            )

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"))
            )

Change(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Change(@<text>
                           function(e) {
                           // Handle the Change event 
                           }
                           </text>)
                        )
            )

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"))
            )

Render(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Render(@<text>
                           function(e) {
                           // Handle the Render event 
                           }
                           </text>)
                        )
            )

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"))
            )

ExcelExport(System.Func)

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

For more information see ExcelExport event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.ExcelExport(@<text>
                           function(e) {
                           // Handle the ExcelExport event 
                           }
                           </text>)
                        )
            )

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"))
            )

ExcelImport(System.Func)

Fired when the user clicks the Open toolbar button.

For more information see ExcelImport event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.ExcelImport(@<text>
                           function(e) {
                           // Handle the ExcelImport event 
                           }
                           </text>)
                        )
            )

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"))
            )

PdfExport(System.Func)

Fired when the user initiates the export to PDF.

For more information see PdfExport event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.PdfExport(@<text>
                           function(e) {
                           // Handle the PdfExport event 
                           }
                           </text>)
                        )
            )

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"))
            )

Copy(System.Func)

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

For more information see Copy event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Copy(@<text>
                           function(e) {
                           // Handle the Copy event 
                           }
                           </text>)
                        )
            )

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"))
            )

Cut(System.Func)

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

For more information see Cut event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Cut(@<text>
                           function(e) {
                           // Handle the Cut event 
                           }
                           </text>)
                        )
            )

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"))
            )

Paste(System.Func)

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

For more information see Paste event.

Parameters

handler - System.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.Paste(@<text>
                           function(e) {
                           // Handle the Paste event 
                           }
                           </text>)
                        )
            )

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"))
            )

DataBinding(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.DataBinding(@<text>
                           function(e) {
                           // Handle the DataBinding event 
                           }
                           </text>)
                        )
            )

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"))
            )

DataBound(System.Func)

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.Func<Object,Object>

The handler code wrapped in a text tag.

Example

             @( Html.Kendo().Spreadsheet()
                       .Name("spreadsheet")
                       .Events(events => events.DataBound(@<text>
                           function(e) {
                           // Handle the DataBound event 
                           }
                           </text>)
                        )
            )