Table of Contents

ExcelFile.AddCheckbox Method

Overloads

ExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress)

Adds a checkbox to the active sheet.

Remarks

Excel supports 2 types of checkboxes: ActiveX and internal (In Excel you would add them from the "ActiveX" and "Forms" toolbars respectively) The checkboxes added by this method are of type internal. ActiveX checkboxes are not supported.

Syntax

Namespace: FlexCel.Core

public Int32 AddCheckbox(TClientAnchor anchor, TRichString text, TCheckboxState value, TCellAddress linkedCell)

Parameters

<-> Parameter Type Description
anchor TClientAnchor Position for the checkbox.
text TRichString Text for the checkbox.
value TCheckboxState Value of the checkbox.
linkedCell TCellAddress Cell that will be linked to the checkbox. If you don't want to link the checkbox to a cell, make this parameter null.

Returns

Object Index of the inserted checkbox (1 based).

See also

ExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress, String)

Adds a checkbox to the active sheet.

Remarks

Excel supports 2 types of checkboxes: ActiveX and internal (In Excel you would add them from the "ActiveX" and "Forms" toolbars respectively) The checkboxes added by this method are of type internal. ActiveX checkboxes are not supported.

Syntax

Namespace: FlexCel.Core

public abstract Int32 AddCheckbox(TClientAnchor anchor, TRichString text, TCheckboxState value, TCellAddress linkedCell, String name)

Parameters

<-> Parameter Type Description
anchor TClientAnchor Position for the checkbox.
text TRichString Text for the checkbox.
value TCheckboxState Value of the checkbox.
linkedCell TCellAddress Cell that will be linked to the checkbox. If you don't want to link the checkbox to a cell, make this parameter null.
name String Name that will be given to the checkbox.

Returns

Object Index of the inserted checkbox (1 based).

See also