Spread Windows Forms 7.0 Product Documentation
AllowDragFill Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : AllowDragFill Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property AllowDragFill As Boolean
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As Boolean
 
instance.AllowDragFill = value
 
value = instance.AllowDragFill
C# 
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 specifies whether to allow the user to drag-and-fill to a cell or range of cells.
C#Copy Code
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
DialogResult dlg;
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.SetValue(0, 0, "Drag");
fpSpread1.ActiveSheet.SetValue(1, 0, "And");
fpSpread1.ActiveSheet.SetValue(2, 0, "Fill");
dlg = MessageBox.Show("If you want to Drag/Fill click the YES button, place the pointer on the bottom-right edge of the selection,
and then drag and fill.", "DragFill", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
     fpSpread1.ActiveSheet.AddSelection(0, 0, 3, 1);
     fpSpread1.AllowDragFill = true;
}
Visual BasicCopy Code
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
Dim dlg As DialogResult
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.SetValue(0, 0, "Drag")
fpSpread1.ActiveSheet.SetValue(1, 0, "And")
fpSpread1.ActiveSheet.SetValue(2, 0, "Fill")
dlg = MessageBox.Show("If you want to Drag/Fill click the YES button, place the pointer on the bottom-right edge of the selection,
and then drag and fill.", "DragFill", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
     fpSpread1.ActiveSheet.AddSelection(0, 0, 3, 1)
     fpSpread1.AllowDragFill = True
End If

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.