In a Excel report, a column has leading and trailing hidden spaces
In a Excel report generated through SQL and XML data definition file, a column ITEM_NUMBER has leading and trailing hidden spaces/question marks/ascii characters added after adding
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?ITEM_NUMBER?>
</fo:bidi-override>
to solve a former issue where an ITEM_NUMBER like 00.123-00.00 was displayed as 0.123-00 even if the output was in varchar2 in the data definition file.
However after adding the above script, the Item number had leading and trailing hidden spaces/question marks/ascii characters.
- Is there another solution than adding fo:bidi-override to solve leading and trailing zeros issue?
0