When using a Number column in Excel as a data source for the Open Excel 2007 Spreadsheet Task, columns that contain floating point data may not be rounded as you expect.
In Excel, columns (and cells) can be formatted with one of several data types. The Number data type is used for both integer (e.g. 1) and floating point values (e.g. 1.1). To preserve precision, Excel stores floating point values with more significant digits than are displayed. For example, you may enter the value "1.1", but the value "1.100000000000000001" may be stored by Excel. When Kivati imports this data, it retrieves the stored value with its full precision. Therefore, you may not be working with the same data that Excel displays.
This behavior is due to the behavior of an external program. The easiest workaround for this issue is to format floating point numeric data using the Text field type. This ensures that Excel stores and displays the same value.