Hi, following on from issue:
http://www.aspose.com/community/forums/347552/error-with-pivot-table-connections-in-an-xlsm-file-using-aspose.cells-18.104.22.168/showthread.aspx#347552, which was successfully resolved in Aspose.Cells version 7.0.3, we have an additional problem with Pivot Table formulae in an XLSM workbook.
The issue is that when the report is generated using Aspose, the calculations in the Pivot Table seem to be picking up the wrong columns from the referenced data sheets.
I have uploaded 2 files: “Report.xlsm” which is the original report template and also “Updated_Report.xlsm” which is the report after Aspose has been used to populate information into the data sheets.
1) Open the Report.xlsm on the ‘Bursts’ tab and click in the Pivot Table which has ‘Approval Status’ listed.
2) Click on ‘options’, ‘fields items and sets’ and then select ‘list formulas’.
3) The new sheet that opens shows the formula for ‘Bursts Outstanding’ is based on “=‘Total Defects’-‘Defects Repaired’” fields which are located in the ‘Data - Bursts’ sheet.
4) Perform the same process on the Updated_Report.xlsm and note that the formula is now referencing the fields “=‘Approval Status’-‘Approver Comments’” which are the first two columns in the ‘Data - Bursts’ sheet instead…
This seems to have defaulted to the first two columns in the reference as opposed to the original from the template.