sheet.copyTo method removes cellType of target cell

sheet.copyTo method removes cellType of target cell

Posted by: grapecity on 10 April 2018, 5:07 am EST

• 

  grapecity

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 April 2018, 5:07 am EST

  Hi,

  i have upgraded from 11.0.1 to 11.0.6 and recognized that if you use copyTo method (even with CopyToOptions.style only) the customCellType is removed from the target cell.

  This was not the case in 11.0.1.

  BR, Peter

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 11:35 am EST

  Hello,

  I am able to replicate this issue at my end but it looks like a default behavior to me. CellType is a part of cell style which gets overridden when you copy the style from other cell.

  I will further discuss this issue with the development team and let you know about my findings.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 11:39 am EST

  The tracking id for this issue is 256931

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 2:30 am EST

  Hello,

  This is found to be a design behaviour. CellType is a part of cell style and will always get override with setting cell style.
  
  Also we checked the behavior with Spread v11.0.1 and see no difference in terms of CopyTo() method.

  Please refer to the attached sample.

  Thanks,
  
  Deepak SharmaSpreadjsCustomCellTypeWithStyleCopy.html.zip