Gembox excel pivot
![gembox excel pivot gembox excel pivot](https://www.gemboxsoftware.com/spreadsheet/examples/114/content/PivotTableCalculation.png)
Then we tried to change some values, recalculate the pivot table, and save it as a PDF. If (sheet.Name != "Sheet1") // data sheet This works without any problems: var file = ExcelFile.Load("Excel-efter-RSOutput2File.xlsx") I’m afraid we were unable to reproduce these issues.įirst, we tried to reproduce the issue with a corrupted file (can you check whether the IF on line 4 is actually what you meant).
#Gembox excel pivot pdf#
You can use the same file I sent you for ticket “Save to PDF doesn’t honour “Insert page break after each item””…to test: in “Sheet1” I just clear cells A2 to T1500 and insert a new row at A2…then refresh/calculate all pivot tables…then save the file…if I then open the file in MS-Excel I get the warning/error. I still wonder though what is causing the (error)message in MS-Excel when I open the file where I did a refresh and calculate!? when saving to pdf you always first have to do a pivottable.calculate.there is no need to do a and pivottable.calculate when saving the file.I now do a pivottable.calculate and I no longer have this problem.
![gembox excel pivot gembox excel pivot](https://crackstudio.org/wp-content/uploads/2021/03/download-2-1.jpg)
I think the fact that I didn’t execute a pivottable.calculate when I save the file (in a new session) to PDF was making me think there was something wrong with the file, because it then used the old data. I do not have to calculate the pivottables when saving the file.