I am Importing a pretty simple Excel file with one date and two time columns (beside some other text and number columns).
I go trough the rows and columns of the used cell range to extract their values. Most of the Date and Time cells got the correct CellValueType number and the correct FormatType and FormatString. Some of them however come with a CellValueType.Text and a Value of "error" or "string". Actually 1 of 60 rows is affected where i can not retrieve the date and one of the two time cell values.
The strange thing here: Creating a Telerik.Web.Spreadsheet.Workbook from the Model.Workbook and adding the worksheet in question to a RadSpreadsheet the RadSpreadSheet will show no problems at all and all the cell formatting also is correct.
Now is there something fishy with the cell.GetValue()? And is there something i can do to hopefully avoid errors like that. Yes, i could just delete the row and add it again and maybe solve the problem for now. But i will keep the file as it is for Science.