GrapeCity.Documents.Excel.FormulaJsonError.Column

Column Property

Column

Gets the column index where the formula error occurred.

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

Declaration

public int Column { get; }

Public ReadOnly Property Column 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 column = error.Column;