Copying out underlying data to clipboard in FlexGrid

Copying out underlying data to clipboard in FlexGrid

Posted by: weide.zhu on 26 January 2021, 8:05 pm EST

• 

  weide.zhu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 January 2021, 8:05 pm EST

  hello,

  We have the requirement to copy out data to clipboard(excel, notepad) from wijmo flexgrid. And we noticed that it copies out the UI formatted decimals (in our case, we set format as ‘n2’, so it copies out 2 decimals), but what we want is to copy out the underlying decimals.

  E.G for number ‘2.20123’, we want to copy the actual number instead of just rounded ‘2.20’. the reason is that Users need to copy out the data to excel, and perform some calculation with the actual values, and then paste back to the grid.

  Is there any way to solve this?

  Thanks,

  Weid

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 January 2021, 6:11 am EST

  Hi
  
  For this, we need to handle the copy event and fetch the cells data using the getCellData(row,col,false) by iterating them.
  
  After getting the cells data, we need to set the clipboard event.

  Hope it helps!

  Regards,
  
  Manish Gupta