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
Example


In This Topic
    ShowPrecedents Method
    In This Topic
    Shows the cells that are referred to by formulas in other cells.
    Syntax
    'Declaration
     
    Public Sub ShowPrecedents( _
       ByVal sheetIndex As Integer, _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) 
    'Usage
     
    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
    )

    Parameters

    sheetIndex
    Index of the sheet
    row
    Index of the row
    column
    Index of the column
    Remarks

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

    Example
    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);
            Controls.Add(editor);
            editor.Attach(fpSpread1);           
              
            }
    
    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)
            Controls.Add(editor)
            editor.Attach(FpSpread1)
    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