Home » Fusion Middleware & Colab Suite » Business Intelligence » how to convert in BI output excel
how to convert in BI output excel [message #468637] Sat, 31 July 2010 07:09 Go to next message
gacon1982
Messages: 7
Registered: July 2010
Junior Member
Hi every body .
I'm having a problem do not hold the correct data format when I export excel reports from the BI publisher.
I have a Field and Field, which has a value equal to '012345 '. When I export reports to Excel, I get a value of 12,345 and is now the number of data. I want that value to be retained as formatted text. and it should be '012345 '.
I tried CTRL + SHIFT + SPACE. But at this data it was added to a character insert Special Characters. I want it to keep the format when I export report to excel.
Please help me

Report message to a moderator

Re: how to convert in BI output excel [message #469651 is a reply to message #468637] Thu, 05 August 2010 06:44 Go to previous messageGo to next message
skaundinya
Messages: 9
Registered: June 2010
Junior Member
Hi,

Usually for formatting issues in excel just add a space bar after the data field in the rtf.

Most of the number formatting issues in excel will be solved.

Rgds,
skaundinya.

Report message to a moderator

Re: how to convert in BI output excel [message #538555 is a reply to message #469651] Fri, 06 January 2012 23:56 Go to previous message
venusriram
Messages: 3
Registered: January 2012
Location: hyderabad
Junior Member
You can add any character to the field (i.e ',#," etc) make this as invisible or color it to background color generally it as background while color

Report message to a moderator

Previous Topic: send email by XML
Next Topic: Multiple headers in XML Publisher
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 04 17:44:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.