Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Inset Class / Inset Constructor / Inset Constructor()
Example


In This Topic
    Inset Constructor()
    In This Topic
    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