When exporting the pivot table with the output file being PDF, the table is empty

When exporting the pivot table with the output file being PDF, the table is empty:

(excel output)

(pdf)

Template: Template.xlsm

Troubleshooting of the client:

I summarized the troubleshooting that I created for myself. Maybe it helps you, too.

Troubleshooting on pdf rendering

• Only use fonts that are installed on the machine where Jira is running

• Creation of data (scraping the issues from Jira)

              * Only populate cells that really influence the pivot calculation.

              * It's crucial that other cells are really empty. Don't use values like 0, an empty space, "" or FALSE by using IF statements. Then, the pivot rendering in the pdf fails.

                            * For example, populate the "sampling points" with values of 0 or 1. Other cells are left empty. By this, a (cross) correlation can be created by later filtering which also shows up in the pdf.

• Props

              * ${prop(xporter.document.autofit,false)} → Otherwise cell height is not taken from Excel properties, but readjusted in the pdf

              * ${prop(xporter.document.keep.style,true)} → Had no visible effect

 

PivotTable Fields (Field list menu - right corner)

• For simplicity of the matrix, use "Min of [Value]"

• In "Value Field Settings" (right-click on "Values" field) select "Summarize Values By" Min

              * In "Show Values As" select "No Calculation". The result of any other options here, did apply in the Excel sheet but not in the resulting pdf.

 

Pivot Table options

• Data → Refresh data when opening the file

• Layout & Format

              * Preserve cell formatting on update → checked

              * Autofit column widths on update → checked

              * Display fields in report filter area → option had no effect