Posted 8 September 2017, 2:27 pm EST
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 <b>value</b> property, and not just the <b>text</b>, 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