Export to Excel changes page orientation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Milu - 26 Mar 2006 23:52 GMT

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

Reply to this Message

PSM - 27 Mar 2006 11:54 GMT

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?

> 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
[quoted text clipped - 10 lines]
> Thanks in advance,
> Milin

Reply to this Message

Milu - 28 Mar 2006 05:11 GMT

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

> 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
[quoted text clipped - 15 lines]
> > Thanks in advance,
> > Milin

Reply to this Message

PSM - 29 Mar 2006 07:51 GMT

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.

> Thanks for ur reply.
>
[quoted text clipped - 26 lines]
> > > Thanks in advance,
> > > Milin

Reply to this Message

Milu - 30 Mar 2006 04:17 GMT

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

> 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
[quoted text clipped - 35 lines]
> > > > Thanks in advance,
> > > > Milin

Reply to this Message

PSM - 30 Mar 2006 10:50 GMT

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.

> 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
[quoted text clipped - 48 lines]
> > > > > Thanks in advance,
> > > > > Milin

Reply to this Message

AMasson - 31 Mar 2006 08:09 GMT

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.

> 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
[quoted text clipped - 53 lines]
> > > > > > Thanks in advance,
> > > > > > Milin

Reply to this Message