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

  • 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,


    Aditya Chauhan

  • 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:

    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.



    Steps I have followed:

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels