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
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 Basic | Copy 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
