System.Format.Exception String not recognized as DateTime when loading Suomi excel file

Aspose.Cells Product Family
1

Hello,

We are running into an issue when trying to parse an excel that is using Suomi date time format. Using the following code:

var content = File.ReadAllBytes(@"C:\_work\testFile.xlsx");

using (var memoryStream = new MemoryStream(content))
{
    var xlworkbook = new Workbook(memoryStream);
}

, on the attached file.

We also tried to create the workbook passing the LoadOptions but it’s the same result.

var xlworkbook = new Workbook(memoryStream, new Aspose.Cells.LoadOptions() { CultureInfo = new CultureInfo("fi-FI") });

Version of current Aspose Cells: Aspose.Cells 21.8.0.0
testFile.7z (775.0 KB)

Problem seems to arise from the “\xl\threadedComments\threadedComments2.xml” file where there is a time stamp that looks like this: <dT=“2020-06-05T09.58.38.54”>

2

@kaushlendu.choudhary,

Please notice, after an initial test, I am able to reproduce the issue (same exception occurred) as you mentioned by loading/parsing your template XLSX file into Aspose.Cells object model. I have logged a ticket with an id “CELLSNET-51227” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@kaushlendu.choudhary,

This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for .NET v22.6) which is scheduled in the second week of June 2022. You will also be notified when the next version is published.

4

The issues you have found earlier (filed as CELLSNET-51227) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

5

The issues you have found earlier have been fixed in this update. If you have downloaded the prior one(22.6.0), please use this update to replace the downloaded one because 22.6 has a bug which sometimes may cause generated file corrupted.