Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Force alignment on headings on chart for excel export

Hi,

I'm trying to force a right alignment on headings on a pivot table. I've tried setting all the usual stuff for headings in the 'Presentation'-tab on the chart.

Label - Right
Data(Numeric) - Right
Data(Text) - Right

Excel does not seem to read these settings when you use the 'Sent to excel' button or when you do the normal export to a excel file.

Is there any workarounds? I've testing the export to both Excel 2003/2007 and it does not read these settings in either of them.

Maybe I could force these settings in a Export Macro type? Any idea's would be appreciated.

Kind regards,
Kjetil

1 Reply
Partner
Partner

Force alignment on headings on chart for excel export

Could you please post a sample qvw here?