Locale settings not working for a cell with CellFormat set as Date of Type m

Aspose.Cells Product Family
1

Hi,

I have a problem with the Locale setting when formatting dates.
In the attached file I have the values in column B formatted to Date of type M (m). On each row a different Locale is set. In excel the displayed value respects the Locale value, as expected.
Using Aspose.Cells to parse and display the same values, the Locale setting is ignored, and everything is displayed as for “en-US” Locale setting - the default one.

The code used to display the value is:
var wb = new Workbook(@“C:\Users\IBM_ADMIN\Desktop\DateFormats.xlsx”);
for (var i = 0; i < 5; i++)
{
Console.Write(wb.Worksheets[0].Cells[i, 0].DisplayStringValue + " -> ");
Console.WriteLine(wb.Worksheets[0].Cells[i, 1].DisplayStringValue);
}

Thank you,
Lucian Nistor

2

Hi Lucian,


Thanks for sharing the sample code with template file.

I can notice the issue apparently but we need to investigate it if we can support it or not. I have logged a ticket with an id “CELLSNET-41348” for it. We will look into it soon.

Thank you.
3

Hi,


Please try the attached fix/version: Aspose.Cells for .NET v7.3.5.4

We have fixed your issue now.

Let us know your feedback.

Thank you.
4

The issues you have found earlier (filed as CELLSNET-41348) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.