How to get merged cells count and start row index of merged cells

How to get merged cells count and start row index of merged cells

Posted by: sr on 16 March 2018, 6:59 am EST

• 

  sr

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 March 2018, 6:59 am EST

  Hi,
  
  we have a requirement to merge cells and provided a check box to check and uncheck. when retrieving data source from the sheet the check box value has to apply for all row objects in the data source. if that is not possible i need merged cell count and start row index of merged cells.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2018, 9:33 am EST

  Hello,

  There is no direct way to merge cells with same values . You can create cell spans with same values in code using addSpan() method.
  
  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#sccellspan.html

  Also to get spanned cells you can use getSpans() method which gives the collection of spans. It contains the rowcount and columncount.
  
  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Worksheet~getSpans.html

  Thanks,
  
  Deepak Sharma