Returns or sets the type of comparison used when merging cells.
Syntax
[form!]VSFlexGrid.MergeCompare[ = MergeCompareSettings ]
Remarks
The MergeCompare property is used in conjunction with the MergeCells, MergeRow, and MergeCol properties to control whether and how cells should be compared when determining whether to merge them or not.
The settings for the MergeCompare property are described below:
|
Constant |
Value |
Description |
|
FlexMCExact |
0 |
Cells are merged only if their contents match exactly. |
|
FlexMCNoCase |
1 |
Cells are merged if their contents match in a case-insensitive comparison. |
|
FlexMCTrimNoCase |
2 |
Cells are merged if their contents match after trimming blanks in a case-insensitive comparison. |
|
FlexMCIncludeNulls |
3 |
Empty cells are merged. |
For more details, see the MergeCells property.
Data Type
MergeCompareSettings (Enumeration)
Default Value
flexMCExact (0)