MergeCompare Property

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)

See Also

VSFlexGrid Control