Skip to Content

AFO - Formatting

Aug 25, 2017 at 04:15 PM


avatar image

Dear experts,

we are working with Analysis for Office version on SAP BPC Optimized.

We would like to dynamically format one report and we defined the excel styles.

In order to apply the formatting to the report, we need to manually link each cell to the corresponding style (cell by cell).

In any case, all the rules we define got deleted every time we reset the datasource.

Is there any way to define the formatting similar to the "EPM Formatting Sheet" of the EPM Add In?

Thank you in advance,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dorra KHEZAMI Aug 27, 2017 at 02:48 PM


Please see if SAP Note :

2205157 - protecting EPM sheets, editing AO styles is relevant for your case.

Also it would be good to test with AO 2.5



10 |10000 characters needed characters left characters exceeded