Hello,
While trying to read a cell with float inside, like 10.01 for example, when using :
-> xl.Sheets|sheetNumber].AsFloat[col,line];
We are getting '10.0101' instead of '10.01'.
Even when getting the cell with xl.Sheets|sheetNumber].AsString[col,line] we ar getting the wrong result.
When looking in the sheet, the float value is correct, we do not have a precision error.
Is there a setting to add or an other way for us to get the exact value?
We are using XLSReadWrite 6.01.15
Incorrect Float Value while reading a sheet
Re: Incorrect Float Value while reading a sheet
Hello
XLSReadWriteII reads the values stored in the file. Excel may format these values so they may not be exactly the same.
XLSReadWriteII reads the values stored in the file. Excel may format these values so they may not be exactly the same.
Lars Arvidsson, Axolot Data