AllowDragFill Property (SpreadView)

Gets or sets whether to allow the user to drag and fill cells with the contents of a cell or cells in the view.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AllowDragFill As Boolean

'Usage
 
Dim instance As SpreadView
Dim value As Boolean
 
instance.AllowDragFill = value
 
value = instance.AllowDragFill

public bool AllowDragFill {get; set;}

Property Value

Boolean: true to allow the user to drag and fill data; false otherwise

Remarks

This property determines whether the user can fill a selected range of cells by dragging the cells after copying the contents of one cell. When this property is set to true, the user can fill the contents of a cell or a range of cells using the drag-and-drop operation.

To fill a cell or cells, the user selects the cell or range of cells to copy, moves the pointer over the edge of the destination until the specified pointer appears, and then drags and drops the selection.

Example

This example sets the AllowDragFill property.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.AllowDragFill = true;

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.AllowDragFill = True

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Using Drag Operations to Fill Cells