Facing issue in formatting and calculation are getting wrong due to it

Aspose.Cells Product Family
1

Hi Team,

We are trying to migrate from Actuate to Aspose and here after generating the Output sheet we are getting the mismatch in Actuate and Aspose API's generated sheets but the input values are same.

It seems to be that due to the date we are facing issues.

Actuate Logs :

Cell value in Actuate file 2013-09-01T00:00:00 ** Style Set to Cell : d/M/yyyy

Aspose Logs :

Cell value in Aspose file 09/01/2013 ** Style Set to Cell : d/M/yyyy

Here i compared the Actuate and Aspose sheets with Aspose API when the style of cell is same for both why while reading the value in Aspose is coming different.

Can you please help is to identify this issue.

Thanks in advance.

Gurdeep

2

Hi Gurdeep,

Thanks for your posting and using Aspose.Cells.

If the cell format is set as d/m/yyyy, then it will show the date 07-July-2014 as 7/7/2014.

So, Aspose.Cells is showing date in correct format.

I have attached the sample xlsx file for your reference, as you can see the date 07-07-2014 10:06:00 PM in MS-Excel is showing as 7/7/2014 with the format d/m/yyyy.

Please also see the screenshot showing the MS-Excel display of date.