We have a requirement to dynamically hide a column in the excel report based on what input parameter the user selects. . I am guessing it should be done using <xsl: if test…?> clause, but not sure of. Need some inputs on this.
Hi @Reena Agrawal
Thanks for using Oracle Communities.
Yes, you can use the if condition to hide the same . Refer below MOS doc -
Display or hide columns depending on the parameter selected (Doc ID 2539753.1)
Regards,
Arjun
Thank you for replying @Mallikarjuna Kuppauru-Oracle. This looks like the code to be used in rtf template. My requirement is in an Excel template.
Conditional formatting is not supported in excel templates as its done for RTF. You will have to go via RTF route for conditional formatting requirements.
Thanks for your response @Abhilash K - Deloitte USI .
