Hello,
Hi David,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for considering Aspose.
We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id CELLSNET-13474.
Thank you & Best Regards,
Hi,
Please try the attached version.
We have fixed the issue.
Thank you.
Hello,
Hi David,
Well, I tested your scenario with v4.8.2.1 but could not find any issue. It works as MS Excel.
Here is my sample code:
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
Aspose.Cells.Cell cell1 = worksheet.Cells[“A2”];
cell1.Formula = "=“12 January 2010 18:30:00”-“12 January 2010 18:15:00"”;
Aspose.Cells.Cell cell2 = worksheet.Cells[“A3”];
cell2.Formula = "=“12 January 2010 18:30”-“12 January 2010 18:15"”;
Aspose.Cells.Cell cell3 = worksheet.Cells[“A4”];
cell3.Formula = "=“12 January 2010 18:00”-“12 January 2010 18:05"”;
workbook.CalculateFormula();
MessageBox.Show(cell1.DoubleValue.ToString());
MessageBox.Show(cell2.DoubleValue.ToString());
MessageBox.Show(cell3.DoubleValue.ToString());
workbook.Save(“e:\test\jj22sdfsdfd11out_hyperlink.xls”);
Could you create a sample code/application to post it here to show the issue, we will check it soon.
Thank you.
Disregard my last email, the fix works perfectly
The issues you have found earlier (filed as 13474) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.