BIP Report: Excel template allows only 3 formatting rules

Haribabu Ch Trinamix

To apply colors in Excel template We have created Formatting rules, but template allows maximum 3 formatting rules. Is there any way to add more formatting rules.

Mallikarjuna Kuppauru-Oracle

Hi @Haribabu Ch Trinamix

Can you confirm are you using Excel 2003 version as Excel Template? you can use the 2007+ version to apply more conditions.

Refer - https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#BIPRD2747

Regards,

Arjun

Sandeep S. Chauhan-Oracle

Hi Haribabu,

This is Microsoft Excel limitation,  In Excel 97-2003, you will see the first three conditions only.

We have perquisite for designing excel template in documentation

Workaround- Please see the advanced features from the following doc for Border and Underline Styles -

https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/use-advanced-publisher-functions.html#GUID-0632CF5B-753A-4583-966B-1C75C7B45A17

https://support.microsoft.com/en-us/office/conditional-formatting-compatibility-issues-ef68c97a-1b5e-47eb-9b3f-a548f941df4f?ui=en-us&rs=en-us&ad=us