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


In This Topic
    ResetCanFocus Method (Cell)
    In This Topic
    Resets to its default value whether the cell can receive focus.
    Syntax
    'Declaration
     
    Public Sub ResetCanFocus() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetCanFocus()
    public void ResetCanFocus()
    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