Conditional Formatting in BIP excel templates giving java.lang.NullPointerException

Question

Summary

Content

Hello,

I need to fill a column with 'Yellow' color when the value is equal to "TRANSLATE", i.e conditionally format the column.

I used excel native conditionally formatting and is working fine, but whenever row count exceeds around 14000 the report is throwing error "java.lang.NullPointerException".

Why is this happening?

Or can anyone please tell me how to achieve conditional formatting using XDO_METADATA sheet.

Thanks,

Srikanth.

Saurabh Jindal · Answer

Please help us resolve this issue, even i am facing the same.

Conditional formatting is not working for more than 13K records in Excel Template.