GrapeCity.Documents.Excel.CheckBoxCellType

CheckBoxCellType Class

Represents a checkbox cell type.

A checkbox cell type displays a checkbox control in a cell. It supports configurable caption text, text labels for true/false/indeterminate states, text alignment relative to the checkbox, and optional three-state mode. Assign it to a cell or range via CellType. Cell types are preserved in SpreadJS JSON I/O but are not supported in Excel file formats (.xlsx).

Inheritance

object

BaseCellType

CheckBoxCellType

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class CheckBoxCellType : BaseCellType

Public Class CheckBoxCellType
    Inherits BaseCellType

Examples

CheckBoxCellType cellType = new CheckBoxCellType();
cellType.Caption = "Caption";
cellType.TextTrue = "True";
cellType.TextFalse = "False";
cellType.IsThreeState = true;
cellType.TextAlign = CheckBoxAlign.Right;
worksheet.Range["A1:A2"].CellType = cellType;
worksheet.Range["A1"].Value = true;
worksheet.Range["A2"].Value = false;

Constructors

Name	Description
CheckBoxCellType()	Initializes a new instance of the CheckBoxCellType class.

Properties

Name	Description
AutoBoxSize	Gets or sets whether the box size changes with the font size.
BoxSize	Gets or sets a value that indicates the check box size.
Caption	Gets or sets the caption of the cell type.
IsThreeState	Gets or sets a value that indicates whether the check box supports three states.
TextAlign	Gets or sets the text alignment relative to the check box.
TextFalse	Gets or sets the text in the cell when the cell's value is false.
TextIndeterminate	Gets or sets the text in the cell when the cell's value is indeterminate (neither true nor false).
TextTrue	Gets or sets the text in the cell when the cell's value is true.