officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addscrollbar-x28-devexpress-dot-spreadsheet-dot-cell-system-dot-single-system-dot-single-x29.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ScrollbarFormControl AddScrollbar(
Cell topLeftCell,
float width,
float height
)
Function AddScrollbar(
topLeftCell As Cell,
width As Single,
height As Single
) As ScrollbarFormControl
| Name | Type | Description |
|---|---|---|
| topLeftCell | 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.
|
| Type | Description |
|---|---|
| ScrollbarFormControl |
The scrollbar form control.
|
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;
Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")
Dim formControls = workbook.Worksheets(0).FormControls
Dim topLeftCell = workbook.Worksheets(0).Cells("B2")
Dim scrollbarFormControl = formControls.AddScrollbar(topLeftCell, 600, CSng(topLeftCell.RowHeight))
scrollbarFormControl.Min = 2
scrollbarFormControl.Max = 15
scrollbarFormControl.LargeChange = 10
scrollbarFormControl.SmallChange = 1
Note
The FormControlCollection.AddScrollbar method call adds a new item to both FormControlCollection and ShapeCollection.
See Also