Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

XL.Sheet.AddIgnoredError

Adds the ignored error for specified range.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 7.2 Yes Yes Yes Yes Yes

MBS( "XL.Sheet.AddIgnoredError"; bookRef; sheetIndex; rowFirst; colFirst; rowLast; colLast; ignoreErrors )

Parameters

Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
rowFirst The first row for the area. First row has index 0. $row
colFirst The first column for the area. First column has index 0. $column
rowLast The last row for the area. First row has index 0. $row
colLast The last column for the area. First column has index 0. $column
ignoreErrors The combination of errors to ignore. "InconsistRange¶EvalError"

Result

Returns OK or error.

Description

Adds the ignored error for specified range.
It allows to hide green triangles on left sides of cells. For example, if a cell is formatted as text but contains a numeric value, this is considered to be a potential error because the number won't be treated as a number, for example, in calculations. It is possible to combine a few IgnoredError values as list.
Returns error message on failure.

IgnoredError valueDescription
NoErrorNo errors
EvalErrorIgnore errors when cells contain formulas that result in an error.
EmptyCellRefIgnore errors when formulas refer to empty cells.
NumberStoredAsTextIgnore errors when numbers are formatted as text or are preceded by an apostrophe.
InconsistRangeIgnore errors when formulas omit certain cells in a region.
InconsistFormulaIgnore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TwoDigTextYearIgnore errors when formulas contain text formatted cells with years represented as 2 digits.
UnlockFormulaIgnore errors when unlocked cells contain formulas.
DataValidationIgnore errors when a cell's value in a Table does not comply with the Data Validation rules specified.

See also


XL.Sheet.AddHyperlink   -   XL.Sheet.AddrToRowCol

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins