Spread for ASP.NET 11 Product Documentation
Inset Constructor()
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Inset Class > Inset Constructor : Inset Constructor()
Creates an empty set of margins (Inset object).
Syntax
'Declaration
 
Public Function New()
'Usage
 
Dim instance As New Inset()
public Inset()
Remarks
This method initializes an instance of the Inset class.
Example
This example creates a new instance of an inset.
FarPoint.Web.Spread.Inset inset = new FarPoint.Web.Spread.Inset();
inset.Left = 35;
inset.Top = 5;
inset.Right = 5;
inset.Bottom = 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()
inset.Left = 35
inset.Top = 5
inset.Right = 5
inset.Bottom = 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
See Also

Reference

Inset Class
Inset Members
Overload List