AddUnboundRows Method (SheetView)

Visual Basic
C#

'Declaration
 
Public Sub AddUnboundRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim count As Integer
 
instance.AddUnboundRows(row, count)

public void AddUnboundRows( 
   int row,
   int count
)

Parameters

row: Row index at which to start adding rows
count: Number of rows to add

This creates a row of blank cells that is not bound to the data set and does not affect the data set. An unbound row does not inherently appear or behave differently from bound rows.

The unbound row is added to the models using the IUnboundRowSupport interface.

If you subsequently need to add an unbound row to the bound data set, use AddRowToDataSource method.

For more information, refer to Adding an Unbound Row.

This example adds a row to the data source.

C#

private void FpSpread1ChildViewCreated(object sender, FarPoint.Web.Spread.CreateChildViewEventArgs e)
{
      FarPoint.Web.Spread.SheetView sv;
      sv = e.SheetView;
      sv.AddUnboundRows(0, 1);
      sv.Cells[0, 0].Value = "Dallas";
      sv.Cells[0, 1].Value = "0";
      sv.Cells[0, 2].Value = "Texas";
      sv.AddRowToDataSource(0, true);
}

Visual Basic

Private Sub FpSpread1ChildViewCreated(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.CreateChildViewEventArgs) Handles
FpSpread1.ChildViewCreated
      Dim sv As FarPoint.Web.Spread.SheetView
      sv = e.SheetView
      sv.AddUnboundRows(0, 1)
      sv.Cells(0, 0).Value = "Dallas"
      sv.Cells(0, 1).Value = "0"
      sv.Cells(0, 2).Value = "Texas"
      sv.AddRowToDataSource(0, True)
End Sub

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

Reference

SheetView Class
SheetView Members
AddRowToDataSource Method
IUnboundRowSupport Interface

User-Task Documentation

Adding an Unbound Row