</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_RATING%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end--> <div id="ProjectTitle"><!--DXMETADATA start type="ProjectTitle" -->Excel for WPF and Silverlight<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="PageItemTitle" format="%%PageItemTitle%% $$Properties$$" -->XLSheet Class Properties<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label> <label id="ExpandAllLabel" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label> </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end --><span id="" class="PopupLink" data-popupcontentsource="#MemberFilterCheckboxes" data-popuptitle='<!--DXMETADATA start type="Phrase" name="Members_Filter" -->Members Options<!--DXMETADATA end -->'> <label id="ShowAllMembersLabel"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_SHOW_ALL" -->Members Options: Show All<!--DXMETADATA end --> </label> <label id="FilteredMembersLabel" style="display: none;"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_FILTERED" -->Members Options: Filtered<!--DXMETADATA end --> </label> </span> <div class="PopupContent" id="MemberFilterCheckboxes"> <input id="InheritedCheckbox" type="checkbox" class="ToggleFilterCheckbox" checked="true" data-toggleclass="InheritedMember"> <label class="MembersFilter" for="InheritedCheckbox"> <!--DXMETADATA start type="Phrase" name="MEMBERS_FILTER_INHERITED" -->Include Inherited Members<!--DXMETADATA end --> </label> <br> <!--DXMETADATA start type="IncludeProtectedOrFriendMembers" format="<input id=""ProtectedCheckbox"" type=""checkbox"" class=""ToggleFilterCheckbox"" checked=""true"" data-toggleclass=""ProtectedMember"" />" --><!--DXMETADATA end --> <!--DXMETADATA start type="IncludeProtectedOrFriendMembers" format="<label class=""MembersFilter"" for=""ProtectedCheckbox"">$$MEMBERS_FILTER_PROTECTED$$</label><br />" --><!--DXMETADATA end --> </div> <!--DXMETADATA start type="IsWebOutputRootPageLinkEnabled" format="<a href='#' class='PageLink' id='viewInFrameLink' title='$$VIEW_WITH_NAVIGATION_TOOLS_TIP$$' style='display: none' data-root-page='%%WebOutputRootPage%%%%OutputFileExtension%%' target='_top'>$$VIEW_WITH_NAVIGATION_TOOLS_TEXT$$</a>" --><!--DXMETADATA end--> </div> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> : XLSheet Class</td></tr></table></div><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Scrap" name="_MEMBERS_LINK" format="<p>%%scrap%%</p>" --><p>For a list of all members of this type, see <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet_members.html">XLSheet members</a>.</p><!--DXMETADATA end --> <a name="PropertiesBookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=public" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=publicProperties,caption=$$Public$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><div class="SectionHeading" id="publicPropertiesSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Public Properties</span></div><div id="publicPropertiesSectionContent" class="SectionContent"><table class="FilteredItemListTable"><tr><th> </th><th>Name</th><th>Description</th></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Book.html">Book</a></td><td class="MembersDescriptionCell">Gets a reference to the <a href="C1.WPF.Excel.4~C1.WPF.Excel.C1XLBook.html">C1XLBook</a> that owns the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~ColumnMaxLevel.html">ColumnMaxLevel</a></td><td class="MembersDescriptionCell">Gets maximum outline level for columns. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Columns.html">Columns</a></td><td class="MembersDescriptionCell">Gets a reference to sheet's column collection. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Comments.html">Comments</a></td><td class="MembersDescriptionCell">Gets an <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCommentCollection.html">XLCommentCollection</a> that contains the collection of comments that on the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~ConditionalFormattings.html">ConditionalFormattings</a></td><td class="MembersDescriptionCell">Gets the collection of <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLConditionalFormatting.html">XLConditionalFormatting</a> objects for the current workbook. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~DefaultColumnWidth.html">DefaultColumnWidth</a></td><td class="MembersDescriptionCell">Gets or sets the default column width for the sheet (in twips). </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~DefaultRowHeight.html">DefaultRowHeight</a></td><td class="MembersDescriptionCell">Gets or sets the default row height for the sheet (in twips). </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~GridColor.html">GridColor</a></td><td class="MembersDescriptionCell">Gets or sets the color used to display gridlines. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Item.html">Item</a></td><td class="MembersDescriptionCell">Gets the cell at a specified position on the sheet, creating a new cell if necessary. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Locked.html">Locked</a></td><td class="MembersDescriptionCell">Gets or sets a value that determines if the sheet is locked for editing. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~MaxOutlineLevel.html">MaxOutlineLevel</a></td><td class="MembersDescriptionCell">Gets the maximum subtotals outline level for rows or columns. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~MergedCells.html">MergedCells</a></td><td class="MembersDescriptionCell">Gets an <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRangeCollection.html">XLCellRangeCollection</a> that contains the collection of cells that are merged on the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Name.html">Name</a></td><td class="MembersDescriptionCell">Gets or sets the name of the <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet</a>. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~OutlinesBelow.html">OutlinesBelow</a></td><td class="MembersDescriptionCell">Gets or sets a value indicating the vertical location of outline buttons. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~OutlinesRight.html">OutlinesRight</a></td><td class="MembersDescriptionCell">Gets or sets a value indicating the horizontal location of outline buttons. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~PageBreakPreview.html">PageBreakPreview</a></td><td class="MembersDescriptionCell">Gets or sets whether Excel should show page break preview when displaying the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~PrintSettings.html">PrintSettings</a></td><td class="MembersDescriptionCell">Gets or sets an <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLPrintSettings.html">XLPrintSettings</a> object that controls how the sheet is printed. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~RowMaxLevel.html">RowMaxLevel</a></td><td class="MembersDescriptionCell">Gets maximum outline level for rows. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Rows.html">Rows</a></td><td class="MembersDescriptionCell">Gets a reference to the sheet's row collection. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Scale.html">Scale</a></td><td class="MembersDescriptionCell">Gets or sets the view scale of this worksheet using percentages. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~SelectedCells.html">SelectedCells</a></td><td class="MembersDescriptionCell">Gets an <a href="C1.WPF.Excel.4~C1.WPF.Excel.XLCellRangeCollection.html">XLCellRangeCollection</a> that contains the collection of cells that are selected on the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Shapes.html">Shapes</a></td><td class="MembersDescriptionCell">Gets a reference to the <a href="C1.WPF.Excel.4~C1.WPF.Excel.ShapeCollection.html">ShapeCollection</a> for the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~ShowGridLines.html">ShowGridLines</a></td><td class="MembersDescriptionCell">Gets or sets whether Excel should show the grid lines when displaying the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~ShowHeaders.html">ShowHeaders</a></td><td class="MembersDescriptionCell">Gets or sets whether Excel should show the row and column headers when displaying the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~ShowZeros.html">ShowZeros</a></td><td class="MembersDescriptionCell">Gets or sets whether Excel should show the zero values on the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~TabColor.html">TabColor</a></td><td class="MembersDescriptionCell">Gets or sets the color used to display the tab of this sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~TotalsBelowData.html">TotalsBelowData</a></td><td class="MembersDescriptionCell">Gets whether Excel should show the subtotals data when displaying the sheet. </td></tr> <tr><td class="ImageCell"><img alt="Public Property" src="dotnetimages/publicProperty.png"></td><td class='MembersLinkCell'><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet~Visible.html">Visible</a></td><td class="MembersDescriptionCell">Gets or sets the sheet's visibility. </td></tr> </table><a href="#top">Top</a></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=protected+protected friend+friend" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=protectedProperties,caption=$$Protected$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MEMBER_LIST" namespace="property" source="Item" filter="scope=private" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=privateProperties,caption=$$Private$$ $$Properties$$%%%%filtereditemlist%%<a href="#top">$$Top$$</a></div>" --><!--DXMETADATA end --> <a name="seealsobookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORIZED_LINKS" namespace="linkcategory" source="Item" filter="type=members" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""$$See_Also$$%%designlist:tagidentifier=##SEEALSO,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><h4 class="subHeading">Reference</h4><p><a href="C1.WPF.Excel.4~C1.WPF.Excel.XLSheet.html">XLSheet Class</a> <br><a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> </p> </div><!--DXMETADATA end--> </div> <div id="FooterContent"> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p> </p><p> </p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end--> </div> </body> </html>