FormControlCollection.AddSpinner(CellRange) Method

Adds a spinner form control at a specified cell range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

SpinnerFormControl AddSpinner(
    CellRange targetRange
)

VB.NET

Function AddSpinner(
    targetRange As CellRange
) As SpinnerFormControl

Parameters

Name	Type	Description
targetRange	CellRange	A cell range where the form control should be located.

Returns

Type	Description
SpinnerFormControl	The spinner form control.

Remarks

Example

The code sample below creates a spinner form control:

C#

Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");

var formControls = workbook.Worksheets[0].FormControls;

var cellRange = workbook.Worksheets[0].Cells["B2:B8"];
var spinner = formControls.AddSpinner(cellRange);
spinner.SmallChange = 5;
spinner.Min = 1;
spinner.Max = 100;

VB.NET

Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")

Dim formControls = workbook.Worksheets(0).FormControls

Dim cellRange = workbook.Worksheets(0).Range("B2:B8")
Dim spinner = formControls.AddSpinner(cellRange)
spinner.SmallChange = 5
spinner.Min = 1
spinner.Max = 100

Note

The FormControlCollection.AddSpinner method call adds a new item to both FormControlCollection and ShapeCollection.