Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_CellFormula
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:ST_Formula
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into bx in schema sml-sheet_xsd Drilldown into si in schema sml-sheet_xsd Drilldown into ca in schema sml-sheet_xsd Drilldown into r2 in schema sml-sheet_xsd Drilldown into r1 in schema sml-sheet_xsd Drilldown into del2 in schema sml-sheet_xsd Drilldown into del1 in schema sml-sheet_xsd Drilldown into dtr in schema sml-sheet_xsd Drilldown into dt2D in schema sml-sheet_xsd Drilldown into ref in schema sml-sheet_xsd Drilldown into aca in schema sml-sheet_xsd Drilldown into t in schema sml-sheet_xsdXSD Diagram of CT_CellFormula in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_CellFormula">
    <xsd:simpleContent>
        <xsd:extension base="ST_Formula">
            <xsd:attribute name="t" type="ST_CellFormulaType" use="optional" default="normal">
                <xsd:annotation>
                    <xsd:documentation>Formula Type</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="aca" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Always Calculate Array</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="ref" type="ST_Ref" use="optional">
                <xsd:annotation>
                    <xsd:documentation>Range of Cells</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="dt2D" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Data Table 2-D</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="dtr" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Data Table Row</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="del1" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Input 1 Deleted</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="del2" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Input 2 Deleted</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="r1" type="ST_CellRef" use="optional">
                <xsd:annotation>
                    <xsd:documentation>Data Table Cell 1</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="r2" type="ST_CellRef" use="optional">
                <xsd:annotation>
                    <xsd:documentation>Input Cell 2</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="ca" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Calculate Cell</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="si" type="xsd:unsignedInt" use="optional">
                <xsd:annotation>
                    <xsd:documentation>Shared Group Index</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
            <xsd:attribute name="bx" type="xsd:boolean" use="optional" default="false">
                <xsd:annotation>
                    <xsd:documentation>Assigns Value to Name</xsd:documentation>
                </xsd:annotation>
            </xsd:attribute>
        </xsd:extension>
    </xsd:simpleContent>
</xsd:complexType>
Collapse Child Attributes:
Name Type Default Value Use
t nsM:t normal Optional
aca nsM:aca false Optional
ref nsM:ref Optional
dt2D nsM:dt2D false Optional
dtr nsM:dtr false Optional
del1 nsM:del1 false Optional
del2 nsM:del2 false Optional
r1 nsM:r1 Optional
r2 nsM:r2 Optional
ca nsM:ca false Optional
si nsM:si Optional
bx nsM:bx false Optional
Collapse Derivation Tree:
Collapse References:
nsM:f
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0