FormControlCollection.AddSpinner(Single, Single, Single, Single) Method
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.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
SpinnerFormControl AddSpinner(
float x,
float y,
float width,
float height
)
#Parameters
Name | Type | Description |
---|---|---|
x | Single | The distance from the left of the worksheet. The ISpreadsheet |
y | Single | The distance from the top of the worksheet. The ISpreadsheet |
width | Single | The form control width. |
height | Single | The form control height. |
#Returns
Type | Description |
---|---|
Spinner |
The spinner form control. |
#Remarks
#Example
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;
Note
The Form
method call adds a new item to both Form