sw/qa/extras/ooxmlexport/data/tdf136404.fodt

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:officeooo="http://openoffice.org/2009/office" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:ooow="http://openoffice.org/2004/writer" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.text">
   3  <office:styles>
   4   <style:style style:name="Standard" style:family="paragraph" style:class="text"/>
   5   <style:default-style style:family="paragraph">
   6    <style:text-properties fo:language="en" fo:country="US"/>
   7   </style:default-style>
   8  </office:styles>
   9  <office:body>
  10   <office:text>
  11    <table:table>
  12     <table:table-column/>
  13     <table:table-column/>
  14     <table:table-column/>
  15     <table:table-column/>
  16     <table:table-column/>
  17     <table:table-column/>
  18     <table:table-column/>
  19     <table:table-row>
  20      <table:table-cell office:value-type="string">
  21       <text:p>6</text:p>
  22      </table:table-cell>
  23      <table:table-cell office:value-type="string">
  24       <text:p></text:p>
  25      </table:table-cell>
  26      <table:table-cell office:value-type="string">
  27       <text:p></text:p>
  28      </table:table-cell>
  29      <table:table-cell office:value-type="string">
  30       <text:p>10</text:p>
  31      </table:table-cell>
  32      <table:table-cell office:value-type="string">
  33       <text:p>text</text:p>
  34      </table:table-cell>
  35      <table:table-cell office:value-type="string">
  36       <text:p>text</text:p>
  37      </table:table-cell>
  38     </table:table-row>
  39     <table:table-row>
  40      <table:table-cell table:formula="ooow:COUNT(&lt;A1:F1&gt;)" office:value-type="float" office:value="2">
  41       <text:p>2</text:p>
  42      </table:table-cell>
  43      <table:table-cell table:formula="ooow:AVERAGE(&lt;A1:F1&gt;)" office:value-type="float" office:value="0">
  44       <text:p>8</text:p>
  45      </table:table-cell>
  46      <table:table-cell table:formula="ooow:PRODUCT(&lt;A1:F1&gt;)" office:value-type="float" office:value="60">
  47       <text:p>60</text:p>
  48      </table:table-cell>
  49      <table:table-cell table:formula="ooow:COUNT(&lt;B1&gt;)" office:value-type="float" office:value="0">
  50       <text:p>0</text:p>
  51      </table:table-cell>
  52      <table:table-cell table:formula="ooow:COUNT(&lt;B1:C1&gt;)" office:value-type="float" office:value="0">
  53       <text:p>0</text:p>
  54      </table:table-cell>
  55      <table:table-cell table:formula="ooow:AVERAGE(&lt;B1&gt;)" office:value-type="float" office:value="1.79769313486232E+308">
  56       <text:p text:style-name="P1">** Expression is faulty **</text:p>
  57      </table:table-cell>
  58      <table:table-cell table:formula="ooow:AVERAGE(&lt;B1:C1&gt;)" office:value-type="float" office:value="1.79769313486232E+308">
  59       <text:p text:style-name="P1">** Expression is faulty **</text:p>
  60      </table:table-cell>
  61     </table:table-row>
  62    </table:table>
  63   </office:text>
  64  </office:body>
  65 </office:document>