Copying number with space in clipboard

Copying number with space in clipboard

Posted by: shashank.sawant on 13 July 2020, 1:21 am EST

• 

  shashank.sawant

  • Post Options:
  • Link
    Copy

  Posted 13 July 2020, 1:21 am EST

  I am trying to deal with scenario :
  
  There are multiple numeric values with some space.(Those space are due to changing language from english to other. ex: finnish)
  
  For Example:

  1 361,33
  
  1 661,33
  
  3 020,99

  When I copy those values (CTRL + C) and paste it into different excel sheet, it pastes as it is but when I try to sum those values it results in zero.

  I have attached sample code which actually formats selected cell.

  Is there any way to copy these values without space and without changing its format on cell ?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2020, 10:03 am EST

  Hi,

  We are working on this and will share an update with you soon.

  Regards

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 15 July 2020, 7:35 am EST

  Hi,

  The issue is arising because the number copied does not match the system’s number format. In MS Excel, number format i.e decimal separator, digit group symbol, etc are picked by the OS settings and while pasting if the value matches the number format then it is pasted as the number otherwise it is pasted as a string. That is why using it in formula return 0.
  
  SJS has no control here, you would have to make sure that the culture settings/number format of the system matches the culture settings of the SJS for the numbers to be actually pasted as numbers.
  
  Hope this clear, please let me know if there is any confusion.

  Regards