Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Sub Insert( _ ByVal index As Integer, _ ByVal value As GroupInfo _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As GroupInfoCollection Dim index As Integer Dim value As GroupInfo instance.Insert(index, value) | |
Parameters
- index
- Zero-based index at which to insert the GroupInfo object
- value
- GroupInfo object to insert into the collection
Exceptions
| Exception | Description |
|---|---|
| System.IndexOutOfRangeException | Specified index is out of range; must be between 0 and the total number in the collection |
| System.ArgumentNullException | No style specified or specified style is null; must specify a style |
Example
This example inserts a group item into the collection at the specified location.
| C# | Copy Code |
|---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = true; FpSpread1.ActiveSheetView.GroupBarVisible = true; FpSpread1.ActiveSheetView.AllowGroup = true; FarPoint.Web.Spread.GroupInfo gi = new FarPoint.Web.Spread.GroupInfo(); gi.BackColor = Color.Yellow; FarPoint.Web.Spread.GroupInfo gi2 = new FarPoint.Web.Spread.GroupInfo(); gi2.BackColor = Color.Green; FarPoint.Web.Spread.GroupInfo gi3 = new FarPoint.Web.Spread.GroupInfo(); gi3.BackColor = Color.Orange; FarPoint.Web.Spread.GroupInfoCollection gic = new FarPoint.Web.Spread.GroupInfoCollection(); gic.AddRange(new FarPoint.Web.Spread.GroupInfo[] { gi, gi2 }); gic.Insert(0, gi3); FpSpread1.ActiveSheetView.GroupInfos.Add(gic[0]); | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheetView.AllowColumnMove = True FpSpread1.ActiveSheetView.GroupBarVisible = True FpSpread1.ActiveSheetView.AllowGroup = True Dim gi As New FarPoint.Web.Spread.GroupInfo gi.BackColor = Color.Yellow Dim gi2 As New FarPoint.Web.Spread.GroupInfo gi2.BackColor = Color.Green Dim gi3 As New FarPoint.Web.Spread.GroupInfo gi3.BackColor = Color.Orange Dim gic As New FarPoint.Web.Spread.GroupInfoCollection() gic.AddRange(New FarPoint.Web.Spread.GroupInfo() {gi, gi2}) gic.Insert(0, gi3) FpSpread1.ActiveSheetView.GroupInfos.Add(gic(0)) | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6