WAD Settings for EXCEL Export format discarded ?

[Former Member]

Hi everybody,

I try to adapt a copy of the template 0ANALYSIS_PATTERN to fit our users' needs when it comes to standard exporting to EXCEL.

Now whereas PDF printing works as intended including manually set paper size, orientation, most settings of the export command seem to be ignored by XLS format (execpt for B/W instead of SAP color scheme).

Is this as intended or do we need to apply some patch ? As I heard, BI 7.x does not quite like to work together with EXCEL 2002 which is our company's licence of choice.

Hoping for any hints and

with kind regards

Dennis

[Former Member]

Sadly, there seems to be no option...

[Former Member]

Thanks, but does this also apply to the other settings mentioned (header / footer, paper orientation, horizontal fit etc.) ?

Actually I hoped I could avoid setting up an according Analyzer worksheet for each query (view) we need to be displayed as a table.

[Former Member]

I am facing the same issue. Any other thoughts?

I am not getting the header/footer, paper orientation, or image location to show up correctly in excel as it has in PDF form.

Thanks!

Jon

[Former Member]

Hi,

You cannot set a size for converting to Excel, as you can do while converting to PDF.