Pivot table error when exporting to PDF with 3 pivot columns

Question

When using a pivot table with 3 pivot columns, exporting to pdf fails with an error in the

PdfGridRow.prototype.measureHeight function on the line:

this.grid.rows.getRow(rowin + j + 1).cells.getCell(cellIn).hasRowSpan = true;

Here is the sandbox example:

https://codesandbox.io/s/syncfusion-pivot-3-columns-556uu?file=/src/components/Pivot.vue

Manikandan Murugesan · Answer

Hi Bill, 
 
We can be able to reproduce the problem and we are analyzing the problem at our end. We will update further details within two business days (November 18, 2021). 
 
We appreciate your patience until then. 
 
Regards, 
Manikandan

Manikandan Murugesan · Answer

Hi Bill, 

Still, we are analyzing this at our end, and we will update further details within two business days (November 22, 2021). 
 
We appreciate your patience until then. 
 
Regards, 
Manikandan

Bill Naples · Answer

Please note also that since version 19.3, pdf export also fails with two pivot columns. This is the stack trace:

TypeError: Cannot read properties of undefined (reading 'column')

Render.getValidHeader	@	render.js?5571:1803
	Render.pdfColumnEvent	@	render.js?5571:1824
	Render.pdfHeaderQueryCellInfo	@	render.js?5571:250
	Observer.notify	@	observer.js?6607:101
	Base.trigger	@	base.js?54ff:190
	applyTextAndSpan	@	pdf-export.js?2c17:481
	recuHeader	@	pdf-export.js?2c17:509
	recuHeader	@	pdf-export.js?2c17:502
	PdfExport.processGridHeaders	@	pdf-export.js?2c17:514
	PdfExport.processGridExport	@	pdf-export.js?2c17:242
	eval	@	pdf-export.js?2c17:171
	PdfExport.processExport	@	pdf-export.js?2c17:170
	eval	@	pdf-export.js?2c17:150

Attached is a demo.

Attachment: SyncFusion_19.3_Pivot_PDF_Error_1c9757c1.zip

Manikandan Murugesan · Answer

Hi Bill, 
 
Thanks for the patience. Please find the response below. 
 




Query 

Comments 


When using a pivot table with 3 pivot columns, exporting to pdf fails with an error in the  
PdfGridRow.prototype.measureHeight function on the line: 
            this.grid.rows.getRow(rowin + j + 1).cells.getCell(cellIn).hasRowSpan = true; 
Here is the sandbox example: 
https://codesandbox.io/s/syncfusion-pivot-3-columns-556uu?file=/src/components/Pivot.vue 
 

We can reproduce the reported behavior at our end. We have confirmed this is an issue from our side and logged a bug for the same as “Pdf export is not working when stacked header have inner stacked header”. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technical feasibility and Product Development Life Cycle) and will include the defect fix in our upcoming patch release which will be rolled out on Dec 1st, 2021. You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 
 
FB Link: https://www.syncfusion.com/feedback/30524/pdf-export-is-not-working-when-stacked-header-have-inner-stacked-header  
 


Please note also that since version 19.3, pdf export also fails with two pivot columns. This is the stack trace: 
TypeError: Cannot read properties of undefined (reading 'column') 

This is a known issue and we have already fixed this issue. It will be included in our upcoming weekly patch release which is expected to be rolled out next week. 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Bill Naples · Answer

Thank you Manikandan.I also just observed that PDF export has the same error with even 1 pivot column if there are multiple aggregate column values. I assume that's included in the fix you noted is coming out next week.The error is in Render.prototype.getValidHeader on the line:                if (!isNullOrUndefined(args.gridCell.column.customAttributes) && this.parent.dataSourceSettings.columns.length === 0 && this.parent.dataSourceSettings.valueAxis === 'column' && Copy

Manikandan Murugesan · Answer

Hi Bill, 
 
The reported problem has been already fixed and will be included in our upcoming weekly release. Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Bill Naples · Answer

Thank you Manikandan.

Manikandan Murugesan · Answer

Hi Bill, 
 
We are glad to announce that our weekly patch release V19.3.55 is rolled out and fix for the reported issue has been included in this release. Kindly refer to the following sample. 
 
Sample: https://www.syncfusion.com/downloads/support/forum/170400/ze/SyncFusion_19.3_Pivot_Refresh_Error1571970895  
 
We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance. 
 
Regards, 
Manikandan

Bill Naples · Answer

Thank you Manikandan. Yes I've tested that it does work now with 2 levels of columns but not 3. And you've already noted that the fix for 3 columns is coming next week. Take care.

Manikandan Murugesan · Answer

Hi Bill, 
 
Thanks for the update. We appreciate your patience until then. 
 
Regards, 
Manikandan

Manikandan Murugesan · Answer

Hi Bill, 
 
We are unable to complete the issue (“Pdf export is not working when stacked header have inner stacked header”) as planned due to its complexity and currently we are working on this with high priority. However, we are planning to provide this before Dec 15, 2021 patch release. 
   
FB Link: https://www.syncfusion.com/feedback/30524/pdf-export-is-not-working-when-stacked-header-have-inner-stacked-header  

We greatly appreciate your patience until then. 
 
Regards, 
Manikandan

Bill Naples · Answer

Hi, Has this issue been fixed? Thanks.

Manikandan Murugesan · Answer

Hi Bill, 
 
We are glad to announce that our Essential Studio 2021 Volume 4 SP Release V19.4.48 is rolled out and fix for the issue “Pdf export is not working when stacked header have inner stacked header” has been included in this release. Please refer to the following sample. 
 
Sample: https://codesandbox.io/s/prod-paper-d2f2t 
 
We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance. 
 
Regards, 
Manikandan

Bill Naples · Answer

Thanks very much Manikandan

Manikandan Murugesan · Answer

Hi Bill, 
 
Please let us know if you have any other queries. We are always happy to assist you. 
 
Regards, 
Manikandan

Query	Comments
When using a pivot table with 3 pivot columns, exporting to pdf fails with an error in the PdfGridRow.prototype.measureHeight function on the line: this.grid.rows.getRow(rowin + j + 1).cells.getCell(cellIn).hasRowSpan = true; Here is the sandbox example: https://codesandbox.io/s/syncfusion-pivot-3-columns-556uu?file=/src/components/Pivot.vue	We can reproduce the reported behavior at our end. We have confirmed this is an issue from our side and logged a bug for the same as “Pdf export is not working when stacked header have inner stacked header”. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technical feasibility and Product Development Life Cycle) and will include the defect fix in our upcoming patch release which will be rolled out on Dec 1st, 2021. You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. FB Link: https://www.syncfusion.com/feedback/30524/pdf-export-is-not-working-when-stacked-header-have-inner-stacked-header
Please note also that since version 19.3, pdf export also fails with two pivot columns. This is the stack trace: TypeError: Cannot read properties of undefined (reading 'column')	This is a known issue and we have already fixed this issue. It will be included in our upcoming weekly patch release which is expected to be rolled out next week.