Office Open XML - SpreadsheetML: Formulas

[Content_Types].xml

<?xml version="1.0" encoding="utf-8"?>
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">
  <Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" />
  <Default Extension="xml" ContentType="application/xml" />
  <Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" />
  <Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" />
  <Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml" />
  <Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" />
  <Override PartName="/xl/calcChain.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.calcChain+xml" />
  <Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml" />
  <Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml" />
</Types>

_rels/.rels

<?xml version="1.0" encoding="utf-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml" />
  <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties"   Target="docProps/core.xml"/>
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"      Target="xl/workbook.xml"  />
</Relationships>

docProps/core.xml

<?xml version="1.0" encoding="utf-8"?>
<cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
</cp:coreProperties>

docProps/app.xml

<?xml version="1.0" encoding="utf-8"?>
<Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes">
</Properties>

xl/_rels/workbook.xml.rels

<?xml version="1.0" encoding="utf-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml" />
  <Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/calcChain" Target="calcChain.xml"         />
</Relationships>

xl/calcChain.xml

<?xml version="1.0" encoding="utf-8"?>
<calcChain xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <c r="A3"  i="1"  />
  <c r="A4"  i="1"  />
  <c r="A5"  i="1"  />
  <c r="A6"  i="1"  />
  <c r="A7"  i="1"  />
  <c r="A8"  i="1"  />
  <c r="A9"  i="1"  />
  <c r="A10" i="1"  />
  <c r="A11" i="1"  />
</calcChain>

xl/workbook.xml

<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  <fileVersion appName="xl" lastEdited="4" lowestEdited="4" rupBuild="4507" />
  <bookViews>
    <workbookView xWindow="120" yWindow="90" windowWidth="28515" windowHeight="14370" />
  </bookViews>
  <sheets>
    <sheet name="Name of Sheet" sheetId="1" r:id="rId1" />
  </sheets>
  <calcPr calcId="145621" />
</workbook>

xl/worksheets/sheet1.xml

<?xml version="1.0" encoding="utf-8"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  <sheetData>

    <row r="1" ><c r="A1" >                   <v> 1</v></c></row>
    <row r="2" ><c r="A2" >                   <v> 1</v></c></row>
    <row r="3" ><c r="A3" > <f>SUM(A1:A2) </f><v> 2</v></c></row>
    <row r="4" ><c r="A4" > <f>SUM(A2:A3) </f><v> 3</v></c></row>
    <row r="5" ><c r="A5" > <f>SUM(A3:A4) </f><v> 5</v></c></row>
    <row r="6" ><c r="A6" > <f>SUM(A4:A5) </f><v> 8</v></c></row>
    <row r="7" ><c r="A7" > <f>SUM(A5:A6) </f><v>13</v></c></row>
    <row r="8" ><c r="A8" > <f>SUM(A6:A7) </f><v>21</v></c></row>
    <row r="9" ><c r="A9" > <f>SUM(A7:A8) </f><v>34</v></c></row>
    <row r="10"><c r="A10"> <f>SUM(A8:A9) </f><v>55</v></c></row>
    <row r="11"><c r="A11"> <f>SUM(A9:A10)</f><v>89</v></c></row>

  </sheetData>
</worksheet>

See also