Inset Constructor(Int32,Int32,Int32,Int32)

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal left As Integer, _
   ByVal top As Integer, _
   ByVal right As Integer, _
   ByVal bottom As Integer _
)

'Usage
 
Dim left As Integer
Dim top As Integer
Dim right As Integer
Dim bottom As Integer
 
Dim instance As New Inset(left, top, right, bottom)

public Inset( 
   int left,
   int top,
   int right,
   int bottom
)

Parameters

left: Left inset (margin)
top: Top inset (margin)
right: Right inset (margin)
bottom: Bottom inset (margin)

This method initializes an instance of the Inset class with the specified values of insets (margins).

This example creates three alternating rows, adjusts the height of the rows and sets up an Inset, which allows the text in the cell to be indented to the specified margin.

C#

FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(35,5,5,35);
FpSpread1.Sheets[0].AlternatingRows.Count=3;
FpSpread1.Sheets[0].Rows[0].Height=80;
FpSpread1.Sheets[0].Rows[1].Height=80;
FpSpread1.Sheets[0].Rows[2].Height=80;
FpSpread1.Sheets[0].SetValue(0,0,"Test");
FpSpread1.Sheets[0].SetValue(1,0,"For");
FpSpread1.Sheets[0].SetValue(2,0,"Margin");
FpSpread1.Sheets[0].AlternatingRows[0].Margin=inset;
FpSpread1.Sheets[0].AlternatingRows[1].Margin=inset;
FpSpread1.Sheets[0].AlternatingRows[2].Margin=inset;

Visual Basic

Dim inset As New FarPoint.Web.Spread.Inset(35,5,5,35)
FpSpread1.Sheets(0).AlternatingRows.Count=3
FpSpread1.Sheets(0).Rows(0).Height=80
FpSpread1.Sheets(0).Rows(1).Height=80
FpSpread1.Sheets(0).Rows(2).Height=80
FpSpread1.Sheets(0).SetValue(0,0,"Test")
FpSpread1.Sheets(0).SetValue(1,0,"For")
FpSpread1.Sheets(0).SetValue(2,0,"Margin")
FpSpread1.Sheets(0).AlternatingRows(0).Margin=inset
FpSpread1.Sheets(0).AlternatingRows(1).Margin=inset
FpSpread1.Sheets(0).AlternatingRows(2).Margin=inset

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

Reference

Inset Class
Inset Members
Overload List