TXlsFile.AddSpinner Method

Adds a Spinner to the active sheet.

Remarks

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

Syntax

Unit: FlexCel.XlsAdapter

function TXlsFile.AddSpinner(const anchor: TClientAnchor; const name: string; const linkedCell: TCellAddress; const spinProps: TSpinProperties): Integer; override;

Parameters

<->	Parameter	Type	Description
const	anchor	TClientAnchor	Position for the spinner.
const	name	string	Name of the inserted spinner.
const	linkedCell	TCellAddress	Cell that will be linked to the spinner. Set this to null to not link any cell.
const	spinProps	TSpinProperties	Properties for the spinner.

Returns

Object Index of the inserted spinner (1 based).

See also

• TXlsFile