OTN Discussion Forums : Limitations in excel output ...

2257648922

Posts: 174
Registered: 05/24/07

Limitations in excel output
Posted: Feb 15, 2008 10:40 AM

TIM,

Recently I have seen many threads regarding issues on excel output,

The XHTML output has lot of limitations,
Most of the users are aware of it, but seems like many are not…!

Many threads related to excel output(APPS) remained unanswered
few threads from last 3days
http://forums.oracle.com/forums/thread.jspa?threadID=616659&tstart=45
Performance Issue generating excel output with huge XML data
http://forums.oracle.com/forums/thread.jspa?threadID=617909&tstart=30
EBS - XMLP 5.6.2 - OPP Performance... - Excel Output
http://forums.oracle.com/forums/thread.jspa?threadID=618590&tstart=0
Excel output in EBS?
http://forums.oracle.com/forums/thread.jspa?threadID=570975&tstart=0

could you post something on these limitations and enhancements coming up the way.
That could help many user on this forum.

Thanks
ss

user553318

Posts: 50
Registered: 01/15/07

Re: Limitations in excel output
Posted: May 2, 2008 10:47 AM

in response to: 2257648922

Reply

Hi, I'm not Tim, but thought I would post something I discovered today regarding this topic.

I was not getting the pop-up window that allows selection of output type Excel. This was uing IE7 browser. All it would do it start to open a window, and then beep at me, and close the window.

Then I tried using both Netscape and Firefox, and with those browsers, it opened the pop-up window that allowed me to open in Excel.

Does anyone know why this difference would occur between various browsers?

Thanks
Paul

edh

Posts: 36
Registered: 04/24/07

Re: Limitations in excel output
Posted: May 2, 2008 10:59 AM

in response to: user553318

Reply

Hi Paul,

We've run into a similar problem with IE7 as well. If this happens to be the same problem, it can be fixed with the following:

1. Select 'Tools' -> 'Internet Options' -> 'Security' (tab) -> 'Trusted Sites' -> 'Custom Level' (button) -> 'Downloads' from the browser menu.
2. Set 'Automatic prompting for file downloads' to 'Enable'.
3. Save the setting and close the browser window.
4. Start a new browser session and try again.

Hope it helps.
Ed

user553318

Posts: 50
Registered: 01/15/07

Re: Limitations in excel output
Posted: May 2, 2008 11:19 AM

in response to: edh

Reply

Ed,

Thanks! My colleague just found the same thing. It works now!

Paul

Tim Dexter

Posts: 2,261
Registered: 01/10/01

Re: Limitations in excel output
Posted: May 5, 2008 11:30 AM

in response to: user553318

Reply

Just wrote up a Q&A blog entry today - http://blogs.oracle.com/xmlpublisher/2008/05/05#a946

skbaasri

Posts: 1
Registered: 07/14/08

Re: Limitations in excel output
Posted: Jul 14, 2008 8:07 PM

in response to: Tim Dexter

Reply

Hi Tim,

We have a requirement to display the period name (the default format being MMM-yy) in our report.

When the report output is RTF , HTML or PDF, the output is displayed as intended. But when the same needs to be displayed in an Excel report output, it gets converted to a date.

This works fine if we have leading spaces after the field. But our requirement is not to have any spaces in the report.

Kindly suggest.

Regards,
Sujatha
PS: I have posted in your blog too. Posting here for an early response

Tim Dexter

Posts: 2,261
Registered: 01/10/01

Re: Limitations in excel output
Posted: Jul 14, 2008 8:34 PM

in response to: skbaasri

Reply

Hi Sujatha

So Excel formats to different date format to that required? Or makes a complete mess of the formatting?

Without the spaces you are limited to the html we generate and its limitations. The only option I can think of is to write a global macro that would reside on the client Excel and would reformat the date contents you want converted.

Regards

Tim

http://blogs.oracle.com/xmlpublisher

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Jul 23, 2008 1:56 AM

in response to: Tim Dexter

Reply

Hi
I want Image to show on Excel output in EBS
I gone through Tim's Blog about "Excel Limitation Q&A"
but I am not getting which path is to give for
1)Base image URI and 2)Image file directory In Administrator Tab
I kept Image file(comlogo.gif) is in OA_MEDIA.
In rtf template I have created dummy image and in web tab I have given url:{'${OA_MEDIA}/comlogo.gif'}
but it gives small red 'x'icon in excel
can someone pls help me for this issue

Thanks
Rahul

Message was edited by:
user576181

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Jul 23, 2008 9:24 PM

in response to: ranalawa

Reply

Can anyone suggest any link or steps to achive this?

Rahul

Help me please

Message was edited by:
user576181

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Jul 24, 2008 11:28 PM

in response to: ranalawa

Reply

In Admin Tab

Base image URI >> I am giving image file directory path
Image file directory >> same path as above

but how template will access this path? what I should write in template?

Rahul

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Jul 25, 2008 4:31 AM

in response to: ranalawa

Reply

I am giving

Base image URI = http://cvd-erp-dev-01.limac.com:8011/OA_MEDIA/comp_logo.gif

and

Image file directory = /u11/orafindv/findvcomn/java/oracle/apps/media/comp_logo.gif

Is it correct?
Now please suggest me what should I write in rtf Template?
shall I take dummy Image? or something in form field?

Thanks In advance

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Jul 29, 2008 3:07 AM

in response to: ranalawa

Reply

Can some one put light on this please....

Rahul

user600879

Posts: 2
Registered: 10/17/07

Re: Limitations in excel output
Posted: Aug 11, 2008 3:13 AM

in response to: ranalawa

Reply

Hi,

Paste an image in the template where you would like your image to be displayed in the output. Double click the image. In the "Web" Tab of the the image properties write this:
url:{concat(CP_URL,'/','logo.gif')}

where CP_URL contains my unix directory path where my logo.gif file resides.
CP_URL is a placeholder in my rdf and hence is part of my XML output.

ranalawa

Posts: 163
Registered: 05/23/07

Re: Limitations in excel output
Posted: Aug 12, 2008 10:10 PM

in response to: user600879

Reply

Hi
Thanks for your reply

This will work for PDF output .But when I select EXCEL output I am getting
small red cross in place of Image.

Rahul

DiscoUser

Posts: 163
Registered: 05/24/06

Re: Limitations in excel output
Posted: Aug 21, 2008 10:21 AM

in response to: ranalawa

Reply

Hello Tim,

First time posting a message in this forum. We have a report that we export to Excel for users to analyse it futher. Report consists of all percentages with % sign at the end of each value in the cells. Negetive numbers are highlighted in red enclosed in brackets with % sign at the end. All numbers are rounded to one decimal in the source query, so the XML data has values rounded to one decimal. When we export the report to Excel, all positive numbers are rounding to 2 decimal points and negetive numbers to one decimal point. When exported to PDF, all values are rounded to one decimal. Is there a way to fix this in Excel output?

Thanks in advance.