Observed with Aspose.Cells 4.4.1:
I have an XLS file containing a cell with the value ‘4/9/2007’. If I look at the properties of the Cell object, it looks like this:
DateTimeValue: {4/9/2007 12:00:00 AM} System.DateTime
IntValue: 39181
StringValue: "4/9/2007"<br>
Type: IsDateTime<br><br>These all seem correct to me.<br><br>But, if I convert the file to CSV and then look at the Cell object, it looks like this:<br><br>I see the following:<br> DateTimeValue: {4/9/2007 12:00:00 AM} System.DateTime<br> IntValue: 39181<br> StringValue: 39181<br> Type: IsNumeric<br><br>It seems to me that the Cell object has two wrong values in the CSV case. First, it claims that the cell's type is IsNumeric, when it should be IsDateTime. Also, it does not correctly return the string value for the StringValue property.<br>