ExcelFile.AddCheckbox Method
Overloads
- ExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress)
- ExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress, String)
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).