In spread sheet, getting random numbers after decimal place

Posted by: attrey90mayank on 10 March 2019, 8:44 pm EST

    • Post Options:
    • Link

    Posted 10 March 2019, 8:44 pm EST

    Hello,

    In my FarPoint.Win.Spread.CellType.ComboBoxCellType when i enter any digit for example 10.123456789 it becomes 10.113466789 and also when i do backspace it becomes 0.000000001110010. Can anyone help me in related to this? This is very urgent. And also When i entered number greater >= 8 is entered on screen, field auto populates the rounding digits after decimal.

    e.g.

    • 8.12 is displayed as 8.119999999999999

    • 9.2 is displayed as 9.199999999999999

    Please help me.

    Thanks,

    Mayank

  • Posted 11 March 2019, 4:58 pm EST

    Hello,

    In my FarPoint.Win.Spread.CellType.NumberCellType when i enter any digit for example 10.123456789 it becomes 10.113466789 and also when i do backspace it becomes 0.000000001110010. Can anyone help me in related to this? This is very urgent. And also When i entered number greater >= 8 is entered on screen, field auto populates the rounding digits after decimal.

    e.g.

    • 8.12 is displayed as 8.119999999999999

    • 9.2 is displayed as 9.199999999999999

    Please help me.

    Thanks,

    Mayank

  • Posted 11 March 2019, 10:35 pm EST

    Hello,

    Unfortunately, I am unable to replicate this issue with the attached sample using Spread for Winforms version “12.45.20181.0”. However, this issue seems to be related to the code you are using for creating ComboboxCellType & NumberCellType.

    Hence, please share a small working stripped out sample replicating both the issues with the Spread version you are using.

    We will debug your case at our end and will try to provide you with a fix.

    Thanks,

    Reeva

    WindowsApp1.zip

Need extra support?

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

Learn More

Forum Channels