ConstReadonlyApproximateMatch: "approximateMatch"A lookup that matches the nearest key rather than the key.
ReadonlyConstantFrequency: "constantFrequency"A constant typed into a formula — a number, a string or a boolean — and how often the workbook types it.
ReadonlyDegenerateCall: "degenerateCall"An aggregate over one cell, or over typed numbers only.
ReadonlyEmptyCellReference: "emptyCellReference"A formula that refers to empty cells.
ReadonlyErrorConstant: "errorConstant"A formula that is only an error value, such as =#DIV/0!: what a converter leaves when it drops a formula.
ReadonlyEvaluatesToError: "evalError"A formula that evaluates to an error value.
ReadonlyExternalReference: "externalReference"A reference to another workbook, a deleted reference, or a function a converter could not name.
ReadonlyHardcodeInRun: "hardcodeInRun"A typed value in a run of formulas: the cells on both sides of it, along a row or a column, are formulas. SheetXL's own; not written to an xlsx file's ignored errors.
ReadonlyInconsistentFormula: "formula"A formula inconsistent with the formulas around it.
ReadonlyInconsistentListFormula: "calculatedColumn"A formula inconsistent with its table's calculated column.
ReadonlyKeyLabelMismatch: "keyLabelMismatch"A lookup keyed by a typed string that labels neither the formula's row nor its column.
ReadonlyLinkLabelMismatch: "linkLabelMismatch"A link to another sheet whose target row is labeled other than its own row.
ReadonlyListDataValidation: "listDataValidation"A value that fails the cell's list data validation.
ReadonlyLiteralMatchesInput: "literalMatchesInput"A number typed into a formula that equals a typed number on the sheet no formula reads.
ReadonlyLookupShape: "lookupShape"A lookup whose result array and lookup vector do not line up.
ReadonlyMisalignedReference: "misalignedReference"A total, or the first line of a block, that sums its block and also adds a cell outside it: another block's line item, another block's total, or an absolute reference.
ReadonlyNumberAsText: "numberStoredAsText"A number stored as text.
ReadonlyOmittedCells: "formulaRange"A formula that omits cells adjacent to the range it refers to.
ReadonlyRepeatedReference: "repeatedReference"A cell or range counted twice in one sum.
ReadonlyRowGap: "rowGap"A labeled row with nothing where the rows above and below hold values: a line left out, or a period of it.
ReadonlyScaleOutlier: "scaleOutlier"A typed number an order of magnitude or more off the numbers typed in its format on the sheet.
ReadonlySignVsSiblings: "signVsSiblings"A link read with the other sign from the sheet's other links into the same row.
ReadonlyStyleBreak: "styleBreak"An authored format (font, fill, number format, alignment) that breaks the run around it: the cells on both sides carry one format, and this cell another. SheetXL's own; not written to an xlsx file's ignored errors.
ReadonlyStyleRole: "styleRole"A format part paired with the cell's role: a link to another sheet, a reference on this sheet or a calculation whose font color is other than most of its role on the sheet have, and is one the workbook writes some role in. SheetXL's own; not written to an xlsx file's ignored errors.
ReadonlySumIncludesSubtotal: "sumIncludesSubtotal"A sum whose range holds a subtotal of its own cells, or a ratio.
ReadonlyTextDate: "twoDigitTextYear"A year written as two digits in text.
ReadonlyTwinBlockDivergence: "twinBlockDivergence"A formula that differs from its twins on the sheet, the formulas of the same shape, in a typed number.
ReadonlyUnlockedFormula: "unlockedFormula"A formula in an unlocked cell.
ReadonlyUnreferencedInput: "unreferencedInput"A typed number beside a label that no formula in the workbook reads: an assumption the model never uses.
The checks SheetXL runs fire through ICell.getAnomalies and the anomalies feature;
an ignored check does not fire. Ignores follow their cells through inserts and deletes, are
never copied, and leave a cell that is written or cleared, as in Excel.
One of Excel's background error checks (Formulas > Error Checking), by the name the file stores it under, or one of SheetXL's own. A cell can be told to ignore a check (ICellRange.setErrorIgnored); Excel then draws no error indicator on it for that rule.