Excel decimal value incorrectly imported

Posted by: c17 on 8 September 2017, 2:27 pm EST

  • Posted 8 September 2017, 2:27 pm EST

    Hi,

    I have an Excel sheet with a cell that has the following value:  0.0000793 

    I have confirmed, by using the VB immediate window within Excel, that that truly is the value property, and not just the text, which is "0.0000793"

    However, when I import the Excel sheet into a Spread sheet, the corresponding Spread cell winds up with the following properties:

       .text =  "0.0000793"

       .value = 0.00007929999999999999

    What gives?  This is the line I am using for the import:

            fpImport.OpenExcel(ofd.FileName, FarPoint.Excel.ExcelOpenFlags.DataOnly + FarPoint.Excel.ExcelOpenFlags.DoNotRecalculateAfterLoad)

     I am using Spread for Windows Forms version 4.0.2012.2005

     Thank you,

    C17

     

  • Replied 8 September 2017, 2:27 pm EST

    Hello,

    I am unable to replicate the issue with the Spread 4
    latest build wherein the Text and the Value property are returning
    correct values. However, i would suggest you to please upgrade your
    project to the latest build and let us know if it solves your issue. You
    can download the latest build from this link






    ftp://ftp.fpoint.com/SpreadWinForms4 .

    Thanks.
Need extra support?

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

Learn More

Forum Channels