How to determine if the selected range contains a merged cell?

[Junius]

Hi there,

I found this post "Is a selected cell merged?" from the spreadsheet forums which is quite similar to what I want.

I have a kendo.ui.spreadsheet which the user selects a range of cell (including a merged cells).  From the post, it mentioned about "For a merged Cell the Property IsSingleCell is false", but I don't see a property definition of "IsSingleCell" in the spreadsheet API documentation. 

Where can I find this "IsSingleCell" property?  If this property exists, any dojo example would be awesome.

If not, is there a way to determine if the selected range in a spreadsheet contains a merged cell? 

I'm hoping that there will be a cell property like "merged" that returns true or false.

 

Any inputs is greatly appreciated.

Junius

[Ivan Danchev]

Hello Junius,

The linked thread is about the WPF RadSpreadsheet. The Kendo UI Spreadsheet is a different component. To check whether there is a merged cell in a given range, you can use the _mergedCells private property. It can be accessed like this:

var mergedCellsInRangeArray = sheet.range("A1:G1")._sheet._mergedCells;

It is an array and its length will return 0 if there are no merged cells in the range, otherwise it will contain objects with more information on the merged cells. 

See this dojo example, in which initially there is no merged cells and on pressing the button above the Spreadsheet a cell is merged, which is reflected in the  _mergedCells property value.

Regards,
Ivan Danchev
Progress Telerik

[QualiWareUA]

as far as i know 

sheet.range("A1:G1")._sheet ignores the range, ringt?

[Neli]

Hi,

You are indeed correct. You can retrieve the merged cells in the sheet using the `sheet._mergedCells`.

I hope this helps.

Regards,

Neli

[Junius]

Thank you for your response Ivan.  Your answer is really helpful.