GrapeCity.Documents.Excel.CheckBoxListCellType

CheckBoxListCellType Class

Represents a checkbox list cell type.

A checkbox list cell type allows users to select multiple items from a list of checkboxes within a single cell. You can configure the layout direction, text alignment, spacing, and the number of rows and columns for the list. Use SelectFieldItem to define the items in the list.

Inheritance

object

BaseCellType

CheckBoxListCellType

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class CheckBoxListCellType : BaseCellType

Public Class CheckBoxListCellType
    Inherits BaseCellType

Examples

CheckBoxListCellType cellType = new CheckBoxListCellType();
cellType.Direction = CellTypeDirection.Horizontal;
cellType.TextAlign = CellTypeTextAlign.Right;
cellType.MaxColumnCount = 2;
cellType.Items.Add(new SelectFieldItem("sample1", "1"));
cellType.Items.Add(new SelectFieldItem("sample2", "2"));
cellType.Items.Add(new SelectFieldItem("sample3", "3"));
worksheet.Range["A1"].CellType = cellType;
worksheet.Range["A1"].Value = new object[,]{{new object[]{"1", "3"}}};

Constructors

Name	Description
CheckBoxListCellType()	Initializes a new instance of the CheckBoxListCellType 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.
Direction	Gets or sets the direction of the check-box-list.
HorizontalSpacing	Gets or sets the horizontal spacing in the check-box-list.
IsFlowLayout	Gets or sets whether the check-box-list layout is autofit.
Items	Gets the items for the check-box-list.
MaxColumnCount	Gets or sets the maximum column count for the check-box-list.
MaxRowCount	Gets or sets the maximum row count for the check-box-list.
TextAlign	Gets or sets the text alignment of the check-box-list. Only left and right are supported.
VerticalSpacing	Gets or sets the vertical spacing in the check-box-list.