Skip to Content
0
Former Member
Apr 26, 2005 at 02:27 AM

Stylesheet used for XLS PreCalculation

23 Views

Dear Experts,

We want to precalculate a Query in Report Agent in XLS format and process further the created XLS document. In the underlying query we use a hierarchy on a characteristic which leads to a non user friendly precalculation result as the XLS shows the Hierarchy totals/subtotals in the same way (samel font/color)as all other nodes.

As we did not find a way to solve this problem in BEx we thought to enhance the underlying stylesheet of the used Webtemplate in Report Agent as the Hierarchy node specific attributes (color/font) can be changed there. But it does not work for XLS precalculations - the stylesheet change does not take effect on the XLS document!

Questions:

1) any other idea how we can emphasize nodes on the hierarchy?

2)or where is the standard SAP stylesheet for XLS precalculations?

Rgrds,

Markus