New to Telerik UI for ASP.NET Core? Download free 30-day trial

SpreadsheetToolbarSettingsBuilder

Methods

Home(System.Action)

Configure the available tools in the Home tab.

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .Home(home => home
                                .Bold()
                                .Italic()
                                .Open()
                            )
                        )
            )

Insert(System.Action)

A collection of tools that will be shown in the Insert tab of the Toolbar.

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .Insert(insert => insert
                                .InsertAbove()
                                .RemoveRow()
                            )
                        )
            )

Data(System.Action)

A collection of tools that will be shown in the Data tab of the Toolbar.

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .Data(data => data
                                .Validation()
                            )
                        )
            )

Home(System.Boolean)

A Boolean value which indicates if the Home tab or a collection of tools that will be shown in the Home tab will be displayed.The following list indicates the available tools. The tools which are part of a tool group are defined as an array. For example ["bold", "italic", "underline"]. open; exportAs; [cut, copy, paste]; [bold, italic, underline]; backgroundColor, textColor; borders; fontSize, fontFamily; alignment; textWrap; [formatDecreaseDecimal, formatIncreaseDecimal]; format; merge; freeze or filter.

Parameters

value - System.Boolean

The value for Home

Insert(System.Boolean)

A Boolean value which indicates if the Insert tab or a collection of tools that will be shown in the Insert tab will be displayed.The following list indicates the available tools. The tools which are part of a tool group are defined as an array. For example ["deleteColumn", "deleteRow"]. [ addColumnLeft, addColumnRight, addRowBelow, addRowAbove ] or [ deleteColumn, deleteRow ].

Parameters

value - System.Boolean

The value for Insert

Data(System.Boolean)

A Boolean value which indicates if the Data tab or a collection of tools that will be shown in the Data tab will be displayed.The available tools are: sort; filter or validation.

Parameters

value - System.Boolean

The value for Data

In this article
Not finding the help you need?