Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ShowPrecedents Method
Index of the sheet
Index of the row
Index of the column

In This Topic
    ShowPrecedents Method
    In This Topic
    Shows the cells that are referred to by formulas in other cells.
    Public Sub ShowPrecedents( _
       ByVal sheetIndex As Integer, _
       ByVal row As Integer, _
       ByVal column As Integer _
    Dim instance As FpSpread
    Dim sheetIndex As Integer
    Dim row As Integer
    Dim column As Integer
    instance.ShowPrecedents(sheetIndex, row, column)
    public void ShowPrecedents( 
       int sheetIndex,
       int row,
       int column


    Index of the sheet
    Index of the row
    Index of the column

    The method shows which cell (indicated by the row and column parameters) this cell references. This method requires the formula text box control.

    This example shows the cells that this formula cell references.  The formula text box requires a license entry in the licenses.licx file.
     private void Form1_Load(object sender, EventArgs e)
                 fpSpread1.Sheets[0].Cells[0, 0, 5, 5].CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
            fpSpread1.Sheets[0].Cells[0, 0].Formula = "B2+B3";
            fpSpread1.Sheets[0].Cells[0, 3].Formula = "A1";
            fpSpread1.Sheets[0].Cells[0, 4].Formula = "D1";
            FarPoint.Win.Spread.FormulaTextBox editor = new FarPoint.Win.Spread.FormulaTextBox();
            editor.Location = new Point(0, 0);
            editor.Size = new Size(80, 20);
    private void button1_Click(object sender, EventArgs e)
                 fpSpread1.ShowDependents(0, 0, 0);
                 fpSpread1.ShowPrecedents(0, 0, 4);           
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(0, 0, 5, 5).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
            FpSpread1.Sheets(0).Cells(0, 0).Formula = "B2+B3"
            FpSpread1.Sheets(0).Cells(0, 3).Formula = "A1"
            FpSpread1.Sheets(0).Cells(0, 4).Formula = "D1"
            Dim editor As New FarPoint.Win.Spread.FormulaTextBox
            editor.Location = New Point(0, 0)
            editor.Size = New Size(80, 20)
    End Sub
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click        
            FpSpread1.ShowDependents(0, 0, 0)
            FpSpread1.ShowPrecedents(0, 0, 4)
    End Sub
    See Also