Forum Discussion

HamzaJ's avatar
HamzaJ
Data Integration
05-10-2023

Changing fontsize in pivot2 breaks PDF-export

Hey, So I used the following widgetscript to alter the font in a pivot-table. In the dashboard these alterations are visible, however when exporting it to PDF the pages are all blank.   widget.tr...
Code-first Analytics
Sijo1995's avatar
Sijo1995
Cloud Apps
05-11-2023

Hi HamzaJ ,

 

Please try this script

widget.transformPivot({
	type: ['member','value']
}, (metadata, cell) => {
	const { columns, rows } = metadata;
	const isRowHeader = rows && rows.some(row => row.title === cell.content);

	// is header
	if (isRowHeader || columns && !rows) {
		cell.style = {
			fontWeight: 'bold',
			color: '#132f57',
			backgroundColor: '#e2e9ec',
			textAlign: 'center',
			whiteSpace: 'normal'
		}
		
		// is row
	} else {
		cell.style = {
			fontWeight: 'bold',
			color: '#132f57'
		}
	}
	//cell.style.whiteSpace= 'normal'
});

 

Thanks

Sijo