tag:blogger.com,1999:blog-4715885911366291269.post2448883683241698026..comments2023-10-08T06:18:19.211-04:00Comments on Oracle Applications - Suresh Vaishya: BI/XML Publisher: Leading and Trailing zeroes truncated for excel reportsSuresh Vaishyahttp://www.blogger.com/profile/04830206267375957769noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4715885911366291269.post-34184482777272256972016-12-31T09:19:35.899-05:002016-12-31T09:19:35.899-05:00Thanks for sharing. It works perfectly
Please guid...Thanks for sharing. It works perfectly<br />Please guide us how to format excel cell as TEXT <br />This cell is format as general, we want't as TEXT formatting.e-Invoicehttps://www.blogger.com/profile/01072448815017239413noreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-75338816279056108142015-06-29T17:17:21.253-04:002015-06-29T17:17:21.253-04:00Excellent Solution. Its works perfectly.
Thanks Su...Excellent Solution. Its works perfectly.<br />Thanks Suresh.V<br /><br />Thanks & Regards,<br />Suresh.RSuresh Ramnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-30972489470732637222015-04-15T23:53:23.717-04:002015-04-15T23:53:23.717-04:00Thx Suresh, it workedThx Suresh, it workedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-32314525856574325372014-11-29T16:40:39.527-05:002014-11-29T16:40:39.527-05:00Hi Suresh,
Thanks for sharing. It works perfect...Hi Suresh,<br /><br /> Thanks for sharing. It works perfectly !<br /><br />BogdanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-16855896964375180672014-06-17T11:24:53.719-04:002014-06-17T11:24:53.719-04:00This is working. But, when we copy the value into...This is working. But, when we copy the value into Oracle Form (Let's say Invoice Number), and click on Find, it is not returning any value. Looks like it is inserting hidden characters on both ends.<br /><br />Thanks<br />Rama RaoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-55843269133622696292013-07-02T10:20:41.744-04:002013-07-02T10:20:41.744-04:00If I changed the Type to "Regular Text",...If I changed the Type to "Regular Text", instead of "Number" and also choose "Force LTR" (same as typing in the code in the post), then it retained trailing spaces for me. So, if you have the luxury to format your numbers prior to pulling them into the BI Publisher report, you can use this method to retain trailing zeros on numbers.<br /><br />Thanks a lot for your help!<br /><br />Note: I'm using Oracle BI Publisher Template Builder for Word 10.1.3.4.1 Build 130Anonymoushttps://www.blogger.com/profile/09401762721141005979noreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-23451753344039545752012-09-05T05:48:51.820-04:002012-09-05T05:48:51.820-04:00How would you get this to work with etext template...How would you get this to work with etext templates?Paddy187https://www.blogger.com/profile/17797037000993804852noreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-47877293199006878592012-07-26T03:59:23.570-04:002012-07-26T03:59:23.570-04:00This comment has been removed by the author.The Luminous One!https://www.blogger.com/profile/11934193615707661764noreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-56028462811997062832012-04-25T03:36:23.855-04:002012-04-25T03:36:23.855-04:00No, this doesn't resolve the trailing zeroes ...No, this doesn't resolve the trailing zeroes problem.<br /><br />I was Expecting to get:<br />1,000.00<br />100.00<br />-1,000.00<br />-100.00<br />1,000.10<br />100.10<br /><br />However what I got was:<br />1,000.00<br />100<br />-1,000.00<br />-100<br />1,000.10<br />100.1Anonymousnoreply@blogger.com