SpreadsheetSheetRowCellBuilder
Methods
Background(System.String)
The background color of the cell. Many standard CSS formats are supported. However, the canonical form is #ccff00.
Parameters
value - System.String
The value that configures the background.
Color(System.String)
The font color of the cell. Many standard CSS formats are supported. However, the canonical form is #ccff00.
Parameters
value - System.String
The value that configures the color.
Comment(System.String)
The comment of the cell - a tooltip that appears when the cell is hovered.
Parameters
value - System.String
The value that configures the comment.
FontFamily(System.String)
The font family of the cell.
Parameters
value - System.String
The value that configures the fontfamily.
FontSize(System.Double)
The font size of the cell in pixels.
Parameters
value - System.Double
The value that configures the fontsize.
Italic(System.Boolean)
If set to true, sets the cell font to italic.
Parameters
value - System.Boolean
The value that configures the italic.
Bold(System.Boolean)
If set to true, sets the cell font to bold.
Parameters
value - System.Boolean
The value that configures the bold.
Enable(System.Boolean)
If set to false, disables the cell.
Parameters
value - System.Boolean
The value that configures the enable.
Format(System.String)
The format of the cell text. For more information, refer to the article on creating or deleting a custom number format on MS Office.
Parameters
value - System.String
The value that configures the format.
Formula(System.String)
The cell formula without the leading equals sign, for example, A1 * 10.
Parameters
value - System.String
The value that configures the formula.
Html(System.Boolean)
If set to true, renders the cell value as HTML. It is important to sanitize the value of the cell on the server for passing safe html because there is no client-side sanitizing. When editing a cell the new value can be checked and prevented in the client changing event.
Parameters
value - System.Boolean
The value that configures the html.
Index(System.Int32)
The zero-based index of the cell. Required to ensure correct positioning.
Parameters
value - System.Int32
The value that configures the index.
Link(System.String)
The hyperlink (URL) of the cell.
Parameters
value - System.String
The value that configures the link.
Underline(System.Boolean)
If set to true, sets the cell font to underline.
Parameters
value - System.Boolean
The value that configures the underline.
Validation(System.Action)
The validation rule that is applied to the cell.
Parameters
configurator - System.Action<SpreadsheetSheetRowCellValidationSettingsBuilder>
The action that configures the validation.
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Food Order")
.Rows(rows =>
{
rows.Add()
.Cells(cells =>
{
cells.Add()
.Value("John Doe")
.Validation(validation => validation
.DataType("custom")
.From("AND(LEN(A3)>3, LEN(A3)<200)")
.AllowNulls(true)
.Type("reject")
.TitleTemplate("Full Name validation error")
.MessageTemplate("The full name should be longer than 3 letters and shorter than 200."));
});
});
})
)
Wrap(System.Boolean)
If set to true, wraps the cell content.
Parameters
value - System.Boolean
The value that configures the wrap.
TextAlign(Kendo.Mvc.UI.SpreadsheetTextAlign)
Specifies the text alignment in the cell
Parameters
value - SpreadsheetTextAlign
The value that configures the textalign.
VerticalAlign(Kendo.Mvc.UI.SpreadsheetVerticalAlign)
Specifies the text vertical alignment in the cell
Parameters
value - SpreadsheetVerticalAlign
The value that configures the verticalalign.
Value(System.Object)
Configures the value for the cell
Parameters
value - System.Object
The cell value.
BorderBottom(System.Action)
Configure bottom border.
Parameters
action - System.Action<SpreadsheetBorderStyleBuilder>
The value that configures the border.
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Food Order")
.Rows(rows =>
{
rows.Add()
.Cells(cells =>
{
cells.Add()
.Value("John Doe")
.BorderBottom(borderBottom => borderBottom.Color("green"));
});
});
})
)
BorderTop(System.Action)
Configure top border.
Parameters
action - System.Action<SpreadsheetBorderStyleBuilder>
The value that configures the border.
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Food Order")
.Rows(rows =>
{
rows.Add()
.Cells(cells =>
{
cells.Add()
.Value("John Doe")
.BorderTop(borderTop => borderTop.Color("green"));
});
});
})
)
BorderLeft(System.Action)
Configure left border.
Parameters
action - System.Action<SpreadsheetBorderStyleBuilder>
The value that configures the border.
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Food Order")
.Rows(rows =>
{
rows.Add()
.Cells(cells =>
{
cells.Add()
.Value("John Doe")
.BorderLeft(borderLeft => borderLeft.Color("green"));
});
});
})
)
BorderRight(System.Action)
Configure right border.
Parameters
action - System.Action<SpreadsheetBorderStyleBuilder>
The value that configures the border.
Example
@( Html.Kendo().Spreadsheet()
.Name("spreadsheet")
.Sheets(sheets =>
{
sheets.Add()
.Name("Food Order")
.Rows(rows =>
{
rows.Add()
.Cells(cells =>
{
cells.Add()
.Value("John Doe")
.BorderRight(borderRight => borderRight.Color("green"));
});
});
})
)