Force alignment on headings on chart for excel export

rated by 0 users
Answered (Not Verified) This post has 0 verified answers | 1 Reply | 2 Followers

Not Ranked
Points 70
Kjetil posted on Tue, Feb 9 2010 5:27 AM

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

All Replies

Top 10 Contributor
Points 5,957
Reply
Answered (Not Verified) Rakesh Mehta replied on Tue, Feb 9 2010 11:20 AM
Suggested by Rakesh Mehta

Could you please post a sample qvw here?

  • | Post Points: 1
Page 1 of 1 (2 items) | RSS
Forums » QlikView Product Forums » QlikView Desktop (Developer/Professional/Analyzer) » Force alignment on headings on chart for excel export
Share
RSS Feed
Feedback Form