Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / ResetMargin Method
Example


In This Topic
    ResetMargin Method (Row)
    In This Topic
    Resets the settings of the cell margins that define the space between the cell border and the cell contents, for all the cells in this row.
    Syntax
    'Declaration
     
    Public Sub ResetMargin() 
    'Usage
     
    Dim instance As Row
     
    instance.ResetMargin()
    public void ResetMargin()
    Example
    This example uses the ResetMargin method.
    FarPoint.Web.Spread.Row myrow;
    FarPoint.Web.Spread.Inset inset = new FarPoint.Web.Spread.Inset(20, 50, 80, 20);
    myrow = FpSpread1.ActiveSheetView.Rows[1];
    myrow.CellType = new FarPoint.Web.Spread.TextCellType();
    myrow.Margin = inset;
    myrow.Height = 70;
    myrow.Locked = true;
    myrow.HorizontalAlign = HorizontalAlign.Center;
    myrow.VerticalAlign = VerticalAlign.Middle;
    FpSpread1.ActiveSheetView.Columns[0].Width = 140;
    FpSpread1.ActiveSheetView.Cells[1, 0].Text = "Test";
    //myrow.ResetCellType();
    //myrow.ResetMargin();
    //myrow.ResetLocked();
    //myrow.ResetHorizontalAlignment();
    //myrow.ResetVerticalAlignment();
    Dim myrow As FarPoint.Web.Spread.Row
    Dim inset As New FarPoint.Web.Spread.Inset(20, 50, 80, 20)
    myrow = FpSpread1.ActiveSheetView.Rows(1)
    myrow.CellType = New FarPoint.Web.Spread.TextCellType()
    myrow.Margin = inset
    myrow.Height = 70
    myrow.Locked = True
    myrow.HorizontalAlign = HorizontalAlign.Center
    myrow.VerticalAlign = VerticalAlign.Middle
    FpSpread1.ActiveSheetView.Columns(0).Width = 140
    FpSpread1.ActiveSheetView.Cells(1, 0).Text = "Test"
    'myrow.ResetCellType()
    'myrow.ResetMargin()
    'myrow.ResetLocked()
    'myrow.ResetHorizontalAlignment()
    'myrow.ResetVerticalAlignment()
    See Also