We just upgraded to Aspose version 5.3.3 from 4.9.1. Most of our reports use .xlsm templates. The templates contain Aspose tags, which are populated from stored procedures. The data is coming through fine. However, if we have a formula that links to one of the data cells, then it is not refreshing. If I use Application.CalculateFull (CTRL+ATL+F9), then the formulas refresh. However, they will not refresh automatically when the workbook is launched. By the way, we do have formulas set in Excel to Automatically update. Manual is not checked.
I have attached a sample output report with the issue. Note: The EventLog worksheet was populated from Aspose. The Test worksheet contains the formulas that are not refreshing.
Here is some sample code from one of our reports:
xls.Workbook.SaveOptions.SaveFormat = Aspose.Cells.SaveFormat.Xlsm
xls.Workbook.Settings.ReCalculateOnOpen = True
xls.Workbook.Settings.CalcMode = Aspose.Cells.CalcModeType.Automatic
Dim saveOptions As New Aspose.Cells.OoxmlSaveOptions
saveOptions.SaveFormat = Aspose.Cells.SaveFormat.Xlsm
xls.Workbook.Save(HttpContext.Current.Response, "AffordablePortfolioSummary.xlsm", Aspose.Cells.ContentDisposition.Attachment, saveOptions)
We are having to add a macro to all of our .xlsm reports to work around this issue. However, we would prefer to have this handled in our Aspose code, if possible. This issue did not occur prior to the upgrade.