FormControlCollection.AddScrollbar(Cell, Single, Single) Method
In This Article
Creates a scrollbar form control so that the top left corner of the scrollbar is located at the specified cell.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
ScrollbarFormControl AddScrollbar(
Cell topLeftCell,
float width,
float height
)
#Parameters
Name | Type | Description |
---|---|---|
top |
Cell | A cell where the top left corner of the form control is located. |
width | Single | The form control width. |
height | Single | The form control height. |
#Returns
Type | Description |
---|---|
Scrollbar |
The scrollbar form control. |
#Remarks
#Example
The code sample below creates a scrollbar form control:
Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");
var formControls = workbook.Worksheets[0].FormControls;
var topLeftCell = workbook.Worksheets[0].Cells["B2"];
var scrollbarFormControl = formControls.AddScrollbar(topLeftCell, 600, (float)topLeftCell.RowHeight);
scrollbarFormControl.Min = 2;
scrollbarFormControl.Max = 15;
scrollbarFormControl.LargeChange = 10;
scrollbarFormControl.SmallChange = 1;
Note
The Form
method call adds a new item to both Form
See Also