Table of Contents

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

Namespace: FlexCel.XlsAdapter

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

Parameters

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

Returns

Object Index of the inserted spinner (1 based).

See also