Spread_JS issue

Spread_JS issue

Posted by: uraatz on 30 November 2022, 8:17 am EST

• 

  uraatz

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 November 2022, 8:17 am EST - Updated 30 November 2022, 12:53 pm EST

  Steps to reproduce the issue:
  
  Open Microsoft Excel (desktop version).
  
  Set the sheet background color to yellow.
  
  Add some text in the yellow cells.

  Open Spread JS in a web browser.
  
  Set the sheet background color to green.

  Copy some cells in MS Excel.
  
  Use < Strg > + < v > to paste it in Spread JS.

  Result:
  
  The content inclusive the yellow background color will be copied into Spread JS.
  
  This works fine.

  In Spread JS select another cell which has still the green background color.
  
  Right mouse click. A context menu should open which offers you different “Paste Options”.
  
  Try one of them.
  
  None of them ar copying the clipboard content.

  My goal / what I am trying to archive:
  
  The “values only” of the clipboard content should be pasted into Spread JS.
  
  Means the functionality behind the
  
  third Spread JS context menu item “Value 123” with the hint text “Values only” should work.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 November 2022, 12:46 pm EST - Updated 1 December 2022, 5:29 am EST

  Hi,

  This is by design and technical limitations, Pasting from contextmenu is different than pasting from ctrl+v. Due to security issues web apps do not have direct access to the system clipboard it is the browser that is responsible for providing the clipboard but it only gives it when the user explicitly hits ctrl+v that is why on a context menu button click we can not access the system clipboard. However, modern Clipbaord API has been developed but currently, spreadJS does not support that.

  In other words, contextmenu pasting works on the internal clipboard, it will not paste any content copied outside from the spreadJS grid.

  Regards,
  
  Avinash

• 

  uraatz

  • Post Options:
  • Link
    Copy

  Posted 30 November 2022, 12:56 pm EST

  Thank you very much for the really very fast answer.
  
  Well, that’s what I thought.
  
  The issue is therefore settled.
  
  Thanks again!