Gets or sets whether a user can delete a row in the sheet.

Syntax

Visual Basic (Declaration)
Public Property AllowDelete As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As SheetView Dim value As Boolean instance.AllowDelete = value value = instance.AllowDelete

C#
public bool AllowDelete {get; set;}

Property Value

Boolean: true to allow users to delete a row; false otherwise

Remarks

Set this property to true to let users delete a row in the sheet. When you set this property to true, the sheet also displays the Delete command button in the command bar.

This property only has an effect if the OperationMode property is set to a value other than ReadOnly or SingleSelect.

Example

This example creates a SheetView object and assigns it to the active sheet. The ActiveColumn and ActiveRow properties are set and a value is placed in the active cell. The AllowInsert and AllowDelete properties are set to true so that when the user clicks the Insert button on the command bar a row is inserted, when the user clicks the Add button a row is added at the bottom, and when the user clicks the Delete button the selected row is deleted.

C#	Copy Code
FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView; sv.ActiveColumn = 2; sv.ActiveRow = 2; sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active"); sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal; sv.AllowInsert = True; sv.AllowDelete = True;

Copy Code

    FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
    sv.ActiveColumn = 2;
    sv.ActiveRow = 2;
    sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active");
    sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal;
    sv.AllowInsert = True;
    sv.AllowDelete = True;

Visual Basic	Copy Code
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.ActiveColumn = 2 sv.ActiveRow = 2 sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active") sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal sv.AllowInsert = True sv.AllowDelete = True

Visual Basic

Copy Code

    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    sv.ActiveColumn = 2
    sv.ActiveRow = 2
    sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active")
    sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal
    sv.AllowInsert = True
    sv.AllowDelete = True

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread ASP.NET 6.0 Product Documentation
AllowDelete Property
See Also Example Send Feedback