GetCellErrorText Method (SheetView)

Visual Basic
C#

'Declaration
 
Public Function GetCellErrorText( _
   ByVal rowIndex As Integer, _
   ByVal columnIndex As Integer _
) As String

'Usage
 
Dim instance As SheetView
Dim rowIndex As Integer
Dim columnIndex As Integer
Dim value As String
 
value = instance.GetCellErrorText(rowIndex, columnIndex)

public string GetCellErrorText( 
   int rowIndex,
   int columnIndex
)

Parameters

rowIndex: Row index of cell
columnIndex: Column index of cell

Return Value

Error text of cell (string.Empty if there is no error text)

This example uses the GetCellErrorText method.

C#

fpSpread1.ShowCellErrors = true;
fpSpread1.Sheets[0].Cells[1, 1].ErrorText = "CellError";
fpSpread1.Sheets[0].Cells[1, 1].Locked = true;

private void button1_Click(object sender, EventArgs e)
        {
            listBox1.Items.Add(fpSpread1.Sheets[0].GetCellErrorText(1, 1).ToString());           
        }

VB.NET

FpSpread1.ShowCellErrors = True
FpSpread1.Sheets(0).Cells(1, 1).ErrorText = "CellError"
FpSpread1.Sheets(0).Cells(1, 1).Locked = True

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        ListBox1.Items.Add(FpSpread1.Sheets(0).GetCellErrorText(1, 1).ToString())
End Sub

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members