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


In This Topic
    ResetValue Method (Cell)
    In This Topic
    Resets the value for the cell to empty.
    Syntax
    'Declaration
     
    Public Sub ResetValue() 
    'Usage
     
    Dim instance As Cell
     
    instance.ResetValue()
    public void ResetValue()
    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