Spread V11: Pasting cell from excel that has value like '002, is not working

Spread V11: Pasting cell from excel that has value like '002, is not working

Posted by: viswanath.malepati on 19 February 2018, 6:26 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 19 February 2018, 6:26 am EST

  Hi,

  Consider any cell in excel that has '002 as its value, in excel it is considered as string and value in that cell becomes 002 and it will be left aligned in the cell as it is a string.

  Now copy this cell from excel and paste it in spread sheet. Note that instead of 002 being left aligned, you will notice 2 to be right aligned in that particular cell. You should be able to reproduce this in:

  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  Note: When we manually enter '002 in any cell from keyboard, it works perfectly like excel, you will notice that cell value will be 002 and it is left aligned.

  Thanks,
  
  Viswanath

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 February 2018, 9:59 am EST

  Hello Viswanath,

  It looks like a design behavior to me, however I have informed the dev team to further investigate this issue. I will inform you once I get an update from them. The tracking id for this issue is 254639.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 2:38 am EST

  Hi Viswanath,

  This is current designed behavior of SpreadJS. When copying '002 from excel, actually, there is no ’ in clipboard data (both html and text).

  When paste in SpreadJS, we just get 002 pasting, then the general formatter will format the 002 text to number 2.

  from the pasted data, we don’t know if it is from excel or not, hence, SpreadJS have no idea how to specified handle the case for excel.

  I hope it clears the doubt.

  Thanks,
  
  Deepak Sharma