Page Border in XLS

dixie

Hi,

I have a report which is designed to fit on an A4-Page. This does perfectly work for PDF and Word-format.
Exporting it to Excel, the border-settings are not taken. Instead it uses some kind of default border widths (in my case 2,5 cm, which causes the report to be of 4 instead 1 pages).
Even if I set the border to 0cm, it works fine for PDF and Word but not for Excel.
Any idea? I'm using the default XLS emitter, Birt 2.6.0 and Excel 2003.
BTW: The Orientation-Setting is taken from the masterpage.

Thanks in advance,
Dirk

dixie

Hi,<br />
<br />
I did some more investigations and found the following:<br />
<br />
If I generate a report as XLS using Birt, the resulting PageSetup-XML-Node inside the Workbook looks like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><PageSetup>
<Layout x:Orientation="Portrait"/>
<Header/>
<Footer/>
</PageSetup>
</pre>
... even if I configure page margins in the masterpage. <br />
If I open a new worksheet in Excel, change the border values and save it as XML, the XML-Node looks like this:<br />
<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><PageSetup>
<Header/>
<Footer/>
<PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996" x:Right="0.78740157499999996" x:Top="0.984251969"/>
</PageSetup></pre>
<br />
<br />
So it looks to me, that the XLS-emitter does not generate the PageMargins-Node, right?<br />
<br />
Any idea how to force the page margin values to be generated?<br />
<br />
Thanks in advance,<br />
Dirk