Skip to Content
Former Member
Jan 23, 2009 at 12:08 PM

Printing issue after export from portal to excel 2007


Hi experts,

I would like to know your opinion on the following problem. User is exporting BW report from portal to excel. He wants to print. So in page setup he sets orientation to landscape, and sets scaling to fit to 1 to 1 page. In spite of this the actual report is displayed only on 1/4th of the page in the left, the rest is blank. We are using MS Excell version 2007, BW is 7.00. Can there be any more invisible collumns exported which case this problem with page setup?

Is it even problem of SAP?

We found that in page setup screen in Excell, in the last tab called 'Sheet' there is an option: 'Collumns to repeate at left'. The original setting (after exporting from portal) is the first 6 columns, which is not even the whole report. When we delete this problem is solved. But the question is - can this be deleted by default? How to do it?

Thank you,