Hi,
I’ve encountered an issue while I was working with pivot tables.
I’ve attached my template and the result file.
As you can see, the template contains a pivot table with not refreshed data.
This is my code:
var wb = new Workbook(@“C:\Test\Template.xlsx”);
wb.Worksheets[0].PivotTables[0].RefreshData();
wb.Save(@“C:\Test\Output.pdf”, SaveFormat.Pdf);
As expectation in the resultant pdf file there should be the pivot table with the refreshed data
but the “Quarter X Over/Under” row isn’t calculated.
Thanks.