Need help to Add date with time field using Aspose

Hi ,


When i try to add a date field with time field, aspose is not giving me the right result

The type for the date cell (A1) is Datetime and for the time cell (B1) is double.The Result cell is of type DateTime.

When i add 01/01/2012 1:00 with 00:30, it returns 01/01/2012 13:00 instead of 01/01/2012 1:30 . When i checked the excel generated by Aspose, instead of treating time as 00:30, it is treating time as 12:00:00.

Please help me to resolve this issue.

Thanks,
Divya

Hi Divya,


Thank you for contacting Aspose support.

Please give a try to the latest version of Aspose.Cells for .NET 8.2.0.1, as we have tested that the latest version calculates the sum to date time values correctly. Please check the attached input spreadsheet and image of my console showing the results.

In case the problem persists, please provide us your template spreadsheet as well as the source code to replicate the problem on our end.