MergedCellStore Class

MergedCellStorelink

Represents a store for merged cell ranges in a spreadsheet.

Declaration

public MergedCellStore()

Rangeslink

Gets the list of merged cell ranges in the store.

Declaration

public IReadOnlyList<Documents.Spreadsheet.RangeRef> Ranges { get; }

Property Value

Addlink

Adds a merged cell range to the store.

Declaration

public void Add(Documents.Spreadsheet.RangeRef range)

Parameters

Containslink

Checks if the store contains a merged range that includes the specified cell address.

Declaration

public bool Contains(Documents.Spreadsheet.CellRef address)

Parameters

Returns

Containslink

Checks if the store contains a merged range that includes the specified cell address.

Declaration

public bool Contains(Documents.Spreadsheet.RangeRef range)

Parameters

Returns

GetMergedRangelink

Gets the merged range that contains the specified cell address. O(1) lookup via spatial index.

Declaration

public Documents.Spreadsheet.RangeRef GetMergedRange(Documents.Spreadsheet.CellRef address)

Parameters

Returns

GetMergedRangeOrSelflink

Gets the merged range for the specified cell address, or returns the address as a range if no merged range is found.

Declaration

public Documents.Spreadsheet.RangeRef GetMergedRangeOrSelf(Documents.Spreadsheet.CellRef address)

Parameters

Returns

GetMergedRangeStartOrSelflink

Gets the start cell of the merged range that contains the specified cell address, or returns the address itself if no merged range is found.

Declaration

public Documents.Spreadsheet.CellRef GetMergedRangeStartOrSelf(Documents.Spreadsheet.CellRef address)

Parameters

Returns

GetOverlappingRangeslink

Gets a list of merged ranges that overlap with the specified range.

Declaration

public List<Documents.Spreadsheet.RangeRef> GetOverlappingRanges(Documents.Spreadsheet.RangeRef range)

Parameters

Returns

Removelink

Removes a merged cell range from the store.

Declaration

public bool Remove(Documents.Spreadsheet.RangeRef range)

Parameters

Returns