[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This simple type defines the supported reference styles or modes for a workbook in SpreadsheetML.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
A1 (A1 Mode) |
Indicates that the workbook uses A1 reference style. This is the default for SpreadsheetML. A1 reference style refers to columns with letters and refers to rows with numbers. For example, A1 refers to the cell at the intersection of column A and row 1. |
|
R1C1 (R1C1 Reference Mode) |
Indicates that the workbook uses the R1C1 reference style. R1C1 reference style refers to both the rows and the columns on the worksheet with numbers. The location of a cell is indicated with an "R" followed by a row number and a "C" followed by a column number. For example, R1C1 refers to the cell at the intersection of row R1 and column C1. |
|
Referenced By |
|
calcPr@refMode (§3.2.2) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_RefMode">
<restriction base="xsd:string">
<enumeration value="A1"/>
<enumeration value="R1C1"/>
</restriction>
</simpleType>