FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : AllowInsert Property |
'Declaration Public Property AllowInsert As Boolean
'Usage Dim instance As SheetView Dim value As Boolean instance.AllowInsert = value value = instance.AllowInsert
public bool AllowInsert {get; set;}
Set this property to true to let users insert a row in the sheet. When you set this property to true, the sheet displays the Insert command button and an Add Row button on the command bar. When clicked, the Insert button inserts a new row depending on where focus is; when clicked, the Add button adds a new row to the end of the sheet. When inserting a row, the sheet adds the row above the row containing the active cell.
This property only has an effect if the OperationMode property is set to a value other than ReadOnly or SingleSelect.
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;
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
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional