GrapeCity.Documents.Excel.AutoMergeMode

AutoMergeMode Enum

Specifies the auto merge mode.

Used with AutoMerge(IRange, AutoMergeDirection, AutoMergeMode, AutoMergeSelectionMode) to control how neighboring cells with the same value are merged.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum AutoMergeMode

Public Enum AutoMergeMode

Examples

worksheet.Range["A1:A4"].Value = new object[,] {
    {"Apple"}, {"Apple"}, {"Banana"}, {"Banana"}
};
worksheet.AutoMerge(worksheet.Range["A1:A4"], AutoMergeDirection.Column, AutoMergeMode.Free);

Fields

Name	Description
Free	Indicates to apply the auto merge when neighboring cells have same value.
Restricted	Indicates to apply the auto merge when neighboring cells have same value and the corresponding cells in previous row or column are merged automatically.