RE: Export to Excel changes page orientation

[Milu]

Thanks for ur reply.

If u r talking about the "CanGrow" and "CanShrink" properties, I tried
setting them both, true and false. But none of this helped. Is this related
to report orientation changing to landscape?

If you have got positive result trying something, please do let me know.

Thanks,
Milin

"PSM" wrote:

> According to the RS help, when you export a report to Excel, this doesn't
> take to account the format of the page. There are, in field properties, two
> options that allow the field is able to enlarge and shrink. Have you tried
> not selecting them?
>
> "Milu" wrote:
>
> > I have report page height defined as 11 in. and width as 8.5 in. When I
> > export the report to pdf, it comes fine in portrait format. But when the
> > report is exported to Excel, the orientation is changed to Landscape. Even
> > the page margins are not preserved.
> >
> > Is it that Excel overrides the report page setup or RS changes the page
> > settings by itself when the report is exported? I changed the default printer
> > settings to have "portrait" as the default print format. But still exporting
> > the report to Excel changes this.
> >
> > Please let me know if you have found any solution to such a problem.
> >
> > Thanks in advance,
> > Milin

[PSM]

Yes, I was talking about the CanGrow and CanShrink properties. I have never
tried to select a report orientation when I have exported to Excel but, I
have found something I hope you find it useful.
When you export a report to Excel, the width and the height of the page are
looked up in a internal table where there are the most used sizes and
orientations. If they exist in the table, the page format is chosen. If not
so, orientation is determined by comparing height with width. If height is
smaller than width, landscape is chosen.

[Milu]

Yes, I came across that internal table stuff in RS documentation. But as I
mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
A4 portrait size. Still in Excel, the orientation appears as Landscape.

Is it possible you can try a simple report with this page setting and see
the results in Excel. If Excel has its landscape, then it seems like a bug in
RS Excel export functionality.

Please let me know about it.

Thanks,
Milin

[PSM]

I have been checking a report and it works like you say. Excel always use
landscape orientation. I think you are right. It seems like a bug in RS Excel
export functionality.
I am sorry I have been of no help.

[AMasson]

I've also experienced this problem. It appears that Excel uses the
ratio of body height to body width to determine orientation instead of
page size. If you set the body height to be greater than the body
width, it will be portrait orientation when exported to Excel.