Using LTR in BI Publisher appending '?' in excel output file
Hi ,
We are using R12.1.2 application. In that we have requirement that we need to create excel output file using BI Publisher.
As we need to display code combinations which has values as '00000', but the excel will truncate it to '0'.
So we used LTR option but while coping the value we found that LRT is appending '?' in excel output. Is there any other way we can achive the desire output like '00000'.
Note: We also tried having space after the field in BI Template but the same space is replecating in excel output also. As we need to copy the output for some other purpose, no space is allowed.