Home » Fusion Middleware & Colab Suite » Business Intelligence » Item code in excel
Item code in excel [message #487937] Mon, 03 January 2011 11:51 Go to next message
hany_marawan
Messages: 168
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
I published a report in the inventory module as XML report.
When I open the output in excel the items code converted to a date.
I.e if I have item code like '01/04/01' it convert in the excel to '01/04/2001'.

How can I solve this problem.

Thanks
Re: Item code in excel [message #487950 is a reply to message #487937] Mon, 03 January 2011 14:10 Go to previous messageGo to next message
mkoolwij
Messages: 3
Registered: January 2011
Location: Breda, The Netherlands
Junior Member

Hi,

I assume you are using a RTF template for this inventory report. How did you set the 'Text Form Field Options'?

Kind regards,
Marcel
Re: Item code in excel [message #488011 is a reply to message #487950] Tue, 04 January 2011 03:20 Go to previous messageGo to next message
hany_marawan
Messages: 168
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
Yes I used RTF template.
The type of the filed is "regular text"
I left the "text format" empty as the default.

Regards
Re: Item code in excel [message #488099 is a reply to message #488011] Tue, 04 January 2011 14:23 Go to previous message
mkoolwij
Messages: 3
Registered: January 2011
Location: Breda, The Netherlands
Junior Member

Hi,

Not sure if this can be solved in a nice way. Found a note saying:

This is not a BI Publisher issue but due to the way MS Excel is working.
MS Excel is treating the field as number instead of a character.

As a Workaround you may try to modify your template by adding a character to this field in order to force MS Excel to treat it as character and not as number.


You might give it a try to add a ' in front of the actual item code.

Regards,
Marcel
Previous Topic: not able to install obiee completely
Next Topic: Values on top of each vertical bar graph
Goto Forum:
  


Current Time: Thu Jul 24 20:54:45 CDT 2014

Total time taken to generate the page: 0.15103 seconds