</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <input type="hidden" id="userDataCache" class="userDataStyle" name="userDataCache"> <input type="hidden" id="hiddenScrollOffset" name="hiddenScrollOffset"> <img id="collapseImage" style="display:none; height:0; width:0;" src="dotnetimages/collapse.gif"> <img id="expandImage" style="display:none; height:0; width:0;" src="dotnetimages/expand.gif"> <img id="collapseAllImage" style="display:none; height:0; width:0;" src="dotnetimages/collapse.gif"> <img id="expandAllImage" style="display:none; height:0; width:0;" src="dotnetimages/expand.gif"> <img id="dropDownImage" style="display:none; height:0; width:0;" src="dotnetimages/drpdown.gif"> <img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="dotnetimages/drpdown_orange.gif"> <img id="copyImage" style="display:none; height:0; width:0;" src="dotnetimages/copycode.gif"> <img id="copyHoverImage" style="display:none; height:0; width:0;" src="dotnetimages/copycodeHighlight.gif"> <div id="pagetop"> <table width="100%" id="pagetoptable1"> <tr id="pagetoptable1row1"> <td align="left"> <span id="projecttitle"> ActiveReports.XlsExport </span> </td> <td align="right"> <span id="feedbacklink"> <a href="http://www.datadynamics.com/Support/SupportRequest.aspx">Request technical support</a></span></td> </tr> <tr id="pagetoptable1row2"> <td align="left" colspan="2"> <span id="pagetitle"> PageSetup Class </span> </td> </tr> <tr id="pagetoptable1row3"> <td colspan="2"> <a href="#SeeAlsoBookmark" onclick="javascript:openSectionById('seeAlsoSectionHeader');">See Also</a> <a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PageSetup_members.html">Members</a> <a href="#ExampleBookmark" onclick="javascript:openSectionById('exampleSectionHeader');">Example</a> </td> </tr> </table> <table width="100%" id="pagetoptable2" cellspacing="0" cellpadding="0"> <tr> <td> <span id="toggleExpandedAll"> <img id="toggleExpandedAllImage" class="toggleAll" src="dotnetimages/collapse.gif"> <label id="collapseAllLabel" for="toggleExpandedAllImage" style="display: none;">Collapse All</label> <label id="expandAllLabel" for="toggleExpandedAllImage" style="display: none;">Expand All</label> </span> <span id="languageFilterToolTip" style="cursor:default;" onclick="showBox('dxlanguagemenu',event,document.getElementById('languageFilterImage'))" onmouseover='document.getElementById("languageFilterImage").src=document.getElementById("dropDownHoverImage").src;' onfocusin='document.getElementById("languageFilterImage").src=document.getElementById("dropDownHoverImage").src;' onmouseout='document.getElementById("languageFilterImage").src=document.getElementById("dropDownImage").src;' onfocusout='document.getElementById("languageFilterImage").src=document.getElementById("dropDownImage").src;'> <img id="languageFilterImage" src="dotnetimages/drpdown.gif"> <label id="showAllLabel" for="languageFilterImage" style="display: none;"> Language Filter: All </label> <label id="multipleLabel" for="languageFilterImage" style="display: none;"> Language Filter: Multiple </label> <label id="VBLabel" for="languageFilterImage" style="display: none;">Language Filter: Visual Basic (Declaration)</label> <label id="VBUsageLabel" for="languageFilterImage" style="display: none;">Language Filter: Visual Basic (Usage)</label> <label id="CSLabel" for="languageFilterImage" style="display: none;">Language Filter: C#</label> </span> </td> </tr> </table> <div class="dxpopupbubble" id="dxlanguagemenu"> <input id="VBCheckbox" type="checkbox" name="languageFilter" onclick="setLanguage(this)"> <label class="languageFilter" for="VBCheckbox"> Visual Basic (Declaration) </label> <br><input id="VBUsageCheckbox" type="checkbox" name="languageFilter" onclick="setLanguage(this)"> <label class="languageFilter" for="VBUsageCheckbox"> Visual Basic (Usage) </label> <br><input id="CSCheckbox" type="checkbox" name="languageFilter" onclick="setLanguage(this)"> <label class="languageFilter" for="CSCheckbox"> C# </label> </div> </div> <div id="pagebody" valign="bottom"> <a name="topBookmark"></a> <div id="mainbody"> <div id="allHistory" class="saveHistory" onsave="saveAll()" onload="loadAll()"> </div> Represents page setup information for a worksheet such as margins, paper size, etc. <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="syntaxToggle" class="toggle" name="toggleSwitch" src="dotnetimages/collapse.gif">Syntax</span></h1><div id="syntaxSection" class="section" name="collapseableSection"><div class="LanguageSpecific" id="Syntax_VB"><table class="syntaxtable" width="100%" cellpadding="0" cellspacing="0"><tr><th>Visual Basic (Declaration)</th><th> </th></tr><tr><td colspan="2"><pre>Public Class PageSetup </pre></td></tr></table></div> <div class="LanguageSpecific" id="Syntax_VBUsage"><table class="syntaxtable" width="100%" cellpadding="0" cellspacing="0"><tr><th>Visual Basic (Usage)</th><th><span class="copyCode" onclick="copyCode(this)" onkeypress="CopyCode_CheckKey(this)" onmouseover="changeCopyCodeIcon(this,true)" onfocusin="changeCopyCodeIcon(this,true)" onmouseout="changeCopyCodeIcon(this,false)" onfocusout="changeCopyCodeIcon(this,false)" tabindex="0"><img class="copyCodeImage" name="ccImage" align="absmiddle" src="dotnetimages/copycode.gif">Copy Code</span></th></tr><tr><td colspan="2"><pre><code>Dim instance As <a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PageSetup.html">PageSetup</a></code></pre></td></tr></table></div> <div class="LanguageSpecific" id="Syntax_CS"><table class="syntaxtable" width="100%" cellpadding="0" cellspacing="0"><tr><th>C#</th><th> </th></tr><tr><td colspan="2"><pre>public class PageSetup </pre></td></tr></table></div> </div> <a name="exampleBookmark"></a> <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="exampleToggle" class="toggle" name="toggleSwitch" src="dotnetimages/collapse.gif">Example</span></h1><div id="exampleSection" class="section" name="collapseableSection"><div class="LanguageSpecific" id="Example_CS"><table class="syntaxtable" width="100%" cellpadding="0" cellspacing="0"><tr><th>C#</th><th><span class="copyCode" onclick="copyCode(this)" onkeypress="CopyCode_CheckKey(this)" onmouseover="changeCopyCodeIcon(this,true)" onfocusin="changeCopyCodeIcon(this,true)" onmouseout="changeCopyCodeIcon(this,false)" onfocusout="changeCopyCodeIcon(this,false)" tabindex="0"><img class="copyCodeImage" name="ccImage" align="absmiddle" src="dotnetimages/copycode.gif">Copy Code</span></th></tr><tr><td colspan="2"><code class="CS">sb.Sheets(0).PageSetup.BlackAndWhite = true;<br> sb.Sheets(0).PageSetup.BottomMargin = 144;<br> sb.Sheets(0).PageSetup.Draft = true;<br> sb.Sheets(0).PageSetup.FirstPageNumber = 100;<br> sb.Sheets(0).PageSetup.FooterMargin = 72;<br> sb.Sheets(0).PageSetup.HeaderMargin = 72;<br> sb.Sheets(0).PageSetup.LeftMargin = 108;<br> sb.Sheets(0).PageSetup.Order = DataDynamics.SpreadBuilder.Printing.PagePrintOrder.OverThenDown;<br> sb.Sheets(0).PageSetup.Orientation = DataDynamics.SpreadBuilder.Printing.PagePrintOrientation.Landscape;<br> sb.Sheets(0).PageSetup.PaperSize = Printing.PaperKind.A4;<br> sb.Sheets(0).PageSetup.PrintNotes = true;<br> sb.Sheets(0).PageSetup.RightMargin = 108;<br> sb.Sheets(0).PageSetup.TopMargin = 144;<br> sb.Sheets(0).PageSetup.Zoom = 200;</code></td></tr></table></div> </div> <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="inheritanceToggle" class="toggle" name="toggleSwitch" src="dotnetimages/collapse.gif">Inheritance Hierarchy</span></h1><div id="inheritanceSection" class="section" name="collapseableSection"><p>System.Object<br> <strong>DataDynamics.SpreadBuilder.Printing.PageSetup</strong><br></p></div> <a name="seeAlsoBookmark"></a> <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="seealsoToggle" class="toggle" name="toggleSwitch" src="dotnetimages/collapse.gif">See Also</span></h1><div id="seealsoSection" class="section" name="collapseableSection"><h4 class="dxh4">Reference</h4><a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PageSetup_members.html">PageSetup Members</a> <br><a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing_namespace.html">DataDynamics.SpreadBuilder.Printing Namespace</a> <p> </div> </div> <div id="pagefooter"> <p> </p><p> </p><hr size="1"><p>Copyright © 2004-2007 Data Dynamics, Ltd. All rights reserved.</p> </div> </div> </body> </html>