officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addspinner-x28-system-dot-single-system-dot-single-system-dot-single-system-dot-single-x29.md
Adds a spinner form control so that the top left corner of the spinner is located at the specified cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
SpinnerFormControl AddSpinner(
float x,
float y,
float width,
float height
)
Function AddSpinner(
x As Single,
y As Single,
width As Single,
height As Single
) As SpinnerFormControl
| Name | Type | Description |
|---|---|---|
| x | Single |
The distance from the left of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.
| | y | Single |
The distance from the top of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.
| | width | Single |
The form control width.
| | height | Single |
The form control height.
|
| Type | Description |
|---|---|
| SpinnerFormControl |
The spinner form control.
|
The code sample below creates a spinner form control:
Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");
var formControls = workbook.Worksheets[0].FormControls;
var spinner = formControls.AddSpinner(20, 20, (float)topLeftCel.ColumnWidth/2, 800);
spinner.SmallChange = 5;
spinner.Min = 1;
spinner.Max = 100;
Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")
Dim formControls = workbook.Worksheets(0).FormControls
Dim spinner = formControls.AddSpinner(20, 20, CSng(topLeftCel.ColumnWidth)/2, 800)
spinner.SmallChange = 5
spinner.Min = 1
spinner.Max = 100
Note
The FormControlCollection.AddSpinner method call adds a new item to both FormControlCollection and ShapeCollection.
See Also