GrapeCity.Documents.Excel.FormulaJsonError

FormulaJsonError Class

Represents a formula-related error in imported JSON content.

This class extends JsonError and stores the worksheet name, row index, column index, and formula text associated with a formula that could not be processed. It is typically used to describe formula errors reported while loading workbook data from JSON.

Inheritance

object

JsonError

FormulaJsonError

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public sealed class FormulaJsonError : JsonError

Public NotInheritable Class FormulaJsonError
    Inherits JsonError

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

Properties

Name	Description
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.
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.
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.
WorksheetName	Gets the name of the worksheet where the formula error occurred. This value identifies the worksheet associated with the invalid or unprocessed formula in the imported JSON content.