<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<office:document-content
                xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
                xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
                xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
                xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
                xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
                xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
                xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
                office:version="1.2">
  <office:body>
    <office:spreadsheet>
      <table:table table:name="test">
        <table:table-row>
          <table:table-cell table:formula="of:=[.B1]"/>
          <table:table-cell table:formula="of:=[.C1]"/>
          <table:table-cell table:formula="of:=[.A1]"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell table:formula="of:=[.B2]"/>
          <table:table-cell table:formula="of:=[.C2]"/>
          <table:table-cell office:value-type="float" office:value="1"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell office:value-type="string"><text:p>ab</text:p></table:table-cell>
          <table:table-cell table:formula="of:=[.A3]"/>
          <table:table-cell table:formula="of:=[.B3]"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell office:value-type="float" office:value="1"/>
          <table:table-cell office:value-type="string"><text:p>a</text:p></table:table-cell>
          <table:table-cell/>
          <table:table-cell office:value-type="float" office:value="3.5"/>
          <table:table-cell office:value-type="string"><text:p>MIN</text:p></table:table-cell>
          <table:table-cell table:formula="of:=MIN([.A4:.D4];2)"/>
          <table:table-cell office:value-type="string"><text:p>MIN</text:p></table:table-cell>
          <table:table-cell table:formula="of:=MAX([.A4:.D4])"/>
          <table:table-cell office:value-type="string"><text:p>SUM</text:p></table:table-cell>
          <table:table-cell table:formula="of:=SUM([.A4:.D4])"/>
          <table:table-cell office:value-type="string"><text:p>AVERAGE</text:p></table:table-cell>
          <table:table-cell table:formula="of:=AVERAGE([.A4:.D4])"/>
          <table:table-cell office:value-type="string"><text:p>COUNT</text:p></table:table-cell>
          <table:table-cell table:formula="of:=COUNT([.A4:.D4])"/>
          <table:table-cell office:value-type="string"><text:p>COUNTA</text:p></table:table-cell>
          <table:table-cell table:formula="of:=COUNTA([.A4:.D4])"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell office:value-type="string"><text:p>abcdef</text:p></table:table-cell>
          <table:table-cell table:formula="of:=LEN([.A5])"/>
          <table:table-cell table:formula="of:=LEFT([.A5];0)"/>
          <table:table-cell table:formula="of:=LEFT([.A5];1)"/>
          <table:table-cell table:formula="of:=LEFT([.A5];10)"/>
          <table:table-cell table:formula="of:=RIGHT([.A5];0)"/>
          <table:table-cell table:formula="of:=RIGHT([.A5];1)"/>
          <table:table-cell table:formula="of:=RIGHT([.A5];10)"/>
          <table:table-cell table:formula="of:=MID([.A5];0;1)"/>
          <table:table-cell table:formula="of:=MID([.A5];1;0)"/>
          <table:table-cell table:formula="of:=MID([.A5];1;1)"/>
          <table:table-cell table:formula="of:=MID([.A5];1;10)"/>
          <table:table-cell table:formula="of:=MID([.A5];10;1)"/>
          <table:table-cell table:formula="of:=MID([.A5];1;1)"/>
          <table:table-cell table:formula="of:=MID([.A5];5;2)"/>
          <table:table-cell table:formula="of:=MID([.A5];5;3)"/>
        </table:table-row>

        <!-- Evaluates to 1 -->
        <table:table-row>
          <table:table-cell table:formula="of:=SQRT(ABS(-MOD(COS(ACOS(SIN(ASIN(4*ATAN(LN(EXP(1+2*(6/3)-4)))/PI()))))*3;2)))"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell table:formula="of:=&quot;A&quot;&amp;&quot;B&quot;"/>
        </table:table-row>

        <table:table-row>
          <table:table-cell table:formula="of:=IF(1;2)"/>
          <table:table-cell table:formula="of:=IF(1;2;3)"/>
          <table:table-cell table:formula="of:=IF(0;2)"/>
          <table:table-cell table:formula="of:=IF(0;2;3)"/>
          <table:table-cell table:formula="of:=TRUE"/>
          <table:table-cell table:formula="of:=FALSE"/>
          <table:table-cell table:formula="of:=OR(FALSE;FALSE)"/>
          <table:table-cell table:formula="of:=OR(FALSE;TRUE)"/>
          <table:table-cell table:formula="of:=OR(TRUE;FALSE)"/>
          <table:table-cell table:formula="of:=OR(TRUE;TRUE)"/>
          <table:table-cell table:formula="of:=AND(FALSE;FALSE)"/>
          <table:table-cell table:formula="of:=AND(FALSE;TRUE)"/>
          <table:table-cell table:formula="of:=AND(TRUE;FALSE)"/>
          <table:table-cell table:formula="of:=AND(TRUE;TRUE)"/>
          <table:table-cell table:formula="of:=NOT(FALSE)"/>
          <table:table-cell table:formula="of:=NOT(TRUE)"/>
        </table:table-row>

        <!-- Evaluates to TRUE -->
        <table:table-row>
          <table:table-cell table:formula="of:=1=1"/>
          <table:table-cell table:formula="of:=1&lt;&gt;2"/>
          <table:table-cell table:formula="of:=1&lt;2"/>
          <table:table-cell table:formula="of:=1&lt;=1"/>
          <table:table-cell table:formula="of:=1&gt;0"/>
          <table:table-cell table:formula="of:=1&gt;=1"/>

          <table:table-cell table:formula="of:=1.0=1"/>
          <table:table-cell table:formula="of:=1.0&lt;&gt;2"/>
          <table:table-cell table:formula="of:=1.0&lt;2"/>
          <table:table-cell table:formula="of:=1.0&lt;=1"/>
          <table:table-cell table:formula="of:=1.0&gt;0"/>
          <table:table-cell table:formula="of:=1.0&gt;=1"/>

          <table:table-cell table:formula="of:=1=1.0"/>
          <table:table-cell table:formula="of:=1&lt;&gt;2.0"/>
          <table:table-cell table:formula="of:=1&lt;2.0"/>
          <table:table-cell table:formula="of:=1&lt;=1.0"/>
          <table:table-cell table:formula="of:=1&gt;0.0"/>
          <table:table-cell table:formula="of:=1&gt;=1.0"/>

          <table:table-cell table:formula="of:=1.0=1.0"/>
          <table:table-cell table:formula="of:=1.0&lt;&gt;2.0"/>
          <table:table-cell table:formula="of:=1.0&lt;2.0"/>
          <table:table-cell table:formula="of:=1.0&lt;=1.0"/>
          <table:table-cell table:formula="of:=1.0&gt;0.0"/>
          <table:table-cell table:formula="of:=1.0&gt;=1.0"/>

          <table:table-cell table:formula="of:=&quot;A&quot;=&quot;A&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&lt;&gt;&quot;B&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&lt;=&quot;B&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&lt;&quot;B&quot;"/>
          <table:table-cell table:formula="of:=&quot;B&quot;&gt;=&quot;A&quot;"/>
          <table:table-cell table:formula="of:=&quot;B&quot;&gt;&quot;A&quot;"/>

          <table:table-cell table:formula="of:=&quot;A&quot;&lt;&quot;b&quot;"/>
          <table:table-cell table:formula="of:=&quot;a&quot;&lt;&quot;B&quot;"/>
        </table:table-row>

        <!-- Evaluates to FALSE -->
        <table:table-row>
          <table:table-cell table:formula="of:=1=2"/>
          <table:table-cell table:formula="of:=1&lt;&gt;1"/>
          <table:table-cell table:formula="of:=1&lt;1"/>
          <table:table-cell table:formula="of:=1&lt;=0"/>
          <table:table-cell table:formula="of:=1&gt;1"/>
          <table:table-cell table:formula="of:=1&gt;=2"/>

          <table:table-cell table:formula="of:=1.0=2"/>
          <table:table-cell table:formula="of:=1.0&lt;&gt;1"/>
          <table:table-cell table:formula="of:=1.0&lt;1"/>
          <table:table-cell table:formula="of:=1.0&lt;=0"/>
          <table:table-cell table:formula="of:=1.0&gt;1"/>
          <table:table-cell table:formula="of:=1.0&gt;=2"/>

          <table:table-cell table:formula="of:=1=2.0"/>
          <table:table-cell table:formula="of:=1&lt;&gt;1.0"/>
          <table:table-cell table:formula="of:=1&lt;1.0"/>
          <table:table-cell table:formula="of:=1&lt;=0.0"/>
          <table:table-cell table:formula="of:=1&gt;1.0"/>
          <table:table-cell table:formula="of:=1&gt;=2.0"/>

          <table:table-cell table:formula="of:=1.0=2.0"/>
          <table:table-cell table:formula="of:=1.0&lt;&gt;1.0"/>
          <table:table-cell table:formula="of:=1.0&lt;1.0"/>
          <table:table-cell table:formula="of:=1.0&lt;=0.0"/>
          <table:table-cell table:formula="of:=1.0&gt;1.0"/>
          <table:table-cell table:formula="of:=1.0&gt;=2.0"/>

          <table:table-cell table:formula="of:=&quot;A&quot;=&quot;B&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&lt;&gt;&quot;A&quot;"/>
          <table:table-cell table:formula="of:=&quot;B&quot;&lt;=&quot;A&quot;"/>
          <table:table-cell table:formula="of:=&quot;B&quot;&lt;&quot;A&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&gt;=&quot;B&quot;"/>
          <table:table-cell table:formula="of:=&quot;A&quot;&gt;&quot;B&quot;"/>

          <table:table-cell table:formula="of:=&quot;B&quot;&lt;&quot;a&quot;"/>
          <table:table-cell table:formula="of:=&quot;b&quot;&lt;&quot;A&quot;"/>
        </table:table-row>
      </table:table>
    </office:spreadsheet>
  </office:body>
</office:document-content>
