Spreadsheet Document API cannot print a pivot table with an empty cache if this table references a non-existing style

While researching this document, we found two issues - the document pivot table references a non-existing style and the pivot table's cache is empty. We corrected the issue with the pivot table style. However, since the pivot cache is empty, the pivot cannot be printed. Thus, you need to manually refresh the pivot cache before exporting this document to PDF. We've implemented the PivotCache.RefreshOnLoad option, which indicates whether it's necessary to refresh the pivot cache. You can check the property value and refresh the cache as shown below. After that, the document will be properly exported to PDF.

C#
using (Workbook workbook = new Workbook()) {
    workbook.LoadDocument("Measured Scores per Category per Day-22-Cadbury-22_09_2020 08_59-26.xlsx");
    foreach (var cache in workbook.PivotCaches)
    if (cache.RefreshOnLoad)
        cache.Refresh();
    workbook.ExportToPdf("output.pdf", new PdfExportOptions(), "Pivot-Sheet1");
}

Visual Basic
Using workbook As Workbook = New Workbook()
    workbook.LoadDocument("Measured Scores per Category per Day-22-Cadbury-22_09_2020 08_59-26.xlsx")

    For Each cache In workbook.PivotCaches
        If cache.RefreshOnLoad Then cache.Refresh()
    Next

    workbook.ExportToPdf("output.pdf", New PdfExportOptions(), "Pivot-Sheet1")
End Using