-
com.grapecity.documents.excel
-
Classes
- AIMessage
- AIModelRequest
- AIModelResponse
- AsyncCustomFunction
- BaseCellType
- ButtonCellType
- CalcReference
- CancellationToken
- CancellationTokenSource
- CellColorSortField
- CellDecoration
- CellDecorationIcon
- CellInfo
- CellPadding
- CellPicture
- CheckBoxCellType
- CheckBoxListCellType
- Color
- ColorUtilities
- ComboBoxCellItem
- ComboBoxCellType
- CornerFold
- CsvOpenOptions
- CsvParseContext
- CsvParseResult
- CsvSaveOptions
- CustomBorderStyle
- CustomFunction
- DataImportOptions
- DataImportResult
- DataValidationJsonError
- DateInfo
- DeserializationOptions
- DocumentProperties
- Event
- EventArgs
- FindOptions
- FontColorSortField
- FontInfo
- FormulaJsonError
- HyperLinkCellType
- IconSortField
- ImageSaveOptions
- ImageSource
- JsonError
- Margin
- OpenOptionsBase
- PageContentInfo
- PageInfo
- PagePrintedEventArgs
- PagePrintEventArgs
- PagePrintingEventArgs
- PageSettings
- Parameter
- PasteOption
- PdfSaveOptions
- PdfSecurityOptions
- PivotFieldCustomGroupOptions
- PivotFieldDateGroupOptions
- PivotFieldNumberGroupOptions
- PivotFilterOptions
- Point
- PrintManager
- RadioButtonListCellType
- RangeEventArgs
- RangeTemplateCellType
- Rectangle
- RepeatSetting
- ReplaceOptions
- SaveOptionsBase
- SelectFieldItem
- SerializationOptions
- SheetEventArgs
- SignatureDetails
- Size
- SjsOpenOptions
- SjsSaveOptions
- SortFieldBase
- SpecialCellsValue
- TableStyleFactory
- TextFormatInfo
- Theme
- Themes
- ThemeStorage
- ValueSortField
- WebRequestResult
- Workbook
- WorkbookOptions
- WriteProtection
- XlsmOpenOptions
- XlsmSaveOptions
- XlsxOpenOptions
- XlsxSaveOptions
- XltxOpenOptions
- XltxSaveOptions
- Enum Classes
- Exceptions
- Interfaces
-
Classes
- com.grapecity.documents.excel.drawing
- com.grapecity.documents.excel.expressions
- com.grapecity.documents.excel.forms
- com.grapecity.documents.excel.template
- com.grapecity.documents.excel.template.DataSource
FormulaJsonError
Class FormulaJsonError
java.lang.Object
com.grapecity.documents.excel.JsonError
com.grapecity.documents.excel.FormulaJsonError
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.
Workbook sourceWorkbook = new Workbook();
sourceWorkbook.getWorksheets().get(0).getRange("C2").setFormula("=SUM(A1:A2)");
String json = sourceWorkbook.toJson().replace("SUM(A1:A2)", "SUM(A1:)");
Workbook importedWorkbook = new Workbook();
List<JsonError> errors = importedWorkbook.fromJson(json);
FormulaJsonError error = (FormulaJsonError) errors.get(0);
String worksheetName = error.getWorksheetName();
String formula = error.getFormula();
-
Constructor Summary
ConstructorsConstructorDescriptionFormulaJsonError(String errorMessage, String worksheetName, int row, int column, String formula) Constructs a new FormulaJsonError object with the specified error message, worksheet name, row, column, and formula. -
Method Summary
Modifier and TypeMethodDescriptionintGets the column index where the formula error occurred.Gets the formula text associated with this JSON import error.intgetRow()Gets the row index where the formula error occurred.Gets the name of the worksheet where the formula error occurred.Methods inherited from class com.grapecity.documents.excel.JsonError
getErrorMessage
-
Constructor Details
-
FormulaJsonError
public FormulaJsonError(String errorMessage, String worksheetName, int row, int column, String formula) Constructs a new FormulaJsonError object with the specified error message, worksheet name, row, column, and formula.- Parameters:
errorMessage- The error message associated with the formula error.worksheetName- The name of the worksheet where the formula error occurred.row- The row index where the formula error occurred.column- The column index where the formula error occurred.formula- The formula that caused the error.
-
-
Method Details
-
getWorksheetName
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.
Workbook sourceWorkbook = new Workbook(); sourceWorkbook.getWorksheets().get(0).getRange("C2").setFormula("=SUM(A1:A2)"); String json = sourceWorkbook.toJson().replace("SUM(A1:A2)", "SUM(A1:)"); Workbook importedWorkbook = new Workbook(); List<JsonError> errors = importedWorkbook.fromJson(json); FormulaJsonError error = (FormulaJsonError) errors.get(0); String worksheetName = error.getWorksheetName();- Returns:
- The worksheet name associated with this formula error, or
nullif no worksheet name was provided.
-
getRow
public int getRow()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.
Workbook sourceWorkbook = new Workbook(); sourceWorkbook.getWorksheets().get(0).getRange("C2").setFormula("=SUM(A1:A2)"); String json = sourceWorkbook.toJson().replace("SUM(A1:A2)", "SUM(A1:)"); Workbook importedWorkbook = new Workbook(); List<JsonError> errors = importedWorkbook.fromJson(json); FormulaJsonError error = (FormulaJsonError) errors.get(0); int row = error.getRow();- Returns:
- The zero-based row index of the formula error location.
-
getColumn
public int getColumn()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.
Workbook sourceWorkbook = new Workbook(); sourceWorkbook.getWorksheets().get(0).getRange("C2").setFormula("=SUM(A1:A2)"); String json = sourceWorkbook.toJson().replace("SUM(A1:A2)", "SUM(A1:)"); Workbook importedWorkbook = new Workbook(); List<JsonError> errors = importedWorkbook.fromJson(json); FormulaJsonError error = (FormulaJsonError) errors.get(0); int column = error.getColumn();- Returns:
- The zero-based column index of the formula error location.
-
getFormula
Gets the formula text associated with this JSON import error.This method returns the formula string that could not be processed when the workbook data was loaded from JSON.
Workbook sourceWorkbook = new Workbook(); sourceWorkbook.getWorksheets().get(0).getRange("C2").setFormula("=SUM(A1:A2)"); String json = sourceWorkbook.toJson().replace("SUM(A1:A2)", "SUM(A1:)"); Workbook importedWorkbook = new Workbook(); List<JsonError> errors = importedWorkbook.fromJson(json); FormulaJsonError error = (FormulaJsonError) errors.get(0); String formula = error.getFormula();- Returns:
- The formula text associated with this error, or
nullif no formula was provided.
-