TXlsFile.AddScrollBar Method

Adds a ScrollBar to the active sheet.

Remarks

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

Syntax

Unit: FlexCel.XlsAdapter

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

Parameters

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

Returns

Object Index of the inserted ScrollBar (1 based).

See also

• TXlsFile