DateTime field shows Type=IsNumeric after Aspose upgrade

Aspose.Cells Product Family
1

Hi there,


We recently upgraded from Aspose Cells 7.1.1.0 to 8.4.0.0 and noticed some strange behavior when loading one of our client’s Workbook XML files. When loading the attached file with the newer version the Cell.Type is IsNumeric for the fields that are specifically called out as DateTime fields. This makes the Value come out as a number instead of a Date as it was previously. In 7.1.1.0 this works fine and we are able to use the Type=IsDateTime to determine whether a field is a Date field. Is there something I can do to determine when a field is a date in this case?

Thanks!
2

Hi Kevin,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.4.1.2 and following piece of code. We have noticed that the API is unable to detect the cell values of D2 & D3 as DateTime. We have logged this incident in our bug tracking system for further investigation under the ticket CELLSNET-43620. Please allow us some time to properly look into the matter, and get back to you with updates in this regard.

C#

var book = new Workbook(“D:/WorkbookML.xml”);
var cells = book.Worksheets[0].Cells;
Console.WriteLine(cells[“D2”].Type);
Console.WriteLine(cells[“D3”].GetStyle().IsDateTime);
3

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.4.1.3 and let us know your feedback.

4

Thank you! The new version works great.

5

Hi,


Thanks for your feedback.

Good to know that your issue is resolved by the new fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.