2.2.15 CT_WorksheetOptions

  • Article

Referenced by: CT_Worksheet

A collection of settings and options for the sheet (1).

Attributes:

DoNotDisplayGridlines: Specifies whether the gridlines are visible.

  • This attribute MUST be present if the Chartsheet            attribute of the CT_Worksheet element is false and there are no gridlines present on the worksheet.

  • This attribute MUST NOT be present if the Chartsheet attribute of the CT_Worksheet element is true.

  • This attribute MUST NOT be present if the Chartsheet            attribute of the CT_Worksheet element is false and there are gridlines present on the worksheet.

DoNotDisplayHeadings: Specifies whether row and column headers are visible.

  • This attribute MUST be present if the Chartsheet            attribute of the CT_Worksheet element is false and row and column headers are not visible .

  • This attribute MUST NOT be present if the Chartsheet attribute of the CT_Worksheet element is true.

  • This attribute MUST NOT be present if the Chartsheet attribute of the CT_Worksheet element is false and row and column headers are visible .

DisplayRightToLeft: Specifies whether the sheet or named object is displayed in right-to-left format. This attribute (2) MUST be present if the sheet (1) or named object represented by the CT_Worksheet element is displayed right-to-left. This attribute MUST NOT be present if the sheet or named object is displayed left-to-right.

TabColor: The color of the sheet tab for the sheet represented by the CT_Worksheet element, or the color of the sheet tab for the sheet on which the named object represented by the CT_Worksheet element resides. This attribute MUST be present if the default sheet tab color is not set and MUST NOT be present otherwise.

DisplayOutlines: Specifies whether outlines are displayed on the sheet. This attribute MUST be present and equal to true if the sheet displays outlines and MUST NOT be present otherwise.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_WorksheetOptions">
   <xs:attribute name="DoNotDisplayGridlines" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="DoNotDisplayHeadings" type="xs:boolean" use="optional"/>
   <xs:attribute name="DisplayRightToLeft" type="xs:boolean" use="optional"/>
   <xs:attribute name="TabColor" type="ST_rgbTuple" use="optional"/>
   <xs:attribute name="DisplayOutlines" type="xs:boolean" default="false" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).