SpinButton Class

Namespace:

GemBox.Spreadsheet.Drawing

Assembly:

GemBox.Spreadsheet.dll

Represents a Spin Button Form Control.

• C#
• VB.NET

public class SpinButton : ExcelFormControl

Public Class SpinButton
    Inherits ExcelFormControl

Inheritance:

System.Object

ExcelDrawing

ExcelFormControl

SpinButton

Properties

CellLink

Gets or sets the cell which holds the value of this spin button.

• C#
• VB.NET

public ExcelCell CellLink { get; set; }

Public Property CellLink As ExcelCell

Property Value

ExcelCell

The cell which holds the value of this spin button.

CurrentValue

Gets or sets the value of the spin button.

• C#
• VB.NET

public int CurrentValue { get; set; }

Public Property CurrentValue As Integer

Property Value

System.Int32

The value of the spin button.

FormControlType

Gets the SpinButton value.

• C#
• VB.NET

public override FormControlType FormControlType { get; }

Public Overrides ReadOnly Property FormControlType As FormControlType

Property Value

FormControlType

The SpinButton value.

Overrides

ExcelFormControl.FormControlType

IncrementalChange

Gets or sets the increment which is added or subtracted when clicking on this spin button.

• C#
• VB.NET

public int IncrementalChange { get; set; }

Public Property IncrementalChange As Integer

Property Value

System.Int32

The increment which is added or subtracted when clicking on this spin button.

MaximumValue

Gets or sets the maximum value that can be produced by this spin button.

• C#
• VB.NET

public int MaximumValue { get; set; }

Public Property MaximumValue As Integer

Property Value

System.Int32

The maximum value that can be produced by this spin button.

MinimumValue

Gets or sets the minimum value that can be produced by this spin button.

• C#
• VB.NET

public int MinimumValue { get; set; }

Public Property MinimumValue As Integer

Property Value

System.Int32

The minimum value that can be produced by this spin button.

Inherited Properties

Hyperlink	Gets or sets the hyperlink on this drawing (picture, chart, etc.). (Inherited from ExcelDrawing)
MacroName	Gets the name of the assigned vba macro to this button. (Inherited from ExcelFormControl)
Metadata	Gets the metadata (non-visual properties) of this ExcelDrawing instance. (Inherited from ExcelDrawing)
Position	Gets the position of this drawing (picture, chart, etc.) in the worksheet. (Inherited from ExcelDrawing)
Print	Gets or sets whether current form control is printable. (Inherited from ExcelFormControl)
ThreeDShading	Gets or sets whether 3D effect should be enabled on the current form control. (Inherited from ExcelFormControl)
Worksheet	Gets the parent worksheet. (Inherited from ExcelDrawing)
ZIndex	Gets the z-order position of the picture. -1 if the picture is not contained in proper collection. (Inherited from ExcelDrawing)

Inherited Methods

BringForward()	Moves the form control one position forward in the drawings. (Inherited from ExcelFormControl)
BringToFront()	Brings the form control to the front of the drawings. (Inherited from ExcelFormControl)
Format()	Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)
Format(System.Double, System.Double, LengthUnit)	Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)
MoveZIndex(System.Int32)	Moves the form control forward or backward in the drawings with the given relative index. (Inherited from ExcelFormControl)
SendBackward()	Moves the form control one position backward in the drawings. (Inherited from ExcelFormControl)
SendToBack()	Sends the form control to the back of the drawings. (Inherited from ExcelFormControl)
SetMacro(VbaModule, System.String)	Assigns the given macro to this button. (Inherited from ExcelFormControl)