Hi, SpreadJS Cell Copy included linebreak words

Hi, SpreadJS Cell Copy included linebreak words

Posted by: pyoh on 14 May 2024, 1:05 am EST

• 

  pyoh

  • Post Options:
  • Link
    Copy

  Posted 14 May 2024, 1:05 am EST - Updated 14 May 2024, 1:11 am EST

  as a title.
  
  If I Copy Cell after clicking cell once.
  
  It was copied incluced linebreak word(“\n”)
  
  
  
  how to copy only value without linebreak?

  I set clipboardOptions to “valuesAndFormatting”

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 15 May 2024, 2:46 am EST - Updated 15 May 2024, 2:51 am EST

  Hi,

  Based on my understanding, when you copy a cell value from SpreadJS and paste it, the copied value includes the line break.

  This is expected behavior and the same with Excel. And With clipboardOptions, you cannot exclude this line break. However, If you want to copy the value without the line break, you can do so by double-clicking the cell. You can refer to the attached gif “Steps.gif”.

  GIF:

  Regards,
  
  Priyam