Copy from Excel paste the wrong value

Copy from Excel paste the wrong value

Posted by: rlescano on 19 March 2018, 4:58 am EST

• 

  rlescano

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 March 2018, 4:58 am EST - Updated 3 October 2022, 2:21 am EST

  Hello,
  
  When I copy from Excel the content of cell formatted as “Accounting” with the value “0” (zero) and then paste it in a Sheet, the value " $ - " is being pasted.

  

  1441×642 60.6 KB

  Steps:

  1. In Excel type the number “0” in A1
  2. Set the format of the A1 Cell as “Accounting”
  3. Select and copy A1 cell (ctrl+c)
  4. Paste (ctrl+v) in SpreadJS demo site.

  Regards
  
  Román

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2018, 10:46 pm EST

  Hello,

  I am able to replicate this issue at my end and hence reported it to the development team as a bug. The issue id for this is 255906. I will let you know as soon as I get an update on this.

  Sorry for the inconvenience.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2018, 1:52 am EST

  Hello,

  This issue has come back as an intended behavior. It is said that when copy from excel, the content in the system clipboard is not 0, but the string “$ -”.
  
  When paste string “$ -” to SpreadJS, the string will be handled as a real string, not number anymore.
  
  The same behavior can be seen with Excel as well. Copy the same in Excel, then paste in OS notepad, then copy that string from notepad, paste to Excel. Excel also could not parse it to 0.

  Thanks,
  
  Deepak Sharma