GrapeCity.Documents.Excel.AutoMergeDirection

AutoMergeDirection Enum

Specifies the direction for auto merge operations.

Used with AutoMerge(IRange, AutoMergeDirection, AutoMergeMode, AutoMergeSelectionMode) to control how adjacent cells with the same value are merged. The default direction is Column.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum AutoMergeDirection

Public Enum AutoMergeDirection

Examples

worksheet.Range["A1:A4"].Value = new object[,] {
    { "Fruit"}, { "Fruit"}, { "Vegetable"}, { "Vegetable"}
};
worksheet.AutoMerge(worksheet.Range["A1:A4"], AutoMergeDirection.Column);

Fields

Name	Description
Column	Indicates to apply the auto merge in column direction.
ColumnRow	Indicates to apply the auto merge in column direction preferentially then in row direction.
None	Indicates to cancel the auto merge.
Row	Indicates to apply the auto merge in row direction.
RowColumn	Indicates to apply the auto merge in row direction preferentially then in column direction.