How to set page to Landscape in xls

[2006 IR Open Dicussion]

By: jane_lim - jane_lim

How to set page to Landscape in xls

2006-02-11 10:11

Hi,

 

In my jrxml, the orientation = "Landscape"

 

However, when i try to view using Microsoft Excel, the report still in Portrait. I need to manually go to Page Setup and change to "Landscape" in order to print the report out.

 

May i know how to default page margin in Ms Excel to Landsacape without manually do so??

 

I have try the landscape demo in the sample, however, the situation still the same.. Even the jrxml orientation has set to landscape, when view the generated pdf and xls, the report still in portrait.

 

 

Any One got any idea to solve this??

 

Pls Help.... Plzzzzzzzzzzzzzzz

 

Thanks....