Skip to main content
All docs
V24.1
Row

FormControlCollection.AddScrollbar(CellRange) Method

Adds a scrollbar form control at a specified cell range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

ScrollbarFormControl AddScrollbar(
    CellRange targetRange
)

Parameters

Name Type Description
targetRange CellRange

A cell range where the form control should be located.

Returns

Type Description
ScrollbarFormControl

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 cellRange = workbook.Worksheets[0].Range["B2:B8"];
var scrollbarFormControl = formControls.AddScrollbar(cellRange);
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