[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_Ref (Cell References)

This simple type defines a reference to a range of cells within a sheet in the workbook. A reference identifies a cell or a range of cells on a worksheet and tells the application where to look for the values or data you want to use in a formula. With references, you can use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas. You can also refer to cells on other sheets in the same workbook, and to other workbooks. References to cells in other workbooks are called links.

SpreadsheetML defines two reference styles defined in the ST_RefMode simple type.

This simple type's contents are a restriction of the XML Schema string datatype.

Referenced By

autoFilter@ref3.3.1.1); comment@ref3.7.3); dataRef@ref3.3.1.28); dimension@ref3.3.1.33); hyperlink@ref3.3.1.44); location@ref3.10.1.49); mergeCell@ref3.3.1.53); oleSize@ref3.2.16); pivotArea@offset3.3.1.66); raf@ref3.11.1.8); rangeSet@ref3.10.1.79); rm@destination3.11.1.19); rm@source3.11.1.19); rqt@ref3.11.1.20); rrc@ref3.11.1.21); sheetPr@syncRef3.3.1.79); sortCondition@ref3.3.1.88); sortState@ref3.3.1.89); ST_Ref3.18.64); table@ref3.5.1.2); webPublishItem@sourceRef3.3.1.94); worksheetSource@ref3.10.1.95)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_Ref">

   <restriction base="xsd:string"/>

</simpleType>