GrapeCity.Documents.Excel.Forms.ISpinner

ISpinner Interface

Represents a spinner form control.

A spinner lets users increase or decrease an integer value within a configured range. Use IRangeBase members to define the minimum value, maximum value, and step size, and use LinkedCell to bind the current value to a worksheet cell.

Namespace: GrapeCity.Documents.Excel.Forms

Assembly: DS.Documents.Excel.dll

Syntax

public interface ISpinner : IControl<ISpinner>, IRangeBase, ICellLinkControl<int>, ICellLinkControl, IControl

Public Interface ISpinner
    Inherits IControl(Of ISpinner), IRangeBase, ICellLinkControl(Of Integer), ICellLinkControl, IControl

Examples

ISpinner spinner = worksheet.Controls.AddSpinner(20, 20, 18, 40);
spinner.Min = 0;
spinner.Max = 10;
spinner.SmallChange = 1;
spinner.LinkedCell = worksheet.Range["A1"];
spinner.Value = 5;