Number Formatting Changes when value is copied from a cell to another cell

Number Formatting Changes when value is copied from a cell to another cell

Posted by: aditya.chauhan on 9 November 2022, 4:01 pm EST

• 

  aditya.chauhan

  • Post Options:
  • Link
    Copy

  Posted 9 November 2022, 4:01 pm EST - Updated 9 November 2022, 4:09 pm EST

  Steps to reproduce

  1. Enter the value 100,000 in cell F15. The value entered number format is 1000 separated and no decimal values at end as it should be in image “F15 Input”

  2. Then the same value is copied into G15 it comes out to be with no thousand separator and 2 decimal values at end as in image “G15 Input”

  3. When the same operation is done in excel it behaves the way as it should as the number formatting there shows thousand separated and no decimal values as in image “Same Event in Excel”

  4. Also I have checked the cell number format in Excel both share the same number formatting and works as expected in excel sheet but in spreadJS the number formatting changes from F15 to G15

  Kindly please look into this and if any please provide a solution for this.

  Thank You,
  
  Regards
  
  Aditya Chauhan
  
  

  

  1190×647 45.4 KB

  

  1420×768 45.5 KB

  

  1589×764 57.9 KB

  

  1277×613 45.3 KB

  

  1601×606 27.6 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 10 November 2022, 10:49 pm EST - Updated 10 November 2022, 10:54 pm EST

  Hello Aditya,

  I tried the most recent SpreadJS V15.2.4 version, but I was unable to reproduce the problem on my end.

  You can use the example I used below, which I used for testing: https://jscodemine.grapecity.com/share/yJXbRdnz7E2v1ohEOS6RzA/

  The gif that illustrates the steps I took is also attached. If there is anything I’m missing, do let me know.

  If you are having trouble with your sample, I kindly ask that you give a rudimentary working sample that replicates the problem. You might also edit the example above and send it to us.

  Regards,

  Ankit

  Steps I have followed: