Pasting is removing the format of cells

Pasting is removing the format of cells

Posted by: datta on 25 July 2019, 8:14 am EST

• 

  datta

  • Post Options:
  • Link
    Copy

  Posted 25 July 2019, 8:14 am EST

  Hi if I copy some cells from an excel file to spreadJS cells using Ctrl V, target cell format is getting replaced with source format. Is there any setting to change this behavior

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 26 July 2019, 2:16 am EST

  Hi,

  This is the intended design behavior. If you would like to preserve formats during paste operation then you need to save formats during the ClipboardPasting event and then restore it on the ClipboardPasted event. Please refer to the following sample which demonstrates the same:
  
  https://codesandbox.io/s/spread-js-starter-0r9dc

  Regards