</ 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"> FitToPagesTall 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 number of pages tall to which the worksheet will be scaled when it's printed. <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 FitToPagesTall As Short</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 Short instance.FitToPagesTall = value value = instance.FitToPagesTall</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 short FitToPagesTall {get; set;}</pre></td></tr></table></div> <h4 class="dxh4">Return Value</h4>Short.</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<font color="teal">[</font><font color="black">0</font><font color="teal">]</font><font color="black">.PageSetup.FitToPagesTall = 2;<br> sb.Sheets</font><font color="teal">[</font><font color="black">0</font><font color="teal">]</font><font color="black">.PageSetup.FitToPagesWide = 2;<br> <br></font><font color="blue">if</font> <font color="black">(sb.Sheets[0].PageSetup.FitToPage == true)<br> {<br> MessageBox.Show(</font><font color="#A31515">"FitToPage"</font><font color="black">);<br> }</font></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">sb.Sheets(0).PageSetup.FitToPagesTall = 2<br> sb.Sheets(0).PageSetup.FitToPagesWide = 2<br> <br> <font class='keyword'>If</font> sb.Sheets(0).PageSetup.FitToPage = <font class='keyword'>True</font> <font class='keyword'>Then</font><br> MsgBox(<font class='string'>"FitToPage"</font>)<br> <font class='keyword'>End</font> <font class='keyword'>If</font></code></td></tr></table></div> </div> <h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="remarksToggle" class="toggle" name="toggleSwitch" src="dotnetimages/collapse.gif">Remarks</span></h1><div id="remarksSection" class="section" name="collapseableSection">If the Zoom property is set to True, this property is ignored.</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> <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>