I'm using the library to retrieve date/time values and putting in a correction for the base date (as in issue #56), but have hit a problem where the time is not the same as the one in Excel, that I have traced back to a difference in the underlying float value.
For example, in my spreadsheet I have a cell with value 35113.58681 (19 Feb 2000 14:05:00), however cell.floatValue is returning 35113.5859 (19 Feb 2000 14:02:40), and many others are similarly out by a few minutes. This does not look to be a date problem as such, but a general issue retrieving float values, some are accurate but most are not.
Am I missing something or is this a problem in the underlying XML data retrieval?
I'm using the library to retrieve date/time values and putting in a correction for the base date (as in issue #56), but have hit a problem where the time is not the same as the one in Excel, that I have traced back to a difference in the underlying float value.
For example, in my spreadsheet I have a cell with value 35113.58681 (19 Feb 2000 14:05:00), however cell.floatValue is returning 35113.5859 (19 Feb 2000 14:02:40), and many others are similarly out by a few minutes. This does not look to be a date problem as such, but a general issue retrieving float values, some are accurate but most are not.
Am I missing something or is this a problem in the underlying XML data retrieval?
Thanks, Phil