Printing issue after export from portal to excel 2007

31 Views

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,

Michal