Inset Constructor(Int32,Int32,Int32,Int32)

In This Topic

Creates a set of margins (Inset object) with the specified values.

Syntax

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)

Remarks

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

Example

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#
Visual Basic

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;

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

Reference

Inset Class
Inset Members
Overload List