GrapeCity.Documents.Excel.FormulaJsonError.Row

Row Property

Row

Gets the row index where the formula error occurred.

This value identifies the row associated with the invalid or unprocessed formula in the imported JSON content.

Declaration

public int Row { get; }

Public ReadOnly Property Row As Integer

Examples

Workbook sourceWorkbook = new Workbook();
sourceWorkbook.Worksheets[0].Range["C2"].Formula = "=SUM(A1:A2)";
string json = sourceWorkbook.ToJson().Replace("SUM(A1:A2)", "SUM(A1:)");
Workbook importedWorkbook = new Workbook();
IList<JsonError> errors = importedWorkbook.FromJson(json);
FormulaJsonError error = (FormulaJsonError)errors[0];
int row = error.Row;