GrapeCity.Documents.Excel.AutoMergeSelectionMode

AutoMergeSelectionMode Enum

Specifies the selection mode when auto merge is applied to a range.

Used as a parameter in AutoMerge(IRange, AutoMergeDirection, AutoMergeMode, AutoMergeSelectionMode) to control how cells are selected after auto merging. This property is primarily applicable to SpreadJS.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum AutoMergeSelectionMode

Public Enum AutoMergeSelectionMode

Examples

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

Fields

Name	Description
Merged	Indicates to select all cells which have same value when the auto merge is applied.
Source	Indicates to select individual cell when the auto merge is applied. This property will take effect only when IncludeAutoMergedCells is false.