Spread ASP.NET 6.0 Product Documentation
Inset Constructor(Int32,Int32,Int32,Int32)
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Inset Class > Inset Constructor : Inset Constructor(Int32,Int32,Int32,Int32)


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

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Function New( _
   ByVal left As Integer, _
   ByVal top As Integer, _
   ByVal right As Integer, _
   ByVal bottom As Integer _
)
Visual Basic (Usage)Copy Code
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)
C# 
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#Copy Code
FarPoint.Web.Spread.Insetinset=NewFarPoint.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 BasicCopy Code
DiminsetAsNewFarPoint.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

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.