Name

Description

FilterFlag_Constants

All constants are ignored. Only formulas are compared.

FilterFlag_Datatype

Differences in datatype are ignored. Use to ignore differences between date

values and string values representing dates.

FilterFlag_Enabled

Enable or disable all other filters options.

FilterFlag_Formulas

All formulas are ignored. Only constants are compared.

FilterFlag_HiddenCols

Data in hidden columns will be ignored.

FilterFlag_HiddenRows

Data in hidden rows will be ignored.

FilterFlag_None

No filters will be used.

FilterFlag_StringCase

Text compare case Insensitive. "ABC" vs "abc" will be considered as equal.

FilterFlag_StringSpace

Text compare trim text. "ABC " vs "ABC" will be considered as equal.

FilterFlag_RelativeTolerance

If this flag is on, then the relative differences (%) are filtered out (instead of numeric differences #)