Table of Contents

XlsFile.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

Namespace: FlexCel.XlsAdapter

public override Int32 AddScrollBar(TClientAnchor anchor, String name, TCellAddress linkedCell, TSpinProperties spinProps)

Parameters

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

Returns

Object Index of the inserted ScrollBar (1 based).

See also