Kendo.Mvc.UI.Fluent.SpreadsheetBuilder

Defines the fluent API for configuring the Kendo UI Spreadsheet

Methods

ActiveSheet(System.String)

The name of the currently active sheet.Must match one of the (sheet names)[#configuration-sheets.name] exactly.

Parameters

value System.String

The value for ActiveSheet

ColumnWidth(System.Double)

The default column width in pixels.

Parameters

value System.Double

The value for ColumnWidth

Columns(System.Double)

The number of columns in the document.

Parameters

value System.Double

The value for Columns

DefaultCellStyle(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetDefaultCellStyleSettingsBuilder>)

The default cell styles to be applyied to sheet cells.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetDefaultCellStyleSettingsBuilder>

The configurator for the defaultcellstyle setting.

HeaderHeight(System.Double)

The height of the header row in pixels.

Parameters

value System.Double

The value for HeaderHeight

HeaderWidth(System.Double)

The width of the header column in pixels.

Parameters

value System.Double

The value for HeaderWidth

Excel(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetExcelSettingsBuilder>)

Configures the Kendo UI Spreadsheet Excel export settings.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetExcelSettingsBuilder>

The configurator for the excel setting.

Pdf(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetPdfSettingsBuilder>)

Configures the Kendo UI Spreadsheet PDF export settings.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetPdfSettingsBuilder>

The configurator for the pdf setting.

RowHeight(System.Double)

The default row height in pixels.

Parameters

value System.Double

The value for RowHeight

Rows(System.Double)

The number of rows in the document.

Parameters

value System.Double

The value for Rows

Sheets(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFactory>)

An array defining the document sheets and their content.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFactory>

The configurator for the sheets setting.

Sheetsbar(System.Boolean)

A boolean value indicating if the sheetsbar should be displayed.

Parameters

value System.Boolean

The value for Sheetsbar

Toolbar(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetToolbarSettingsBuilder>)

A boolean value indicating if the toolbar should be displayed.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetToolbarSettingsBuilder>

The configurator for the toolbar setting.

Toolbar(System.Boolean)

A boolean value indicating if the toolbar should be displayed.

Parameters

enabled System.Boolean

Enables or disables the toolbar option.

UseCultureDecimals(System.Boolean)

If set to true, the spreadsheet's formula parser will obey the current culture's decimal separator. When false (the default) the decimal separator in formulas will always be the dot.This flag has implications on how formulas are entered. When set to true, in cultures where the decimal separator is the comma (,) there are the following additional changes when entering a formula, similar to how Excel operates: The semicolon becomes function argument separator. Example: =SUM(A1;A2) instead of =SUM(A1,A2). or The backslash becomes element separator in an array formula. Example: ={1\2;3\4} instead of ={1,2;3,4}.. This flag only affects presentation, that is, the way formulas are entered by the end user, or displayed on screen. Serialization to JSON or XLSX, as well as the public API functions, will continue to use the dot as decimal separator and the comma as argument separator (canonical form). For example, in order to apply a formula using the API, even if useCultureDecimals is in effect, you still need to use the canonical form:If you would like the API functions to obey useCultureDecimals, wrap your code in a call to sheet.withCultureDecimals. Assuming a culture where the comma is used for decimals, contrast the above example to:

Parameters

value System.Boolean

The value for UseCultureDecimals

UseCultureDecimals

If set to true, the spreadsheet's formula parser will obey the current culture's decimal separator. When false (the default) the decimal separator in formulas will always be the dot.This flag has implications on how formulas are entered. When set to true, in cultures where the decimal separator is the comma (,) there are the following additional changes when entering a formula, similar to how Excel operates: The semicolon becomes function argument separator. Example: =SUM(A1;A2) instead of =SUM(A1,A2). or The backslash becomes element separator in an array formula. Example: ={1\2;3\4} instead of ={1,2;3,4}.. This flag only affects presentation, that is, the way formulas are entered by the end user, or displayed on screen. Serialization to JSON or XLSX, as well as the public API functions, will continue to use the dot as decimal separator and the comma as argument separator (canonical form). For example, in order to apply a formula using the API, even if useCultureDecimals is in effect, you still need to use the canonical form:If you would like the API functions to obey useCultureDecimals, wrap your code in a call to sheet.withCultureDecimals. Assuming a culture where the comma is used for decimals, contrast the above example to:

Events(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetEventBuilder>)

Configures the client-side events.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetEventBuilder>

The client events action.

Example (ASPX)

@(Html.Kendo().Spreadsheet()
    .Name("Spreadsheet")
    .Events(events => events
        .InsertSheet("onInsertSheet")
    )
)
In this article
Not finding the help you need?