Download User Manual - Synkronizer Excel Compare

106
Synkronizer 11 User Manual
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_HiddenCo Data in hidden columns will be ignored.
ls
FilterFlag_HiddenRo Data in hidden rows will be ignored.
ws
FilterFlag_None
No filters will be used.
FilterFlag_SameValu Different cell values/formulas with same result will be ignored.
es
FilterFlag_StringCas Text compare case Insensitive. "ABC" vs "abc" will be considered as equal.
e
FilterFlag_StringSpa Text compare trim text. "ABC " vs "ABC" will be considered as equal.
ce
8.1.1.8.4 FormatFlag
Constants to be used for the Formats property in Settings.
Name
Description
FormatFlag_Alignment
Compare cell alignment properties.
FormatFlag_Border
Compare cell border properties.
FormatFlag_Enabled
Enable or disable all other formats options.
FormatFlag_Font
Compare cell font properties.
FormatFlag_None
No formats are compared.
FormatFlag_Number
Compare cell number (numberformat) properties.
FormatFlag_Pattern
Compare cell pattern (interior/fill) properties.
FormatFlag_Protection
Compare cell protection properties.
8.1.1.8.5 HighlightType
Constants to be used for the Highlight property in Settings.
Name
Description
HighlightType_None
Differences are not highlighted.
HighlightType_Standard Differences are highlighted. No Cell coloring for all cells if not removed
before processing.
HighlightType_WithReset Differences are highlighted. Cell coloring for all cells is removed before
processing.
©2000-2015, XL Consulting GmbH, Switzerland