Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / ResetFont Method
Example


In This Topic
    ResetFont Method (Cell)
    In This Topic
    Resets the font for the cell and makes the cell inherit the font from the default cell.
    Syntax
    'Declaration
     
    Public Sub ResetFont() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetFont()
    public void ResetFont()
    Example
    This example shows the use of this method by resetting the cell properties to their default values.
    FarPoint.Win.Spread.Cell cell;
    cell = fpSpread1.ActiveSheet.Cells[0, 0];
    cell.BackColor = Color.LightBlue;
    cell.Border = new FarPoint.Win.LineBorder(Color.DarkBlue);
    cell.CanFocus = false;
    cell.CellType = new FarPoint.Win.Spread.CellType.GeneralCellType();
    cell.Font = new Font("Comic Sans MS", 10);
    cell.ForeColor = Color.Red;
    cell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
    cell.Locked = false;
    cell.NoteIndicatorColor = Color.Green;
    cell.ParentStyleName = "DataAreaDefault";
    cell.TabStop = false;
    cell.Text = "Test";
    cell.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top;
    
    private void button1Click(object sender, System.EventArgs e)
    {
         FarPoint.Win.Spread.Cell cell;
         cell = fpSpread1.ActiveSheet.Cells[0, 0];
         DialogResult dlg = new DialogResult();
         dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel);
         if (dlg == DialogResult.OK)
         {
              cell.ResetBackColor();
              cell.ResetBorder();
              cell.ResetCanFocus()
              cell.ResetCellType();
              cell.ResetFont();
              cell.ResetForeColor();
              cell.ResetHorizontalAlignment();
              cell.ResetLocked();
              cell.ResetNoteIndicatorColor();
              cell.ResetNoteStyle();
              cell.ResetParentStyleName();
              cell.ResetTabStop();
              cell.ResetText();
              cell.ResetValue();
              cell.ResetVerticalAlignment();
             }
    }
    Dim cell As FarPoint.Win.Spread.Cell
    cell = fpSpread1.ActiveSheet.Cells(0, 0)
    cell.BackColor = Color.LightBlue
    cell.Border = New FarPoint.Win.LineBorder(Color.DarkBlue)
    cell.CanFocus = False
    cell.CellType = New FarPoint.Win.Spread.CellType.GeneralCellType
    cell.Font = New Font("Comic Sans MS", 10)
    cell.ForeColor = Color.Red
    cell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
    cell.Locked = False
    cell.NoteIndicatorColor = Color.Green
    cell.ParentStyleName = "DataAreaDefault"
    cell.TabStop = False
    cell.Text = "Test"
    cell.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top
    
    Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
         Dim cell As FarPoint.Win.Spread.Cell
         cell = fpSpread1.ActiveSheet.Cells(0, 0)
         Dim dlg As New DialogResult
         dlg = MessageBox.Show("Reset the AlternatingRow??", "Reset", MessageBoxButtons.OKCancel)
         If dlg = DialogResult.OK Then
              cell.ResetBackColor()
              cell.ResetBorder()
              cell.ResetCanFocus()
              cell.ResetCellType()
              cell.ResetFont()
              cell.ResetForeColor()
              cell.ResetHorizontalAlignment()
              cell.ResetLocked()
              cell.ResetNoteIndicatorColor()
              cell.ResetNoteStyle()
              cell.ResetParentStyleName()
              cell.ResetTabStop()
              cell.ResetText()
              cell.ResetValue()
              cell.ResetVerticalAlignment()
         End If
    End Sub
    See Also