Spread for ASP.NET 10 Product Documentation
AllowInsert Property
Example 


Gets or sets whether a user can insert a row in the sheet.
Syntax
'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;}

Property Value

Boolean: true to allow users to insert a row; false otherwise
Remarks

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.

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.
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

SheetView Class
SheetView Members
AllowDelete Property

User-Task Documentation

Customizing the Command Buttons

 

 


Copyright © GrapeCity, inc. All rights reserved.