BUG: Formula doesn't get copy-pasted after any cell deletion

BUG: Formula doesn't get copy-pasted after any cell deletion

Posted by: k.szabariova on 23 August 2021, 4:41 am EST

• 

  k.szabariova

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 August 2021, 4:41 am EST

  Hello,
  
  If I copy any formula (let’s say =5+5) I can paste it to other cell - no problem. But if I copy it, delete some completely different cell and then paste it, it doesn’t work. The formula doesn’t get pasted, only its result value.

  Steps to reproduce:

  1. create a formula =5+5 in a cell,
  2. copy that cell (CTRL+C)
  3. delete some different unrelated cell
  4. paste (CTRL+V) to a new cell
  5. problem - formula wasn’t pasted, only numerical result.

  You can test it on this sample SpreadJS application:
  
  https://codesandbox.io/s/spreadjs-custom-formula-with-formulabar-fjfkc

  Please how to fix this bug?
  
  Thank you very much!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 24 August 2021, 3:28 am EST - Updated 3 October 2022, 9:40 am EST

  Hi,

  We are sorry but this is not a bug it is by design to match the excel behavior. if we change the sheet(deleting, editing, etc) after copying/cutting the cells then SpreadJS clears the internal clipboard and after that, if we try to paste, the paste will be handled as an external paste so it will not contain information like formulas, formats, etc. Excel also following the same policy. Please refer to the following gif of Excel.

  I hope this clarifies the issue.

  Regards
  
  Avinash