| Reports 10G - SPREADSHEET - cannot see the cell borders in Excel [message #452065] |
Mon, 19 April 2010 19:38  |
venkat9876
Messages: 4
Registered: April 2010
|
Junior Member |
|
|
Hi,
I created a report with destination format set to SPREADSHEET.
The output comes in excel spread sheet.
But, I am unable to see the borders around all the cells. Our req is to get the borders around every cell.
can someone help me on this. I appreciate your response.
thanks,
Nivas
|
|
|
|
|
|
| Re: Reports 10G - SPREADSHEET - cannot see the cell borders in Excel [message #452186 is a reply to message #452065] |
Tue, 20 April 2010 09:10  |
SGORTON
Messages: 8
Registered: August 2009
Location: Washington DC
|
Junior Member |
|
|
Littlefoot is incorrect. The MS Excel switch will not bring back gridlines. To do what Littlefoot is suggesting one would have to clear all formats first and then reformat the spreadsheet in MS Excel. This would have to be performed each time the report is generated. Very painful!
There is another approach. Overall, the problem here is that you are using a paper layout. A paper layout is designed to be a quick method to output a jsp (and others) using rwservlet.
With rwservlet you have limited control of your jsp. The better technique is to use a web layout unless you want to train your users to reformat their spreadsheets every time they want to generate this type of output.
If you use a web layout you can control every aspect of your spreadsheet output by combining htm/html with jsp tags.
Basically, this is done by generating a paper layout output as spreadsheet. The MS Excel output is then saved as a html which is now compatible with oracle reports web layout. JSP tags are then inserted for data control. The new jsp is then published through an EE Application utilizing JDeveloper.
The exact methodology for oracle report web layouts is available online. I hope this is helpful.
[Updated on: Tue, 20 April 2010 09:33] Report message to a moderator |
|
|
|
|
|
| Re: Reports 10G - SPREADSHEET - cannot see the cell borders in Excel [message #452229 is a reply to message #452065] |
Tue, 20 April 2010 15:11 |
SGORTON
Messages: 8
Registered: August 2009
Location: Washington DC
|
Junior Member |
|
|
I believe I do understand your issue correctly. You want to programmatically show gridlines when you publish your report.
Unfortunately, you are not going to get that level of detail control using the 'spreadsheet' switch in rwservlet. It is not designed for that level of control.
You should read the 10g Report Services documentation which depicts the development of the 'spreadsheet' switch and how it is to be used. In sum, this switch was not designed to be used for in the way you want to use it.
As I stated earlier, the web layout is the method of choice. Using a web layout, any property that can be saved in an Excel html format can be duplicated in Oracle Reports (10g) web layout. It is not that difficult to learn although it may be a little time consuming working through deployment the first couple of times.
I am sorry if this is not what you want to hear but it does work.
[Updated on: Tue, 20 April 2010 15:14] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
