</ 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"> Order Property </span> </td> </tr> <tr id="pagetoptable1row3"> <td colspan="2"> <a href="#SeeAlsoBookmark" onclick="javascript:openSectionById('seeAlsoSectionHeader');">See Also</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> Returns or sets the order in which pages are numbered when printing a large worksheet. <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 Property Order As <a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PagePrintOrder.html">PagePrintOrder</a></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> Dim value As <a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PagePrintOrder.html">PagePrintOrder</a> instance.Order = value value = instance.Order</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 <a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PagePrintOrder.html">PagePrintOrder</a> Order {get; set;}</pre></td></tr></table></div> <h4 class="dxh4">Return Value</h4><p>PagePrintOrder enumeration. </p><p>The default value is DataDynamics.SpreadBuilder.Printing.PagePrintOrder.DownThenOver </p></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 class="LanguageSpecific" id="Example_VB"><table class="syntaxtable" width="100%" cellpadding="0" cellspacing="0"><tr><th>Visual Basic</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="VB"><font class='keyword'>With</font> sb.Sheets(0).PageSetup<br> .BlackAndWhite = <font class='keyword'>True</font><br> .BottomMargin = 144<br> .Draft = <font class='keyword'>True</font><br> .FirstPageNumber = 100<br> .FooterMargin = 72<br> .HeaderMargin = 72<br> .LeftMargin = 108<br> .Order = DataDynamics.SpreadBuilder.Printing.PagePrintOrder.OverThenDown<br> .Orientation = DataDynamics.SpreadBuilder.Printing.PagePrintOrientation.Landscape<br> .PaperSize = Printing.PaperKind.A4<br> .PrintNotes = <font class='keyword'>True</font><br> .RightMargin = 108<br> .TopMargin = 144<br> .Zoom = 200<br> <font class='keyword'>End</font> <font class='keyword'>With</font></code></td></tr></table></div> </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.html">PageSetup Class</a> <br><a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PageSetup_members.html">PageSetup Members</a> <br><a href="ActiveReports.XlsExport~DataDynamics.SpreadBuilder.Printing.PagePrintOrder.html">PagePrintOrder Enumeration</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>