TExcelFile.AddCheckbox Method
Overloads
- TExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress)
- TExcelFile.AddCheckbox(TClientAnchor, TRichString, TCheckboxState, TCellAddress, string)
TExcelFile.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
Unit: FlexCel.Core
function TExcelFile.AddCheckbox(const anchor: TClientAnchor; const text: TRichString; const value: TCheckboxState; const linkedCell: TCellAddress): Integer; overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | anchor | TClientAnchor | Position for the checkbox. |
const | text | TRichString | Text for the checkbox. |
const | value | TCheckboxState | Value of the checkbox. |
const | 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
TExcelFile.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
Unit: FlexCel.Core
function TExcelFile.AddCheckbox(const anchor: TClientAnchor; const text: TRichString; const value: TCheckboxState; const linkedCell: TCellAddress; const name: string): Integer; overload; virtual; abstract;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | anchor | TClientAnchor | Position for the checkbox. |
const | text | TRichString | Text for the checkbox. |
const | value | TCheckboxState | Value of the checkbox. |
const | 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. |
const | name | string | Name that will be given to the checkbox. |
Returns
Object Index of the inserted checkbox (1 based).