GrapeCity.Documents.Excel.FormulaJsonError.Formula

Formula Property

Formula

Gets the formula text associated with this JSON import error.

This value is the formula string that could not be processed when the workbook data was loaded from JSON.

Declaration

public string Formula { get; }

Public ReadOnly Property Formula As String

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];
string formula = error.Formula;