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

File(System.Action)

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

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .File(file => file
                                .Validation()
                            )
                        )
            )

View(System.Action)

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

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .View(view => view
                                .Validation()
                            )
                        )
            )

Format(System.Action)

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

Parameters

configurator - System.Action<SpreadsheetToolFactory>

An action that configures the tools.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar
                            .Format(format => format
                                .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

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar.Home(false))
            )

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

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar.Insert(false))
            )

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

Example

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

File(System.Boolean)

A Boolean value which indicates if the File tab or a collection of tools that will be shown in the File tab will be displayed.

Parameters

value - System.Boolean

The value for File

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar.File(false))
            )

View(System.Boolean)

A Boolean value which indicates if the View tab or a collection of tools that will be shown in the View tab will be displayed.

Parameters

value - System.Boolean

The value for View

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar.View(false))
            )

Format(System.Boolean)

A Boolean value which indicates if the Format tab or a collection of tools that will be shown in the Format tab will be displayed.

Parameters

value - System.Boolean

The value for Format

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Toolbar(toolbar => toolbar.Format(false))
            )