SATYA RANKI REDDY OBIEE SOLUTIONS

Issues while Exporting OBIEE Answers Report to Excel

 

 

 

You can try adding the below statement in the Custom CSS section of the column properties.

mso-number-format:"\@"

Same above problem other solutions;

'<span style="display:none">&nbsp</span>' ||  CAST("- Vb D Prev Pol Insurer Details"."Prev Pol Num" AS CHAR)

Note : '<span style="display:none">&nbsp</span>' just add it this  fx function like below.

Thanks,

Satya Ranki Reddy