Leading zero issues/ Number Formatting while opening in Excel
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.
A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code
Before:
<?STAT?>
After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAGnCAIAAADOrjKEAAAgAElEQVR4nO2debTbRqH/9fd7j8eDt2/saymUNRfsUi5QwoVSoGwB3OIaKJAu6RKni7v41mmTJk16s11nU5yk2W8WN20ap+5NHEraOG2h5qFQoLzcNi20j/V3Dn9z9PtjtIw0I1mbJVnz/Z7PyXFkaaRrjz4ej+QZSUUQBEEyFynpA0AQBEGiD+SOIAiSwUDuCIIgGQzkjiAIksGYcld6XQAAEJzR0dEEjRxhLHJP8DgQBEESz/j4eGblnvjHJgAAJEXG5T5O5U4mNSYLmdzF5G4mi5gsZnIPkyVMljK5l8kyXpYzuY/JBJMVTFYyWcVkNZM1TCaZ1Jms5WUdk/VMNjDZyERmsolJg8lmJluYbGVyP5NtvGxnsoPJTia7mOxmsofJFJO9TPYx2c/kAJMmLw8wOcjkQSYPMTnE5GEmh5m0mBxh8giTNpNHmUwzOcrkGJMOL8djD+QOuUPukDvkDrmnPZA75A65Q+7plbsvnY2OjobZCnKH3CF3yB1yj0/uvrrLw2wFuWdL7tsfVnpd5dGttNx3PtpVet1jOyB3yB1yT53cJSqQu0uc5L6+zb4QJ3au8CF3+dFeV+k9uMUm9y0PWcvcMxmt3LcdspT/+NT25jGl1+0214aW+7ZjZsmHd7vJfXun11V6ralVq1atWtV4qKP0uk8+tAlyh9wh95Byp51u87uT3NmPAXqJgHLXsmJqWul1T07d57/l7ir3I5sG1XIncm9vibrlTsz+8O4VK1asIO7W/N5X7mi5Q+6Qe4Jy976V8HJvPGhpy9dqm490lV63u3di4cKFK/dOK72ucmLXgSN0q//Bra5yn9x/1Fi5e2D14sWLF0/u6fa6yuNT9fsPKb1D2yanur2u8vjRrrbaoe336y30x6fWust9+yGi72XLli3bTrXrH9+73ip34nQDWu4bD3aUXvfUwXWktb7pwY7S6556cMMKef8p+ovCEwcaK1dOTdPltKZ2t5ReV5nesXr1atKKJzx5aNOaNWvW7Gkpva5y8viTZPnJ5pbJycnJyb1Hu9SaDcgdcofcnXzdV+6Kt84cseU+sbPb63b3TtRqNWJ54vTNR7pKb/rAio2P9rrKiV2rPHfLdPevWkSWPNJYvHjxtke6Sq87vdWQO7G5Lvfeoe1LlqxtHlN6XaW9ecmSJdvbXaXXnd7m2C3TbdZNua/b2zX6Z7YfUnrdUw+sNeWuPbif23LfNU2W6H3uuw4rva4yvV2T+xMHGitXNjTjb7S33A257zEtP3W0q/S6x/cYcm9u0YV+fGpyy6HjtNPRcofcIXd3s/eVu5ethJY7+a+FIxsWLly4cOHEgRNaI32zz26Z+4nQtyxavHjx4q2HNNETufcObSPdMVrLfWqtLvduc42b3Hkt9/XkU4HGdPpWQ+iB5b5SX+gkd9KiP75n9erVqzWnH91pPJhk5G5rtkPukDvkHljuaLl7krvWcrf0uW98tDcAuT8+VY9a7saVVVufu7vc+3TLRC33ycnJyakjZhU8ugtyh9whd3fQ526Lz26ZTQc1g1vlvvkI0brnbhm6z92tWyZKuesd7od28OS+/oFjSq976oF1/i6oUnLfM91Vet3OLuaCqpduGVbu5ILqluaTkDvkDrmHaLnjbhnPF1RX7OxSL1N37wbSIfNoYyF9QXXVXXet2mdcJg1xQTVCuS9bRrrdjX1Z+tyXr33oCUtd8XQrpO2C6vR2cp87deHU2wVV524Z5WRzK7plIHfIPVy3jJf2vlhyz/6PmEL+QpXulsGPmCB3yD2V3TKQO+QOuUPukHvq5D7uObTcA2wFuUPuGH4AcofcY5L7qM+E2Qpyh9whd8gdco9J7nEGcofcIXfIHXKH3NMey439KqbZAwAIDJG7lI28/Je/EhTIHQAgNkTuhhVDQgt2oHB3BLkDAIAG5A4AABkEcgcAgAwCuQMAQAYx5X56wyh1bXLuYeLJo3MlSbpww1ORyD2KXUDuAADQHyL3p9bMliRpdM0ZXY9H50rz90cq96h24UHuh+crkDsAQGyI3EclSZp3lKfRiORO2uxR7KKf3E9vGMV97gAA4THuc9c7SQYj98Pzo9pFP7kfni9B7gAA4bHJff88o0s8ym4Z0icTyS76yJ3sSYlN7nKB/CklecBFtSr5XKXtvgQAAHR4Lfczyy8coNxD7iKs3G0/as1Xm55eKb5J6yVppNaK5J3Qi3JSNuQOAPADr889erkzfe4Dk7unPvcAWuRu0qrkpUIjkneib1GQOwDAD0TupKtEv5VlAHLXe2PC76Kf3P/y16fWzFZ8yb1VyWvteNIMr5eMFn2rkpdGaq1mLce29Oslo/2fq7TNQgoNfRe1oiRJhUarks8VSjnS5aIVZe17oYoipbFHZRyzuVxfEwAAGMz73A/Pt/RXaLY9OpezMIjco9pFf7m/3Pc+d4vc6yWjyWwRaKHRa9Zyeq+LU8tdW1gv6b5uV0ekYp0oWDO49glBetX1B07NcO0Bc1TmcqpYnty9T9qCIEg20kfuUdBH7tERndzphrDR7iaOptvp7nK3F0ha69QS22oufSyGym1HZVG8m9zjH2oZQZBkA7k7yJ3buSEXEpY7dwUvRw4AAJA73aNCQXpFqJthuBc83btlwsidPSpzuXZI7eoI+twBAE5A7uwlSkqscsHoqGkUbRdUnbp3zAuqIeTOHJWxXL8dPl8soOUOAHBCSLkDAEDWgdwBACCDQO4AAJBBIHcAAMggRO4BfiPqU+5BfoYKuQMAQEAgdwAAyCCOcqenxItgbBme3J12YS4ng89A7gAA4BMHuR+dK+mDOLpNohRG7k67oJYfnk9Nywe5AwCAZ/hyt0ycRI/gGJ3cnXbhNmcT5A4AAN7gyt02t8b+edHL3WkXzLQekDsAAPjHg9wH0nJ32gXkDgAAEcDvlqE7wQfU5+60C/ox+txBZvE++y6G/wSBMOVuu3GFvpXFm9n7y93jLow5PZzv0olc7uZcS0a8Tq8KAME6Cr+rtf3Mvusy3pzTQi+lgayDX6haQdUHgWFGCXX0u6/ZdyF3EAjI3Yql6jdrOeP8rJekkZpszoYqWWbRI6EHf/fcLgOZgR1KmjsdrnX23UZ1RKKfZQeL1pZwJ/K1LvQ7GzAqaqaB3K3Yzk+5IBXr5gP6ZNCGeneaghXnjHjYG8XGlC+8GsI2n406xpe7l4l8fc4GjIqaaSB3K/zzs9soSiWZncJppCbzp2AFIsKtPNxJep1m8eXOpOhR7mFmAwZZBHK3wlT9RlEqyXqbiCt3nCqAwO2W6W9ka5s6jNwDzwYMsgjkboU7AR7dcWk8Kxfsc/JZNsG3XfHgz83rUEMYI2uT4lLXWs0llj4Wpihtof/ZgFFRMw3kboXTrrH2V7I9MPYpWHHOiIqlelAVgFtD9GpG5uaVqElx2/olVm0Js7LtJl1zod/ZgFFRMw3k3g+thd5VevhKCwAYGlIk99MbRiXJ6Sepicldu5RK/tuqSEwSfwtBykGdAYngR+79B5nxKXdrgemUOwAADCMpkrsf+HLXCjo8X4HcAQBio8mdnfzIGOBFG6ORiFiLr/G8XvZYYOgRyrTBJPfPkxTIHQAgNubAYfRAjKc3jGqDdtGN6xAtdy8Fhpf76JozpFAlkNzHEaRf3OtV0keHCBoXuUvOQ6hTM3VE0y3jWGB4uUsXbnjq9IZRKbjc2WtfCGKkb71CFULij1OddJL7/nn01hHIvX+BEchdmj133mxJmh1G7ioiTHxVj9HRUY9yT/rPQgSKS53kyp2eDimSlrunAqOQuyRJknThBsgd8RJST7yEnCeQO5K29JW7adXD80fXnKFcTCbZ0PzbdzJVD3J3LjCCC6qSJEnS6JozkDviJd7rCeSOpDN95c5MfmTeyjJ33ny7f4PcLeOhwPByNx5B7oiXQO7IsKe/3D34NLBzB8HwyH1GHhuTZyIuFIkmkDsy7IHcfcp9Rh4zL/6Gc7NfuQ96fYQK5I4MeyB3/3I3jDkjj0nlTuDXHnJPcSB3ZNgDuYeQu9opG3I3W/T603Qbf0yesX0qUEuoFfX/j8lyWZIsnxzWHdh31ykbO56Rx7T9RfL9QtDQ9UTiBXJHUh7IPYTcO2VdnFbLj8kzaqdsuNmqcv4So8Byh4ib843AXJ/dnfE1gioULfcQsdUTJ7ND7khqA7n7lzvb5W7piJckqdxxV7ltiUsbnw53fUmiP0Qs7XTIPUTYesI1O+SOpDaQe9CWO93hzm2De5S71ovisCYdetfcFTplyD2qcOsJa3bIHUlt+sp91PNA6oLJXVWprheqE0Y1nmOUTTexabnTvfTucnfcnar31Vj3G+Z6r9jxXk8gdySdgdxDyF3rCbFfFaWucVqWGKuMlcu01o0VbcvZkDWtF1TJ/ynd2x7igmqgQO7IsKev3Afq3CGUe4BQlz+RYQnkjgx7vLTctd/9m7N2GEMRRCR3bsmnN4xK0tzDZMAZyfusTGmRO9Vwh9qHL5A7MuzxLPej5qwdfkZ68SB3h5I148/f/xdtqqYk51DFmSlaIHdk2ONV7ofnS+bYv0EmOHWUu1PJlo8Q6gMAckdiiOJn7iSPcvdb6wAIiVOdpOVOj7r+socBfr3L3bFkyB1JMKM+07deJf0HIYLGp9yjbLk7lpw2uSf+IQxSToB6BUAiWLpl2N7wqPrcnUpOldwT/vBFhiSJn7QAeMHtbhmfZneTu1PJqZI7AABkBtznDgAAGQRyBwCADAK5AwBABoHcAQAgg0DuqaRVyecq7fSUAxJBLpAbEEpy0kcChhDIXadVyUuSVKwbSxpFSfJoxsgdGrJAY3PIPT6atZxkS77a9LQt/22ql6SRWivSg0R9EAnIXadVyecKpZx+OrUq+dxIYmcC5D68BHjNuZu0Knmp0Ej82MDQArnrtCr5XKVRHSGtrUZRKlW1M6FdHdGbYkT99ZLRKGtV8tJITa7kc5W29vFAvkdr7biSbD2jWq5rWg9GszO961Yln6vUipLl27q5DvmqYTYh88WCw/pRNwkB+94Z/3WvPC3q/TJb+vUS/Z6ahRQaPboaFBrOdYmpt9YdoRpkHchdRzsn6yXthCEKtjZz5ILWb6O1qpq1nOnctnG2yAXJeGArx31N7sHYN9QdrW1SL9HWtjXYOetD7gPGUm2Yd7DHVB77Jmw55lvcro5Ixbrlbe1bl3rWektXRVSDTBOX3I0R27UYg4ilTe7dRpFpcdubxl1FbxaZTTBa4rYH/JY7b03bwdD7lYxmmkNR3NK4z4KBYheo9R3sMZXH6a1xehO51cDpga3eog6IRKxy1+foIOOIhZnYb4ByN/s6ba3snvXckAtxyN12KrJF0c00yD0NeHnN6crjtFpIuXPrLeqASBhjywSYDimw3PWBIWcvP/3Xl/9iGXbGY4t+kHK3LaGWt6sjuknJ1239foa+cqebbN7lTne5sAdprsM7h+nPpx77LL6PDwx7twx7I6O18tDvF78cXreMF7mz9ZbeEapB1jEHDvM/HVIIudODAJvjhT21ZrZp/LTIXe+okfTrkxbnygWJ7aNnHhiXtrQSvMqd+WbNPav1u6HpXiNyzPoBs2XirB4Y7FtpeXeYykO/X/Stk/zuHdfPbOsDpt5ad4RqkHXso0L6GZoxGrnTkzSd3jDq7aNlAHLPAMZ1MwCA8CQud/KATmJylxyS+JvkjtFAkyK/LRokxxDVQJBOEpK7ORmTbQa+MDsSvuUOAAA6icjdcrdMdFM+Qe4AAKARq9ypWJrqh+dTzyR1QRUAADIEfqFqeS0QxD3u9Srpo0NEjFOdHIfc6dfC6ZoqgkiS1LdeoQohMcelTkLu9jPTdeJ7RNyMjo56lHvSR4oMcXwpy71OQu44M4WO97oBuSMxhNQxL+lbJyF3nJlCh60GEu++csgdiSfe3QW5D0zuM/LYmDwT7Rs7iDIR17BmN7oyIXck/kDug5S7zbBOwiXL3XVsPOvR2pB77OGanfU75I7EE8g9NXL3+I5B7mmN97oBuSMxBHKPXe4z8tiYLJe1Nl25Y225z8hjY+XyGHlqRh6zrqNqSyRJYv+n7cJoLkLu8cb73cSQOxJD6DrmdO8j5B613ImvVVXtlCWL1smzY/KMqnbKkvGA7rQxy+yU9WL0hZ2yUTJa7vFm1Gcgd2TQsdWxMF2Fscl9/zzt8MyBB8w5OnxPD5JMy32GXWJ71vaAu9zyZpU7bMlxVCHEdyB3JIawdYxr9hTJ3Ry0/czyeWT4MGoQm8Pz/U4PMsxyt+kbck803usG5I7EEG4dY82eNrlbxiOj5+iIaEdR3QpJulS013pGHpPKHY6C/cpd63qhOmG0mLszeneQ2AK5I6mKd3elRe7aAO6Sofhgw7jHI3feFc6QcidSt19Q1QvvaBdqx8pltNxjjq19FLh/E3JHIskQyp1W/Ozlp1Mud0SY2OpA4P5NVCEkkgyd3J9aM5t4fP88Te6WOTrS1eeOiBS2GgTr30QVQiLJ0MmdnqzDbK0bc3RQc6tC7kiswX3uSKqi+JkVIB1yjxjIHYkguM8dSVsirJOQu+W18LsJEA33eoUqBOIHcvf0GiFI36AKIWkL5A4AAKIAuQMAQAaB3AEAIINA7gAAkEEgdwAAyCCQOwAAZBDIHQAAMgjkDgAAGQRyBwCADAK5AwBABoHcAQAggwgn97w5085IrZX8GwAAAINAPLnnKm3yuFXJS4VG0m8AAAAMAoHl3quXiNxbFYvxc5V2q5LPVWpFrYVfkqkSWpV8rlDKkeXNWs5coV0dYb4T1Ev6olLVKFPfqfYM8wFje8rlYAAAwAGB5S4XJPKYK3dDo8ZqxgrE3XJBMh7QK5BNinWl16zlKBfTZfbqJfojoVinjpB5yuVgqHcRQRBhA7l3FbrP3SZ0m9y5z9L/5T6gC3fakH1MN97Zp1wORif+8aMRBElPIHeq5U4rNRK5Gy16biEDljsAANgQVe490q9idH9rem1XR+yNbu9y11fTCmG7ZSzd/X66ZSB3AIBPBJa7dgl0pNYyr4Xmi4XA3TIN/ZqnVkjP0lFDLqha++59XFCF3AEAvhBO7gAAIAKQOwAAZBDIHQAAMgjkDgAAGQRyBwCADAK5AwBABoHcAQAgg0DuAACQQSB3AADIIJA7AABkEMgdAAAyCOQOAAAZBHLXoUdjd5lhFUN3ASe8VCF24DkABgPkruPxZMM5CZzwVTdQkcCAgdx12JONM3mpNmmqMa6vPicqPXR7vUSabPT0HUAEOL6ulyQpX21qz0ojNZmsQ1WkahNVBQwCyF3H9p3aaSZV66R65lwc2ryp1AOcsaLBVqGeMRVMs5bTP/K5M/eiqoCogdx1HFru9lkyHPtM6yWp0Oh1G0XK+EAoHHpayFQwZvsdfe4gFjIldyNKAnInWtcUn/j7ChLAyddyAXIH8UPkLmUjx48fP378ONH6AOXOzn5nrGOcwz181xYPvq/J5z11JYY7RTuqCogaIvfj3qL2iyRJ3OUey/e4F6cdhZa75ZPCuPalP6s/JnOlmhOlmuj9qmaBOGNFgnMrpDnduTYhO1uRcEEVDAbIPTqMi64AAJA0kHs0sH1Eib+1IA2gYoCkyJTcpVkLdifYcgcAgNQQl9x3L5glzZlgSpyYY7ZoZi3YDbkDAEAkJCj33QtmSdSyiTkS+S/kDgAAYUlO7hNzjLY6Zfs5E8nJfRxB+sW9XiV9dIiIcaqT40nJnddPQ3yfpNz93VePCJa+9QpVCIk5LnUyMbmzDXd9pYTl7mX3SDbiq3qMjo56lHvSfxYyxImwTiYp93S23L3sHslGSD3xEnKeQO7IoBNhnUxM7pymu+Z7L38X5I5EEO/1BHJH4kmEdTI5uZu3x5j/1eUcbEeQO+IvkDuStgyp3M3oTXbLUt3zXl4BvtyN7SF3xEsgdyRtGUK5+4iXVwByRyII5I6kLZA75I5EEMgdSVsgd8gdiSB0PXG6iRhyR+JMhHUyg3I/fvw45I54ia2eOJ1FkDsSWyKsk5A7zkxxw9YT7lkEuSOxJcI6CbnjzBQ33HrCnkWQOxJbIqyTkDvOTHHjvZ5A7kg8ibBOZkrukqTdLQ+5I14CuSNpy7DKnZqagzNxR3i5Gz9zhdwRL4HckbRlGOVunZpj94JZjnr38go4dsuQEWsgd8RLIHckbRlCufMGgRyA3LXdQO6Il0DuSNoyfHJ3mEI1Yrkbg9ZA7oiXKH7mToLckRgSYZ2MSe68qTmil7vx9QByR7xk1Gcgd2TQibBOxif3GFruxiDxgeXudxMgGu71ClUIxE/CcvfTdA8jd+1TxOUPdn+NEKRvUIWQtCVRubN3yzi63svf4vwjpok5kjQnmNwBACAzxHmfOz01x4Duc9eiQO4AALHJ1C9UIXcAACBA7gAAkEESlTs1HIGZOR3IHQAAQoKWOwAAZBAnuXsx7IDkHvhTBHIHAAANyB0AADII5A4AABkEcgcAgAySRblPRPEL1VYln6u03ZcAAEBaiUvu9K9TbT9Q5TwVXO5klAPFWe55y32XhYaTsiORO72J8RgfEgCAwROn3OmRZSRzHDHOWO+B5d5/VEivYh2c3AEAYPAkIvfjlpmZIpS7XpTiXe50g1przo/UWtzlkmTdtl0dsSy3ldBr1nLa//PVuvm4WMjnKu1WJZ+r1IrawpKsH4x1X/ZdAACAN5KSO2X3COWuDyys+O6WqZekQoOsQ5aYyynz0oZtVfL6Jo1iocGW0HPtlmlV8kbJckHi7su+C86bhyAIki65mwssfe6ksyaE3IO13OkmMy19t36VeomsabreWkJfudue4qxs3QVDsDcJQZCMJV1yH0jLPUCfOyvWPsK1Faj7l/usL7lr7Xd2X30UDwAALEnJfTB97tpYZK53y/D73KkuEfty0oHebVdHLB3frUqp2lR6XaXXrOVGai2mhJ6l68Z87NZO1/ZlrGPdRfLVBQAwLCQi98HdLaOVp4S6oCpJtHzlguVCqLktaVCT66VNhS2h11V63UbRXEF7TF1QtbfT9X3pJTC7AAAAb8Qpdyou97nPWrAbv1CVC1KxnvxhAACGlrjk7i+Cyr1RND7i0MMOAAgF5A4AABkEcgcAgAySKbkbjxTIHQAgNkTuwVTu0bmqH7mH2RHkDgAAGpA7AABkEMgdAAAyCOQOAAAZJD65T8yhfqWkx1io/64pzI4gdwAA0IhJ7rsXzDKkPjGHPCKTJlFDEniag8llR5A7AABoxCh32/gx1NBhQ9wtE8n8SpikCQAQNXF1y5D+F0rmHN0nK3frgOz28R1dtoLcAQDpI8YLqvoAYaRTRp80KU1yDzDfKeQOAEglsd8tow/3y++VSYncjUEZzeY8O+OSda4luSBJIzW5ks8VSjnS9tfmUCVfAszZUKk5WmtFyTLRBymEPCthAHcAQHASuBVS0zq/6R5mRxF2yxCxmvNvtKsjUrHOWWKb7NSQsqFpen4lAvnkoOdQZWZMhdwBACGJR+67F8wyRG402Zm7ZTyN5O6yo6i7ZWxLbHPpGUts7Xrb1Nh9JwMxn8IwvwCAyIir5U7NyEG11+l5OpK+z90+bamDynlLGlq73lnudEvcYZo9sxAAAAgNfqGqY+tzt06s2qdbptdtFKV8tekmd71wbS5W3vVbrZAeumUAAGGB3HUsfe4Ol0/ZJaaj6yV6nlXG8sYsS25zqJJCyIcE5A4ACAHkDgAAGQRyN5GYJP72AABAMOKRe+RByx0AANyA3AEAIINA7gAAkEEgd8trgSB9k/hJC4AXxiF3+rVgr6kiCJ0A9QqARIDcLa9FbH8AMowJVq8ASATI3fJaQO6IS4LVKwASAXK3vBaQO+KSYPUKgESA3C2vBeSOuCRYvQIgESB3y2shSZI8Zr+GNibPeDqoGXnMXLVTNrYvd+xLPBeJpCrB6hUAiQC5W14Ls1yLqb2F3qRT1pRuLu2Udc0jKhQJAHCF/mQapNxnjAa9YWq9+T0jj0lj8ox9DT2G0yF3S8h7hCAIwsb2tWNwcqe8bCyfkcekcodez97YJ7o3hG52y6BTRkUXBwDAmbjkPmPrh9d8TRabpub35HTKdpmzS0SM8R79zVuu/Ju3Xvm3b73qb9921d+97eq/e/vVr3r7Na96xzV//45r/v6d8179znmvPufafzjn2n9413Wvedd1rzn3uteee/1r3339P77nhn98zw3/dN78fzpv/j+/d/4/v7f8L+8r/8v7Fvzr+xf86/tv/LcP3PhvH7jx3z94079/8Kb/+NDN/zHr5v+cdct/jtzyXyO3/NeHK//94cp/f+TW133k1tflbnt97rbX5297Q/72N5x/+xvPv+ONH73jTRdU33RB9c0fq775Y+NvGR1/y+idb/34nW/9eO1tn6i97RO1t39y4ds/ufAdF971jgvveuen7n7n7LvPmX33OZ9e9K5PL3rX2OJzxxaf+5l73v2Ze9792Xve89kl77loyXkXLT3vc0vf+7l733vxve+7+N73fX7Z+7+w7P1fWP6BLy7/wBfv++Al933wkokPfWniQ1+amPXlFbO+vGLkKytHvrLyw19d+eGvrvrI11Z9ZM7q3JzVua+vyX99Tf4ba87/xuT535z86DfrHy3ULyisveDStR+7dO3HLls3etm60W+t/3hx/ceLGz5x+YZPXL7xk6WNnyxtvPDb8oXflj/1nU2f+s6m2d9tzP5u49NXND59xeax720e+/6Wz3x/y2d+sOWzP9j62blbL5p7/0VX3v+5K7d97qptF1+1/eKrt3/+6u2fv2bHF67Z8YV5O784b+cXr911yXW7Lrlu15eu3/2l63d/+YY9X75hz1fmT31l/tRXy1NfLe/92oK9X1uwb86N++bcuP/rN+3/+s37v3HzgW/ccuCbtzS/WWkWKg8Ubn3g0lsfuPS2g5fddvCy2x/81u0PfuuOh4p3PFSsPnT5+Nmq/kEAABmmSURBVKHLxw+V7ny4dOfD364d/nbt8HcWHv7OwtZ372p9964jV9x95Iq7H/neoke+t+iR7y9uf39x+wf3PPqDJY/OXTI9d+n0lUunr7z36FX3Hr1q2bGrlx27ennnmuWda+7rzLvv+LyJ49dO/PDaFT+8bsVj16187PpVj12/6kc3rP7RDatPzF9zYv6ax8uTj5cnH19Qf2JB/Ykb1568ce3Jm9Z1b1rXvXl99+YNp27ZcOqWjU9WNj5ZkZ+6VX7q1k1P3bbp6dsaT9/e+PHtm398x+af3LHlJ9UtP6lufWb8/mfG7+/dua1357af1rb/tLb9pwt3/M/CHf9z186f3bXzZ3fvUu7epSzarSzafXrxntOLp35+z9TP79n77JK9zy7Z9+zSfb9Yuv8X9+7/5b0HfrnswK+WNX+1vPnc8geeu++B5+47+OuJg7+eePB/Vzz0vyseOrPy0JmVh86senhm1cMzqw8/v/rw82taz69pvTB55IXJI2frj5ytP/Li2vaLax99cd2jL62bfmn99G/WH/3NhqO/3XDstxuPvbyx87LceVk+/sqm469s+uH/NX74f43Hfrf5R7/b/KPfbTnx+y0nfr/18T9sffwP9z/xx/uf+OO2k3/cdvJP27t/2t79845Tf95x6v/tfDI+4pU718adsge5s90xAbrzMxjIHXKH3CH3pOWudsoS219OpE01w7WOGvKwbF5aJSsYl1ip1UQO5A65Q+5DJHdfZ/fo6CjRdLCt4pS7tWdmTJ6hdW97aD7P68Shl4gdyB1yh9yHS+6+ussNuQfYiiN3IxHIHRlw0i73e3+hqqrabdJyHz+lqqp6YnlQua96TlVV9emHIXfIPQNyp69DDkju5g5YcUDuqY1d7tWfWZ4+O31RtHJf9HNL+S89dvue36uqenZqMpTcJ36pqqr65INE7gufVFVVPTERRu5HTrIv1stPXzHHq9w/fvmxU6qqqjPLIXfIfWByp51u87uT3NmPAXpJn5Y7Kw7IPbXhy/3EtkG13IncT05F3HKPXu5ay/07D/1JVdWXDu3y23KH3CH3dMrd+1aQ+3DHi9wv2v47Y/3nty97zbuue+2lR59XVfXssYsXnlbV07d8q/OCqqov/u4Fba2fV+7WW+gvHr/kQ65yv+dZVVXV7r7X5297w5JnzSN76cRXrXKvnrIcuVe5r3jO3OY33W/Rcr/h1It0ib99suRF7uvOmJu8/OPvF9YufUZVVfWlw3tHL1v3g8N/VlVVfeWZfT266Ofvg9wh90H2ufvtlvHSmTMQufvdBISBI3dT5UtfdSfR/fZXn3PtTSdUVVWP1wy5E5vrcldP3/K+8ud3/l5VVfWJ3f/6/hsrT6iqqv5wkWO3zAt71hhyf90Vj51V1bNT9Teef8eblv5CVdWzU2sNub952S9VVVVPNd1a7tacmLjn3Gu7Z1X1bHPzeRctPW/lc6qqvvjAFrvcf/tk6ZL7Sgf/pKrqiw9u7yP3W55+SVVfOrTn/G9Onr/ujKqqLz08dcGla+99RlXVP++9/WhXVdVXnpmLljvkHqPcWUcrHvrc+26lRC539ixFBhe+3KmWuyb0O+e9+pxrX32noqqqemKHJndVuYV0y2gt987ndbm/sGvCTe68lvuXp35vP7juAUPu1a6qquqJZf66ZS5t/tFe5tMPc+X+oTW/VlVVfbrlLvcrDv3JXuAz0xdcuvZjl07tfYX8f2YZumUg99TLPZmWO4iZ4HI/e+ziqOVOWu5sn3sYuWstd7bPPajcScvd2uc+rbdKIHfIPe23QibW5w5ixl3urt0yUcr9dVqH+7N38OT+tb1/UFX17L71vuR+7opfqaqqqs/d1U/ui55WVVV9YrJfn/ta0uF+ZqlV7vc+o6rqzLLL0C0Duae95Z7k3TIgZtzl3ueCanRyf33+tjdc8aOzqhlLn/voum2/Uel4vaB6bZcuk9PnbuTplqe7ZSpPv0Rt9NLD01OvqKqqdjesoy+ozr18w9yW8ctAXFCF3NMid3cg90xhkXvafsQ00F+oUi13/IgJch9euXOB3AHkDrlD7sMk93HPoeUeYCsFch92xJU7hh+A3IdN7qM+QzQdbCsFch92IHfIHXIfFrkP95C/IGYgd8gdcofcIfcMgvcIAMAl+uEH+gY+ihC8mAAALtHL3b2zP1ixwAm8mAAALgORu+ocr8W2KvlcpU3+jeGFYHfkZdexHZ4zkDsAgEvScm9V8vQoOFKhQWs9mHMDALkDALJFCuTO9SNa7t6A3AEAXNIndy8t91Yln6vUilprvyRbD8P8NjBSa2mb2FZuV0ck+zqFUs6+VZstrWf9tgG5AwBSSQrkHqBbplXJG06XC1bD1ktSoeF15a4iF6RiXWlV8rq729URydw1U1qvXjJKQ8sdAJBWUiB3Dy13o6GdLxbs0reV4PRpYVvZ1vq2rUN/xngpLTnc3yOXN2KIkvhJAsAwMhxy5z/LLcG999xUNtXH4i73vqUl+v65vEeZ0SK5gxYA4IvMyZ3uNmFXYDa3dsLoS0hHja0Txizf2oGT6Pvn9B5lxuyKh0qVsST+goNskD259+tyyVXavW5Dv75q9vPYrpE6deD0uopcsGyb6Pvn9B5lyRGkUiV+GLEh1B8LBkf0cu+7Tpa8kzge5U6mehmufw1Ek7tofy8YEBHLPZ1fPCUmib/uUeFF7sP499LHLJrsRPt7wYDAqJDDDbplsodofy8YEJD7cIOWe/YQ7e8FAwJyH26CtNypS8T5alNb4nJlOMAdn9bfB9h/QuyTsLKL6Y7VZi0nScV6/zXlgvlr50H8vQD0ugrkPuz4b7mbt3IqvXqJyGgQcg/3awBPLfe+P3HweAD0CnIh2KeReQet7Vdv9CtP78X5kCB3EAmQ+3Djv+VODaig0azlzIa8fdQd+ln61k/mx8OSk2fJAA/88XzImD+247ETn9zpX7f5Q//IdNiX9rebTzVrOcePEMgdRALkPtwE6HPX7vGnOxC4StKlbHEf57e+mpobRcrRlgYso0tzPB9HwYVqufNGjmtbxobj/czNZnb7gHG0julvP/pfxL5Erkfbro5ofWIMkDuIBEyzN9wEv1uG/BSL7ZZx/z2XveVeL9k7H7qcAvuO5+OKm9xtt7hyx3pj3S0XLMfcquRzI9Y2OztgHPVpZzzQMU3t0i1j+3uZQvr/vQD4AdPsDTfh7pbRFcbtl2Cd7tiTzije/myh4T6eD0PwlrvTWG/2Q7I10kdqVaofnO9o7eVqFO1fOCxy99Zyd1kTcgeRkPTwAx7x2MpLwUheMeO75d6q5I0Go8XpVsvTI+fQz+oGN8bkKWl9C81azqpL28VD1/F83PEt975DVrByN64fuF5hbhSlksxetAgkd7TcwYBJh9z10VrsfcEG4eWeiPe5bd5I8d9yNy+Q0r3hpCM+X23aR92xPmsfe1lrs2vPWv5wpmuCM57PIFruTiPHsZ83nHKatRz5Q9gB48y/i9NXjj53kD6Sl3u7OkJ/o7dclzMYUrkPfu++W+5DSIgLqlTnPu/zhldOvUT0zV576HXtX1BMvN0tI0mS9pmBu2XAwElc7vyzhXvbXLvXVaimYqnqOJav2/18lvOW2bX5lNlN4XU+P8MLPb0bVybHY917pO+f/5b7cIy046nl7otIPl+d7083u3TClRPZ3wuEJ2m5U924fIzb5nRLmobl3plnO2fY+/m4N0JomF/G6d+keJ3Pz/xz9E+sdHTLDDsxyN3jBx57KZUCv1AF6SIFcnf64Qn3m7XT/Qa2Fdzv57OcxQ73eLSo+Zi4h+pQDvnSYL+8loI+92H8l65Ukb90qUW0vxcMiKTlzv4epMe7Ic+X3L3fz9dj9utL7txy5ELa5D7siCY70f5eMCASlzvvgqrjbXNMtwxzZ57tM4BzP5/TjRDWp6yT7em7c+jDsZZQaLCX1/r2PgVFHLm7VCoEETlOTYHk5a5Y7yUgvZaOt81RnSEluWu/M09fzf1+PocbIbqKpXz7fd+c1re9HEr35DeQ1Cbm3iMVn9N7FOC9AwAMHS7f8zDN3nADuQMgMvHJ3eP3CHoTiZfEX7JhAXIHQGTikzuIGcgdAJGB3DML5A6AyEDumQVyB0BkIPfMArkDIDKQe2aB3AEQGcg9s0DuAIgM5J5ZIHcARAZyzyzh5U5Pb5v4nwMA8AXknlnCyJ0InZ7hFooHYLiA3DNLYLkbWlepGEsS/7sAAF6A3DNLSLmrTDjb2iYOFW8WcgBSC+SeWYLJ3X3wTvvmrUo+VyjlmCHyAQBJA7lnlrjkXmmzExZ6mW/WZbpaAEBoIPfMEp/cjRlEtf96mW/WZbpaAEAEQO6ZJU65O0556DQloct0tQCAKIDcM0swuSt+L6hS0xaWqn7kjtY6AIMEcs8sYeRurEm/6ZxtLY6ul5g5BZ3nm3WZrhYAEAGQe2YJLHdF17r7EqXHdJdr/ene5pt1ma4WABCaiOXOnRgPsSWetzaM3I01bS13AMCwEL3c2b5axMjo6OgQyd0LCX56AQBcGIjcE/+r0gl5QTMmdwBAOoHc436tIXcAQAxA7nG/1pA7ACAGIPe4X2vIHQAQA+mQO/uTlmA/ckn3T2MgdwBAbMQp92Yt53BHc1+5u/+373L6AKwxh6t1J4qPDcg984wjSOxxOqPH45O7bXhY+1MxyN3naiE3cXhBIfcMMz4+HtWPIRDES1zO6Pjk3q6O5KvNRtE6t4NxjO6/WnSSu23YWHPckkJJb6RzfuPOlkYX0quXjBZ9q5KXRmots8nvtaXv/IJKkHt2IXJP/DCAIBB3Jy73Zo202Y1fqNOji7DjjTj6l1Y/M2ysOeKg/v1ALnBGHLSPiMKMPUuGuzKOmT2eQEDumQdyB+FRvcVwd9JyN+VYL9GtbPpZ7ggkLv9lh43ljDio745/MOzHhib6dnVEinoCuaGTO92vF88xDzuQOwiPxzM0LXInrjSSrzajkTu3p96v3LnWlgsiy50IfZQKFO8FyB2EZ7jk3qzlqL5vcy4eTbvt6ojDEn0TvuuZYWNZuZu9QMxq2n+5Y8+Svhrqg0HrqPH82PkFTb/cDa3TC8kSdOn0fekgdxCSoZK7vdmrS1MuaA35YkFbgV3CLcFp2FhOdw3Pti4d+rbPDKrLvlGkvnMIIHc/207vmxgfn9hx0qXYEzsm+CtM75uw39o1MTXt6W90LHNgG/YDcgfhGSq5x0xaf8o0FHJ3qRCOm5/YMTGxvjGxfN8J5+Pp69MAwoXcQRaB3J1xlbvEJLYDy6rcT04tn5iabm/SW9y0OrXHZvN8YmpaObFD/996822yCddch3xmHGyMU+WPL993wlqm04YndkxM7Ni3SVvUaHXp7woTm9brz65v96b3TZAVyO70zcddP7SYVw9yByExTjH7V1rrdS8h5Z5WMir36X2kzd5ar/XMcOROLzzY0CTbPTm1fHzTQcW2praO7n26BE3Bum05DXBmwxM7JvTdcY6QfpasQI7HeAC5g9ihTzGb2Q0DK5B7qsim3C3WNhvLjnK3PctKvEe3vi0N/JNTyy3tdFbu7IbeD0b7E9a3e932Jsr4Pt9iyB2ExHaKcc2uQO6pYijkrrjWCW6fDG1TrdclvNy5feKt9f3l7rKkv9yJ1qnmv/+3GHIHIWHPMtbsSlJy53YVIePDI3fPZdL91Hq/B6Xsk1PLxy2dKl3P3TJs25k4V/9+0LN+Njht6CR3sqFD29/y+YFuGRAv3DOUa/y45T6KuCb9clf0H0C7L1F63G6N5ftOmM15csWSrNDeND4e5IIqucmSsnZrvbGhWabThg5fCLQNqcPTofr0e5A7SACPnR8JyB3pm2SriPd+M5VKIrU8AYyLroGA3EF4Uip3kB7Cy11AAl9KJUDuIDyQO+gD5B4/kDsID+QO+gC5xw/kDsLj6wYNBXIXEMg9fiB3EBK/N2gokLuAQO7x43IXKQADAnIXDsg9kdccQeIPtzZC7pnF6T3CeweACEDumQVyB0BkAsrd+/VcJJEokDsAYjMeQO5+r+ci8UeB3AEQmyByR9IfJQq5274KAACGCMg9m1HCyZ0Inf4qAMUDMFxA7tmMEno8d/q9V/W+uL7bAgBSAuSezSih5e6hzGYtZx/wMl9tJl6nAQAK5J7VKOGm2TPKIcruU6zrjOQAgESA3LMZJQq5001yt2Itcm/WclJJJo/rJWmkJlfyuUJJb+NrT7UqeW3BSM0yxC6zeYteudCw7Y48blXyuUqtqK9AHxh3w1Ylr63ZrOUKDXNz2xHajg2AYQJyz2aUxOTeVeSCVKybD2hLygVJKjR69ZJhYbbVb9u8Vy/pwm1XR7QCWbkbUjZhNtT3266OlIqFktxVevWSbXO5IJkfAJA7GGIg92xGSbJbRnNooyiVZNuzelve0lFvbW67bE5a3A4td3u/ELthr9sojtRa3Uax0GhV8uRzgvtpkfRpCUB4IPdsRonjgqoOI8RGUSrJevOcK3dXgTpuHlru7epISa6XcpU26ZCRC5zPD8gdZALIPZtRwsndWJMu0HFbVoitSt64c4Z+Vuv0MDtM+NCbc7tl9MZ+uzoiOcmd0y3TVVqVUm6ElNyuFkrFgtanz8od3TJgyIHcsxkl3I+YjEJclphw3Nqs5XQztuhOGKqr3VjG8TK1uWVlyunkzstiwbHlztvQvEjbs3avQ+4gc0Du2YwSxfADtgJ9YHizF6ijg94cABAIyD2bUeIaOMz+KyZJUoxroWQd/3K3bA4ACATkns0oGBUSALGB3LMZBXIHQGwg92xGgdwBEBvIPZtRIHcAxAZyz2YUyB0AsYHcsxklkNxDTtyKIEgigdwFSmC5s7c2IgiS5jid0ZB7NhNG7kkfO4IgXuNyRkPu2QzkjiAiBHIXLpA7gogQyF24DFDunTLp6St3nNeZkcfG5Bn3crysM4j42m9SB8lkRh6Typ1OWRorl90PyVxz0Ace1bvs7UX2/gp4LzP6OO93QO8L5C5cBiZ3b5WTreJOSwZ9Eno5kr6bBztIY6tI/sZOWSp3ZuSxstyvWGPNTqCjjXaTCGsC+wqELzNkfNWuYO9Lv0DuwiVquXfKhlBcm+xa0HIPuS2bTpnIyovctTU7Ue3bIfG23DmvQPgyI4+r3Kn3JbL3B3IXLtHJfUYeM/pg9B4ZSZJIPZWsPTQz8hhp18/IY2Pl8pixqrUZayuEPRlsJVs+UTplc6G9fLksSaR1ZH3M2S9bAv8AqIOki+Vvbr4+5Q71tNGNwP5dWoH9urlsxzYmz6j28s0Dc9yEeszu2lyH/iuYYw7wSoapCY5/zjDXLnNfzk96DuQuXCKRO6f2WRVAzgnz7KDlrm+oPdQ2NLdy/uLMKVk/54xH5gKzHLpk217Y/bIl8A7AcpB0sZzNmS819m4Z5u+iCzS7u6hPUK722d4ey4HxwpW7bdf8v4J9L3y9ksFqgodXYIhrlzV02ylQIHfhElruVH2lw5pF5fXVsM+yJ5t1idHQsVwuY84/rXuIbihJ1jYUu3en/Trpw2lz+x/lfADc18rpNWF36h6u3N239fiCsDb0csy8V9Lt3exXE3y8Ap7LTFHt4sbhbPMSyF24DLzlHrXc3bbVHpU7dNe/+1YeXcZ97TzK3eUAuK+VV7kHarknK3f3lqnvmuD5FfBRpvO22qO4ahf7+qDljvjKYPrc/XTL6JV7xuiC0L6ucr9Q0+GVTM6/cllfl2nquJ9+7H7dGksOB2k5VHZz5iPOWGAeA9MtE7LlbinfdRO6U8HNR7a/gtst4/2VDFkTBlFm4rXLciToc0d8Jzq5k/AaNeZ3T94FVaPVZdtQb5ZpX5C5pzRbssrI07aLPqcfs1+2BOufyzlItlXL/o3WpiYpxv2CKueY3UOtaS/fdSPHl93219n+Cva98PVKhqwJ7n/MkNYubUvcLYMEStRyRxAkjYHchQvkjiAiBHIXLpA7gogQyF24QO4IIkIgd+EiqNyZC1xCjG6GCBzIXbgMSO7mTRfmnV/GHQEd2y83qNsEZuQx3jbW+xEc7yzwHF2Jgo1uhggcyF24RC33TtniGvKTPtqhnbLRSOarirlfj+8v43fbHu8VsxwY9QvDDI9uFtlddEgGArkLl+jkzv0JnSF3nmUYMZEF9uZ0H7mr/X7lwR6YcVS8bwTcm/GHdfypaH7/gmQgkLtwiUTuTgoxfn6nedRmeLsKHTpLeMbk/LCP9+HCPzC60T/m7We0Qz3+FPdjFxEskLtwCS13p99Pd8qsVonjnbplLKqlnrDbiley5UnzV59coZkipBvClt/TZmh0M84rg4gYyF24DKzl7tAV49zGtAnKfIYjd4dOHk8td6q4gcndbVvtUYzjT6HljkDuAmbAfe76M9zWukVJVqfSbff+1yr99LnzDyCro5uhzx3RArkLl+jkTmLclGLTM6dF7ix66+YuT2lP+7hbxv6BwjnGzIxuhrtlEDOQu3CJWu5pj1NvEYJkO5C7cBFM7nA7Imggd+EimNwRRNBA7sIFckcQEQK5CxfIHUFECOQuXCB3BBEhkLtwgdwRRIRA7sIFckcQEQK5CxfIHUFECOQuXCB3BBEhkLtwgdwRRIRA7sIFckcQEQK5CxfIHUFECOQuXCB3BBEhkLtwgdwRRIRA7sIFckcQEQK5CxfIHUFECOQuXCB3BBEhkLtwgdwRRIRA7sIFckcQEQK5CxfIHUFECOQuXCB3BBEhkLtwgdwRRIRA7sIFckcQEQK5CxfIHUFESCRy//8bNlZW/xO8dAAAAABJRU5ErkJggg==)
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.
A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code
Before:
<?STAT?>
After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
2 comments:
Awesome! Great command for developers
Thanks a lot my friend...
Post a Comment