Workbook with CSV Files and dates around 1900

Hi, we are importing csv files with the Workbook class and accessing the cells with _worksheet.Cells.GetCell(1,1);.

I tested the following data:

Date, Value
1899-12-31,7
1900-01-01,8
1900-01-02,9
1900-01-03,10

A small vector of daily dates and values - all are accessed correctly as dates(31 dec 1899, 1 Jan 1900, 2 Jan 1900) except the last one which is read as 28.02.1900 instead of 1.3.1900.

We used until now the version 8.6.0.0 where this worked fine - we updated and tested version 9.0 and 17.3 both produce this error.

Hi,


Thanks for providing us some details.

Could you provide us your template CSV file and sample code to show the issue on our end, we will check it soon.

Thank you.

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix.

This issue has been logged as

  • CELLSNET-45263 - Problem while importing dates around 1900 from CSV file

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-45263 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Hi,

Please try our latest fix/version: Aspose.Cells for .NET v17.3.8 (attached):
  • Aspose.Cells for .NET v17.3.8 compiled in .NET Framework 2.0.
  • Aspose.Cells for .NET v17.3.8 compiled in .NET Framework 4.0.

(Note: please try any of the fixes for your underlying .NET framework version).

Your issue "CELLSNET-45263" should be fixed in it.

Let us know your feedback.

Thank you.

Hi,
the issue is fixed.
Thanks,
Jochen

Hi,


Thanks for your feedback.

Good to know that your issue is sorted out by the new fix/version. 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.

The issues you have found earlier (filed as CELLSNET-45263) have been fixed in Aspose.Cells for .NET 17.4.0.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.