Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetBehaviorOptions.FillHandle Property

Provides access to an option which turns the Fill Handle feature on or off.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public SpreadsheetFillHandleBehaviorOptions FillHandle { get; }

#Property Value

Type Description
SpreadsheetFillHandleBehaviorOptions

A SpreadsheetFillHandleBehaviorOptions object that specifies whether or not the Fill Handle option is enabled.

#Property Paths

You can access this nested property as listed below:

Object Type Path to FillHandle
SpreadsheetControlOptions
.Behavior .FillHandle

#Remarks

Use the FillHandle property to show or hide the fill handle. The fill handle represents a small square in the lower-right corner of the selection. An end-user can use the fill handle to copy data or automatically fill adjacent cells with a data series.

SpreadsheetControl_FillHandle

The FillHandle property is accessible via the SpreadsheetControlOptions.Behavior property.

Note

The FillHandle property has no effect if the SpreadsheetBehaviorOptions.Drag property is set to the DocumentCapability.Disabled value. The fill handle is disabled in this situation.

See Also