sc/qa/unit/data/functions/database/fods/daverage.fods

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3 <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:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
   4  <office:styles>
   5   <style:default-style style:family="table-cell">
   6    <style:paragraph-properties style:tab-stop-distance="36pt"/>
   7    <style:text-properties style:font-name="Liberation Sans" fo:language="en" fo:country="US" style:font-name-asian="DejaVu Sans" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="DejaVu Sans" style:language-complex="hi" style:country-complex="IN"/>
   8   </style:default-style>
   9   <number:number-style style:name="N0">
  10    <number:number number:min-integer-digits="1"/>
  11   </number:number-style>
  12   <number:currency-style style:name="N108P0" style:volatile="true">
  13    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  14    <number:text> </number:text>
  15    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  16   </number:currency-style>
  17   <number:currency-style style:name="N108">
  18    <style:text-properties fo:color="#ff0000"/>
  19    <number:text>-</number:text>
  20    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  21    <number:text> </number:text>
  22    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  23    <style:map style:condition="value()&gt;=0" style:apply-style-name="N108P0"/>
  24   </number:currency-style>
  25   <number:currency-style style:name="N110P0" style:volatile="true">
  26    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  27    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  28   </number:currency-style>
  29   <number:currency-style style:name="N110">
  30    <number:text>-</number:text>
  31    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  32    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  33    <style:map style:condition="value()&gt;=0" style:apply-style-name="N110P0"/>
  34   </number:currency-style>
  35   <number:currency-style style:name="N112P0" style:volatile="true">
  36    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  37    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  38   </number:currency-style>
  39   <number:currency-style style:name="N112">
  40    <number:text>-</number:text>
  41    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  42    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  43    <style:map style:condition="value()&gt;=0" style:apply-style-name="N112P0"/>
  44   </number:currency-style>
  45   <number:currency-style style:name="N113P0" style:volatile="true">
  46    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  47    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  48   </number:currency-style>
  49   <number:currency-style style:name="N113">
  50    <style:text-properties fo:color="#ff0000"/>
  51    <number:text>-</number:text>
  52    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  53    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  54    <style:map style:condition="value()&gt;=0" style:apply-style-name="N113P0"/>
  55   </number:currency-style>
  56   <number:currency-style style:name="N114P0" style:volatile="true">
  57    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  58    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  59   </number:currency-style>
  60   <number:currency-style style:name="N114">
  61    <style:text-properties fo:color="#ff0000"/>
  62    <number:text>-</number:text>
  63    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  64    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  65    <style:map style:condition="value()&gt;=0" style:apply-style-name="N114P0"/>
  66   </number:currency-style>
  67   <number:currency-style style:name="N116P0" style:volatile="true">
  68    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  69    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
  70   </number:currency-style>
  71   <number:currency-style style:name="N116">
  72    <style:text-properties fo:color="#ff0000"/>
  73    <number:text>-</number:text>
  74    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  75    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
  76    <style:map style:condition="value()&gt;=0" style:apply-style-name="N116P0"/>
  77   </number:currency-style>
  78   <number:number-style style:name="N118P0" style:volatile="true">
  79    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  80    <number:text> </number:text>
  81   </number:number-style>
  82   <number:number-style style:name="N118">
  83    <number:text>(</number:text>
  84    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  85    <number:text>)</number:text>
  86    <style:map style:condition="value()&gt;=0" style:apply-style-name="N118P0"/>
  87   </number:number-style>
  88   <number:number-style style:name="N120P0" style:volatile="true">
  89    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  90    <number:text> </number:text>
  91   </number:number-style>
  92   <number:number-style style:name="N120">
  93    <number:text>(</number:text>
  94    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  95    <number:text>)</number:text>
  96    <style:map style:condition="value()&gt;=0" style:apply-style-name="N120P0"/>
  97   </number:number-style>
  98   <number:currency-style style:name="N122P0" style:volatile="true">
  99    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 100    <loext:fill-character> </loext:fill-character>
 101    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 102   </number:currency-style>
 103   <number:currency-style style:name="N122">
 104    <number:text>-</number:text>
 105    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 106    <loext:fill-character> </loext:fill-character>
 107    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 108    <style:map style:condition="value()&gt;=0" style:apply-style-name="N122P0"/>
 109   </number:currency-style>
 110   <number:currency-style style:name="N124P0" style:volatile="true">
 111    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 112    <loext:fill-character> </loext:fill-character>
 113    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 114   </number:currency-style>
 115   <number:currency-style style:name="N124">
 116    <number:text>-</number:text>
 117    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 118    <loext:fill-character> </loext:fill-character>
 119    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 120    <style:map style:condition="value()&gt;=0" style:apply-style-name="N124P0"/>
 121   </number:currency-style>
 122   <number:currency-style style:name="N126P0" style:volatile="true">
 123    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 124    <number:text> </number:text>
 125    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 126   </number:currency-style>
 127   <number:currency-style style:name="N126">
 128    <number:text>-</number:text>
 129    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 130    <number:text> </number:text>
 131    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 132    <style:map style:condition="value()&gt;=0" style:apply-style-name="N126P0"/>
 133   </number:currency-style>
 134   <number:currency-style style:name="N127P0" style:volatile="true">
 135    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 136    <number:text> </number:text>
 137    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 138   </number:currency-style>
 139   <number:currency-style style:name="N127">
 140    <number:text>-</number:text>
 141    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 142    <number:text> </number:text>
 143    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 144    <style:map style:condition="value()&gt;=0" style:apply-style-name="N127P0"/>
 145   </number:currency-style>
 146   <number:currency-style style:name="N128P0" style:volatile="true">
 147    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 148    <number:text> </number:text>
 149    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 150   </number:currency-style>
 151   <number:currency-style style:name="N128">
 152    <style:text-properties fo:color="#ff0000"/>
 153    <number:text>-</number:text>
 154    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 155    <number:text> </number:text>
 156    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 157    <style:map style:condition="value()&gt;=0" style:apply-style-name="N128P0"/>
 158   </number:currency-style>
 159   <number:currency-style style:name="N130P0" style:volatile="true">
 160    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 161    <number:text> </number:text>
 162    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 163   </number:currency-style>
 164   <number:currency-style style:name="N130">
 165    <style:text-properties fo:color="#ff0000"/>
 166    <number:text>-</number:text>
 167    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 168    <number:text> </number:text>
 169    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 170    <style:map style:condition="value()&gt;=0" style:apply-style-name="N130P0"/>
 171   </number:currency-style>
 172   <number:currency-style style:name="N132P0" style:volatile="true">
 173    <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
 174    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 175   </number:currency-style>
 176   <number:currency-style style:name="N132">
 177    <style:text-properties fo:color="#ff0000"/>
 178    <number:text>-</number:text>
 179    <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
 180    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 181    <style:map style:condition="value()&gt;=0" style:apply-style-name="N132P0"/>
 182   </number:currency-style>
 183   <number:number-style style:name="N133">
 184    <number:number number:decimal-places="9" loext:min-decimal-places="9" number:min-integer-digits="1"/>
 185   </number:number-style>
 186   <number:number-style style:name="N134">
 187    <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
 188   </number:number-style>
 189   <number:number-style style:name="N135">
 190    <number:number number:decimal-places="10" loext:min-decimal-places="10" number:min-integer-digits="1"/>
 191   </number:number-style>
 192   <number:number-style style:name="N136">
 193    <number:number number:decimal-places="11" loext:min-decimal-places="11" number:min-integer-digits="1"/>
 194   </number:number-style>
 195   <number:number-style style:name="N137">
 196    <number:number number:decimal-places="12" loext:min-decimal-places="12" number:min-integer-digits="1"/>
 197   </number:number-style>
 198   <number:number-style style:name="N138">
 199    <number:number number:decimal-places="13" loext:min-decimal-places="13" number:min-integer-digits="1"/>
 200   </number:number-style>
 201   <number:number-style style:name="N139">
 202    <number:number number:decimal-places="14" loext:min-decimal-places="14" number:min-integer-digits="1"/>
 203   </number:number-style>
 204   <number:number-style style:name="N140">
 205    <number:number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1"/>
 206   </number:number-style>
 207   <number:number-style style:name="N141">
 208    <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/>
 209   </number:number-style>
 210   <number:number-style style:name="N142">
 211    <number:number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1"/>
 212   </number:number-style>
 213   <number:number-style style:name="N143">
 214    <number:number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1"/>
 215   </number:number-style>
 216   <style:style style:name="Default" style:family="table-cell">
 217    <style:text-properties style:font-name-asian="Droid Sans Fallback" style:font-family-asian="&apos;Droid Sans Fallback&apos;" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-name-complex="Droid Sans Devanagari" style:font-family-complex="&apos;Droid Sans Devanagari&apos;" style:font-family-generic-complex="system" style:font-pitch-complex="variable"/>
 218   </style:style>
 219   <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
 220    <style:text-properties fo:font-style="italic" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="font-color" fo:font-weight="bold"/>
 221   </style:style>
 222   <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N108"/>
 223   <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
 224    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 225    <style:paragraph-properties fo:text-align="center"/>
 226    <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
 227   </style:style>
 228   <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
 229    <style:table-cell-properties style:rotation-angle="90"/>
 230   </style:style>
 231   <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
 232    <style:table-cell-properties fo:background-color="#ff3333"/>
 233   </style:style>
 234   <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
 235    <style:table-cell-properties fo:background-color="#99ff66"/>
 236   </style:style>
 237  </office:styles>
 238  <office:automatic-styles>
 239   <style:style style:name="co1" style:family="table-column">
 240    <style:table-column-properties fo:break-before="auto" style:column-width="185.7pt"/>
 241   </style:style>
 242   <style:style style:name="co2" style:family="table-column">
 243    <style:table-column-properties fo:break-before="auto" style:column-width="252.51pt"/>
 244   </style:style>
 245   <style:style style:name="co3" style:family="table-column">
 246    <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
 247   </style:style>
 248   <style:style style:name="co4" style:family="table-column">
 249    <style:table-column-properties fo:break-before="auto" style:column-width="70.44pt"/>
 250   </style:style>
 251   <style:style style:name="co5" style:family="table-column">
 252    <style:table-column-properties fo:break-before="auto" style:column-width="72.71pt"/>
 253   </style:style>
 254   <style:style style:name="co6" style:family="table-column">
 255    <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/>
 256   </style:style>
 257   <style:style style:name="co7" style:family="table-column">
 258    <style:table-column-properties fo:break-before="auto" style:column-width="178.44pt"/>
 259   </style:style>
 260   <style:style style:name="co8" style:family="table-column">
 261    <style:table-column-properties fo:break-before="auto" style:column-width="50.94pt"/>
 262   </style:style>
 263   <style:style style:name="co9" style:family="table-column">
 264    <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/>
 265   </style:style>
 266   <style:style style:name="ro1" style:family="table-row">
 267    <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 268   </style:style>
 269   <style:style style:name="ro2" style:family="table-row">
 270    <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 271   </style:style>
 272   <style:style style:name="ro3" style:family="table-row">
 273    <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 274   </style:style>
 275   <style:style style:name="ro4" style:family="table-row">
 276    <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 277   </style:style>
 278   <style:style style:name="ro5" style:family="table-row">
 279    <style:table-row-properties style:row-height="13.21pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 280   </style:style>
 281   <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
 282    <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
 283   </style:style>
 284   <number:boolean-style style:name="N99">
 285    <number:boolean/>
 286   </number:boolean-style>
 287   <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
 288    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 289    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 290    <style:text-properties style:text-position="" fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/>
 291   </style:style>
 292   <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
 293    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 294    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 295    <style:text-properties style:text-position="" fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/>
 296   </style:style>
 297   <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
 298    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 299    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 300    <style:text-properties style:text-position="" fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/>
 301   </style:style>
 302   <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
 303    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 304    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 305    <style:text-properties style:text-position=""/>
 306   </style:style>
 307   <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 308    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 309    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 310    <style:text-properties style:text-position=""/>
 311    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 312    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 313    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 314   </style:style>
 315   <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 316    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 317    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 318    <style:text-properties style:text-position=""/>
 319    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 320    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 321    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 322   </style:style>
 323   <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
 324    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 325    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 326    <style:text-properties style:text-position=""/>
 327    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 328    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 329    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 330   </style:style>
 331   <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default"/>
 332   <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
 333    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 334    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 335    <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/>
 336   </style:style>
 337   <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default">
 338    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 339    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 340    <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/>
 341   </style:style>
 342   <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default">
 343    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 344    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 345    <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/>
 346   </style:style>
 347   <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">
 348    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 349    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 350   </style:style>
 351   <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 352    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 353    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 354    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 355    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 356    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 357   </style:style>
 358   <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 359    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 360    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 361    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 362    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 363    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 364   </style:style>
 365   <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default">
 366    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 367    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 368    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 369    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 370    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 371   </style:style>
 372   <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default">
 373    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 374    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 375    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 376   </style:style>
 377   <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default">
 378    <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 379   </style:style>
 380   <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 381    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 382    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 383    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 384    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 385    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 386   </style:style>
 387   <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 388    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 389    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 390    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C6"/>
 391    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C6"/>
 392    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C6"/>
 393   </style:style>
 394   <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default">
 395    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 396    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 397    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 398    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 399    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 400   </style:style>
 401   <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default">
 402    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 403   </style:style>
 404   <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
 405    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Courier New" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="en" style:country-asian="US" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="en" style:country-complex="US" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 406   </style:style>
 407   <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default">
 408    <style:table-cell-properties fo:background-color="#ffff00"/>
 409    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 410   </style:style>
 411   <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
 412    <style:table-cell-properties fo:background-color="#ffff00"/>
 413   </style:style>
 414   <style:style style:name="ta_extref" style:family="table">
 415    <style:table-properties table:display="false"/>
 416   </style:style>
 417   <style:page-layout style:name="pm1">
 418    <style:page-layout-properties style:writing-mode="lr-tb"/>
 419    <style:header-style>
 420     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
 421    </style:header-style>
 422    <style:footer-style>
 423     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
 424    </style:footer-style>
 425   </style:page-layout>
 426   <style:page-layout style:name="pm2">
 427    <style:page-layout-properties style:writing-mode="lr-tb"/>
 428    <style:header-style>
 429     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 430      <style:background-image/>
 431     </style:header-footer-properties>
 432    </style:header-style>
 433    <style:footer-style>
 434     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 435      <style:background-image/>
 436     </style:header-footer-properties>
 437    </style:footer-style>
 438   </style:page-layout>
 439   <style:style style:name="T1" style:family="text">
 440    <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 441   </style:style>
 442   <style:style style:name="T2" style:family="text">
 443    <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal" fo:color="#0000ff"/>
 444   </style:style>
 445   <style:style style:name="T3" style:family="text">
 446    <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal" fo:color="#ff0000"/>
 447   </style:style>
 448   <style:style style:name="T4" style:family="text">
 449    <style:text-properties fo:color="#0000ff" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 450   </style:style>
 451   <style:style style:name="T5" style:family="text">
 452    <style:text-properties fo:color="#0000ff"/>
 453   </style:style>
 454   <style:style style:name="T6" style:family="text">
 455    <style:text-properties fo:color="#ff0000"/>
 456   </style:style>
 457  </office:automatic-styles>
 458  <office:master-styles>
 459   <style:master-page style:name="Default" style:page-layout-name="pm1">
 460    <style:header>
 461     <text:p><text:sheet-name>???</text:sheet-name></text:p>
 462    </style:header>
 463    <style:header-left style:display="false"/>
 464    <style:footer>
 465     <text:p>Page <text:page-number>1</text:page-number></text:p>
 466    </style:footer>
 467    <style:footer-left style:display="false"/>
 468   </style:master-page>
 469   <style:master-page style:name="Report" style:page-layout-name="pm2">
 470    <style:header>
 471     <style:region-left>
 472      <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
 473     </style:region-left>
 474     <style:region-right>
 475      <text:p><text:date style:data-style-name="N2" text:date-value="2016-05-17">00.00.0000</text:date>, <text:time style:data-style-name="N2" text:time-value="13:18:06.350000000">00:00:00</text:time></text:p>
 476     </style:region-right>
 477    </style:header>
 478    <style:header-left style:display="false"/>
 479    <style:footer>
 480     <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
 481    </style:footer>
 482    <style:footer-left style:display="false"/>
 483   </style:master-page>
 484  </office:master-styles>
 485  <office:body>
 486   <office:spreadsheet>
 487    <table:calculation-settings table:automatic-find-labels="false"/>
 488    <table:table table:name="Sheet1" table:style-name="ta1">
 489     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
 490     <table:table-column table:style-name="co1" table:default-cell-style-name="ce13"/>
 491     <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
 492     <table:table-row table:style-name="ro1">
 493      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 494       <text:p>DAVERAGE Function</text:p>
 495      </table:table-cell>
 496      <table:table-cell table:number-columns-repeated="2"/>
 497     </table:table-row>
 498     <table:table-row table:style-name="ro2">
 499      <table:table-cell table:number-columns-repeated="3"/>
 500     </table:table-row>
 501     <table:table-row table:style-name="ro3">
 502      <table:table-cell table:style-name="ce11" office:value-type="string" calcext:value-type="string">
 503       <text:p>Result</text:p>
 504      </table:table-cell>
 505      <table:table-cell table:style-name="ce14" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 506       <text:p>PRAVDA</text:p>
 507      </table:table-cell>
 508      <table:table-cell/>
 509     </table:table-row>
 510     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 511      <table:table-cell table:number-columns-repeated="3"/>
 512     </table:table-row>
 513     <table:table-row table:style-name="ro4">
 514      <table:table-cell table:style-name="ce12" office:value-type="string" calcext:value-type="string">
 515       <text:p>Sheet</text:p>
 516      </table:table-cell>
 517      <table:table-cell table:style-name="ce12" office:value-type="string" calcext:value-type="string">
 518       <text:p>Result</text:p>
 519      </table:table-cell>
 520      <table:table-cell table:style-name="ce12" office:value-type="string" calcext:value-type="string">
 521       <text:p>Description</text:p>
 522      </table:table-cell>
 523     </table:table-row>
 524     <table:table-row table:style-name="ro2">
 525      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 526       <text:p>1</text:p>
 527      </table:table-cell>
 528      <table:table-cell table:style-name="ce15" table:formula="of:=AND([Sheet2.C2:.C100])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 529       <text:p>PRAVDA</text:p>
 530      </table:table-cell>
 531      <table:table-cell office:value-type="string" calcext:value-type="string">
 532       <text:p>Simple DAVERAGE formulas with local references and values</text:p>
 533      </table:table-cell>
 534     </table:table-row>
 535     <table:table-row table:style-name="ro2" table:number-rows-repeated="30">
 536      <table:table-cell/>
 537      <table:table-cell table:style-name="ce16"/>
 538      <table:table-cell/>
 539     </table:table-row>
 540     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
 541      <table:table-cell table:number-columns-repeated="3"/>
 542     </table:table-row>
 543     <table:table-row table:style-name="ro2">
 544      <table:table-cell table:number-columns-repeated="3"/>
 545     </table:table-row>
 546     <calcext:conditional-formats>
 547      <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
 548       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
 549       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
 550       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
 551      </calcext:conditional-format>
 552      <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
 553       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
 554       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
 555       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
 556      </calcext:conditional-format>
 557     </calcext:conditional-formats>
 558    </table:table>
 559    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
 560     <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
 561     <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
 562     <table:table-column table:style-name="co6" table:default-cell-style-name="ce13"/>
 563     <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
 564     <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
 565     <table:table-column table:style-name="co9" table:number-columns-repeated="4" table:default-cell-style-name="Default"/>
 566     <table:table-column table:style-name="co3" table:number-columns-repeated="6" table:default-cell-style-name="Default"/>
 567     <table:table-row table:style-name="ro2">
 568      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
 569       <text:p>Function</text:p>
 570      </table:table-cell>
 571      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
 572       <text:p>Expected</text:p>
 573      </table:table-cell>
 574      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
 575       <text:p>Correct</text:p>
 576      </table:table-cell>
 577      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
 578       <text:p>FunctionString</text:p>
 579      </table:table-cell>
 580      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
 581       <text:p>Comment</text:p>
 582      </table:table-cell>
 583      <table:table-cell table:number-columns-repeated="4"/>
 584      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 585       <text:p>Name</text:p>
 586      </table:table-cell>
 587      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 588       <text:p>Grade</text:p>
 589      </table:table-cell>
 590      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 591       <text:p>Age</text:p>
 592      </table:table-cell>
 593      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 594       <text:p>Distance to School</text:p>
 595      </table:table-cell>
 596      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 597       <text:p>Weight</text:p>
 598      </table:table-cell>
 599      <table:table-cell/>
 600     </table:table-row>
 601     <table:table-row table:style-name="ro5">
 602      <table:table-cell table:style-name="ce18" table:formula="of:=DAVERAGE([.J1:.N10];&quot;Weight&quot;;[.J44:.N45])" office:value-type="float" office:value="39" calcext:value-type="float">
 603       <text:p>39</text:p>
 604      </table:table-cell>
 605      <table:table-cell office:value-type="float" office:value="39" calcext:value-type="float">
 606       <text:p>39</text:p>
 607      </table:table-cell>
 608      <table:table-cell table:style-name="ce19" table:formula="of:=[.A2]=[.B2]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 609       <text:p>PRAVDA</text:p>
 610      </table:table-cell>
 611      <table:table-cell table:style-name="ce18" office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DAVERAGE(</text:span><text:span text:style-name="T2">J1:N10</text:span><text:span text:style-name="T1">;&quot;Weight&quot;;</text:span><text:span text:style-name="T3">J44:N45</text:span><text:span text:style-name="T1">)</text:span></text:p>
 612      </table:table-cell>
 613      <table:table-cell table:number-columns-repeated="5"/>
 614      <table:table-cell office:value-type="string" calcext:value-type="string">
 615       <text:p>Andy</text:p>
 616      </table:table-cell>
 617      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
 618       <text:p>3</text:p>
 619      </table:table-cell>
 620      <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
 621       <text:p>9</text:p>
 622      </table:table-cell>
 623      <table:table-cell office:value-type="float" office:value="150" calcext:value-type="float">
 624       <text:p>150</text:p>
 625      </table:table-cell>
 626      <table:table-cell office:value-type="float" office:value="40" calcext:value-type="float">
 627       <text:p>40</text:p>
 628      </table:table-cell>
 629      <table:table-cell/>
 630     </table:table-row>
 631     <table:table-row table:style-name="ro5">
 632      <table:table-cell table:formula="of:=DAVERAGE([.J1:.N10];&quot;Weight&quot;;[.J13:.N15])" office:value-type="float" office:value="44.25" calcext:value-type="float">
 633       <text:p>44,25</text:p>
 634      </table:table-cell>
 635      <table:table-cell office:value-type="float" office:value="44.25" calcext:value-type="float">
 636       <text:p>44,25</text:p>
 637      </table:table-cell>
 638      <table:table-cell table:style-name="ce19" table:formula="of:=[.A3]=[.B3]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 639       <text:p>PRAVDA</text:p>
 640      </table:table-cell>
 641      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T4">DAVERAGE(</text:span><text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J13:N15</text:span>)</text:p>
 642      </table:table-cell>
 643      <table:table-cell table:number-columns-repeated="5"/>
 644      <table:table-cell office:value-type="string" calcext:value-type="string">
 645       <text:p>Betty</text:p>
 646      </table:table-cell>
 647      <table:table-cell office:value-type="float" office:value="4" calcext:value-type="float">
 648       <text:p>4</text:p>
 649      </table:table-cell>
 650      <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
 651       <text:p>10</text:p>
 652      </table:table-cell>
 653      <table:table-cell office:value-type="float" office:value="1000" calcext:value-type="float">
 654       <text:p>1000</text:p>
 655      </table:table-cell>
 656      <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
 657       <text:p>42</text:p>
 658      </table:table-cell>
 659      <table:table-cell/>
 660     </table:table-row>
 661     <table:table-row table:style-name="ro5">
 662      <table:table-cell table:formula="of:=DAVERAGE([.J1:.N10];&quot;Weight&quot;;[.J17:.N18])" office:value-type="float" office:value="37.5" calcext:value-type="float">
 663       <text:p>37,5</text:p>
 664      </table:table-cell>
 665      <table:table-cell office:value-type="float" office:value="37.5" calcext:value-type="float">
 666       <text:p>37,5</text:p>
 667      </table:table-cell>
 668      <table:table-cell table:style-name="ce19" table:formula="of:=[.A4]=[.B4]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 669       <text:p>PRAVDA</text:p>
 670      </table:table-cell>
 671      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DAVERAGE</text:span>(<text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J17:N18</text:span>)</text:p>
 672      </table:table-cell>
 673      <table:table-cell table:number-columns-repeated="5"/>
 674      <table:table-cell office:value-type="string" calcext:value-type="string">
 675       <text:p>Clara</text:p>
 676      </table:table-cell>
 677      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
 678       <text:p>3</text:p>
 679      </table:table-cell>
 680      <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
 681       <text:p>10</text:p>
 682      </table:table-cell>
 683      <table:table-cell office:value-type="float" office:value="300" calcext:value-type="float">
 684       <text:p>300</text:p>
 685      </table:table-cell>
 686      <table:table-cell office:value-type="float" office:value="51" calcext:value-type="float">
 687       <text:p>51</text:p>
 688      </table:table-cell>
 689      <table:table-cell/>
 690     </table:table-row>
 691     <table:table-row table:style-name="ro5">
 692      <table:table-cell table:formula="of:=DAVERAGE([.J1:.N10];&quot;Weight&quot;;[.J20:.N21])" office:value-type="float" office:value="39.4" calcext:value-type="float">
 693       <text:p>39,4</text:p>
 694      </table:table-cell>
 695      <table:table-cell office:value-type="float" office:value="39.4" calcext:value-type="float">
 696       <text:p>39,4</text:p>
 697      </table:table-cell>
 698      <table:table-cell table:style-name="ce19" table:formula="of:=[.A5]=[.B5]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 699       <text:p>PRAVDA</text:p>
 700      </table:table-cell>
 701      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DAVERAGE</text:span>(<text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J20:N21</text:span>)</text:p>
 702      </table:table-cell>
 703      <table:table-cell table:number-columns-repeated="5"/>
 704      <table:table-cell office:value-type="string" calcext:value-type="string">
 705       <text:p>Daniel</text:p>
 706      </table:table-cell>
 707      <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
 708       <text:p>5</text:p>
 709      </table:table-cell>
 710      <table:table-cell office:value-type="float" office:value="11" calcext:value-type="float">
 711       <text:p>11</text:p>
 712      </table:table-cell>
 713      <table:table-cell office:value-type="float" office:value="1200" calcext:value-type="float">
 714       <text:p>1200</text:p>
 715      </table:table-cell>
 716      <table:table-cell office:value-type="float" office:value="48" calcext:value-type="float">
 717       <text:p>48</text:p>
 718      </table:table-cell>
 719      <table:table-cell/>
 720     </table:table-row>
 721     <table:table-row table:style-name="ro5">
 722      <table:table-cell table:formula="of:=DAVERAGE([.J1:.N10];&quot;Weight&quot;;[.J56:.N57])" office:value-type="float" office:value="37.5" calcext:value-type="float">
 723       <text:p>37,5</text:p>
 724      </table:table-cell>
 725      <table:table-cell office:value-type="float" office:value="37.5" calcext:value-type="float">
 726       <text:p>37,5</text:p>
 727      </table:table-cell>
 728      <table:table-cell table:style-name="ce20" table:formula="of:=[.A6]=[.B6]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 729       <text:p>PRAVDA</text:p>
 730      </table:table-cell>
 731      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DAVERAGE</text:span>(J1:N10;&quot;Weight&quot;;J56:N57)</text:p>
 732      </table:table-cell>
 733      <table:table-cell table:number-columns-repeated="5"/>
 734      <table:table-cell office:value-type="string" calcext:value-type="string">
 735       <text:p>Eva</text:p>
 736      </table:table-cell>
 737      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
 738       <text:p>2</text:p>
 739      </table:table-cell>
 740      <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
 741       <text:p>8</text:p>
 742      </table:table-cell>
 743      <table:table-cell office:value-type="float" office:value="650" calcext:value-type="float">
 744       <text:p>650</text:p>
 745      </table:table-cell>
 746      <table:table-cell office:value-type="float" office:value="33" calcext:value-type="float">
 747       <text:p>33</text:p>
 748      </table:table-cell>
 749      <table:table-cell/>
 750     </table:table-row>
 751     <table:table-row table:style-name="ro5">
 752      <table:table-cell table:formula="of:=DAVERAGE(database;&quot;Weight&quot;;criteria)" office:value-type="float" office:value="42" calcext:value-type="float">
 753       <text:p>42</text:p>
 754      </table:table-cell>
 755      <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
 756       <text:p>42</text:p>
 757      </table:table-cell>
 758      <table:table-cell table:style-name="ce20" table:formula="of:=[.A7]=[.B7]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 759       <text:p>PRAVDA</text:p>
 760      </table:table-cell>
 761      <table:table-cell office:value-type="string" calcext:value-type="string">
 762       <text:p>DAVERAGE(database;&quot;Weight&quot;;criteria)</text:p>
 763      </table:table-cell>
 764      <table:table-cell office:value-type="string" calcext:value-type="string">
 765       <text:p>AOO bug #118060</text:p>
 766      </table:table-cell>
 767      <table:table-cell table:number-columns-repeated="4"/>
 768      <table:table-cell office:value-type="string" calcext:value-type="string">
 769       <text:p>Frank</text:p>
 770      </table:table-cell>
 771      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
 772       <text:p>2</text:p>
 773      </table:table-cell>
 774      <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
 775       <text:p>7</text:p>
 776      </table:table-cell>
 777      <table:table-cell office:value-type="float" office:value="300" calcext:value-type="float">
 778       <text:p>300</text:p>
 779      </table:table-cell>
 780      <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
 781       <text:p>42</text:p>
 782      </table:table-cell>
 783      <table:table-cell/>
 784     </table:table-row>
 785     <table:table-row table:style-name="ro2">
 786      <table:table-cell table:number-columns-repeated="2"/>
 787      <table:table-cell table:style-name="ce21"/>
 788      <table:table-cell table:number-columns-repeated="6"/>
 789      <table:table-cell office:value-type="string" calcext:value-type="string">
 790       <text:p>Greta</text:p>
 791      </table:table-cell>
 792      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 793       <text:p>1</text:p>
 794      </table:table-cell>
 795      <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
 796       <text:p>7</text:p>
 797      </table:table-cell>
 798      <table:table-cell office:value-type="float" office:value="200" calcext:value-type="float">
 799       <text:p>200</text:p>
 800      </table:table-cell>
 801      <table:table-cell office:value-type="float" office:value="36" calcext:value-type="float">
 802       <text:p>36</text:p>
 803      </table:table-cell>
 804      <table:table-cell/>
 805     </table:table-row>
 806     <table:table-row table:style-name="ro2">
 807      <table:table-cell table:number-columns-repeated="2"/>
 808      <table:table-cell table:style-name="ce21"/>
 809      <table:table-cell table:number-columns-repeated="6"/>
 810      <table:table-cell office:value-type="string" calcext:value-type="string">
 811       <text:p>Harry</text:p>
 812      </table:table-cell>
 813      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
 814       <text:p>3</text:p>
 815      </table:table-cell>
 816      <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
 817       <text:p>9</text:p>
 818      </table:table-cell>
 819      <table:table-cell office:value-type="float" office:value="1200" calcext:value-type="float">
 820       <text:p>1200</text:p>
 821      </table:table-cell>
 822      <table:table-cell office:value-type="float" office:value="44" calcext:value-type="float">
 823       <text:p>44</text:p>
 824      </table:table-cell>
 825      <table:table-cell/>
 826     </table:table-row>
 827     <table:table-row table:style-name="ro2">
 828      <table:table-cell table:number-columns-repeated="2"/>
 829      <table:table-cell table:style-name="ce21"/>
 830      <table:table-cell table:number-columns-repeated="6"/>
 831      <table:table-cell office:value-type="string" calcext:value-type="string">
 832       <text:p>Irene</text:p>
 833      </table:table-cell>
 834      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
 835       <text:p>2</text:p>
 836      </table:table-cell>
 837      <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
 838       <text:p>8</text:p>
 839      </table:table-cell>
 840      <table:table-cell office:value-type="float" office:value="1000" calcext:value-type="float">
 841       <text:p>1000</text:p>
 842      </table:table-cell>
 843      <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
 844       <text:p>42</text:p>
 845      </table:table-cell>
 846      <table:table-cell/>
 847     </table:table-row>
 848     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
 849      <table:table-cell table:number-columns-repeated="2"/>
 850      <table:table-cell table:style-name="ce21"/>
 851      <table:table-cell table:number-columns-repeated="12"/>
 852     </table:table-row>
 853     <table:table-row table:style-name="ro2">
 854      <table:table-cell table:number-columns-repeated="2"/>
 855      <table:table-cell table:style-name="ce21"/>
 856      <table:table-cell table:number-columns-repeated="6"/>
 857      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 858       <text:p>Name</text:p>
 859      </table:table-cell>
 860      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 861       <text:p>Grade</text:p>
 862      </table:table-cell>
 863      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 864       <text:p>Age</text:p>
 865      </table:table-cell>
 866      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 867       <text:p>Distance to School</text:p>
 868      </table:table-cell>
 869      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 870       <text:p>Weight</text:p>
 871      </table:table-cell>
 872      <table:table-cell/>
 873     </table:table-row>
 874     <table:table-row table:style-name="ro2">
 875      <table:table-cell table:number-columns-repeated="2"/>
 876      <table:table-cell table:style-name="ce21"/>
 877      <table:table-cell table:number-columns-repeated="8"/>
 878      <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
 879       <text:p>9</text:p>
 880      </table:table-cell>
 881      <table:table-cell table:number-columns-repeated="3"/>
 882     </table:table-row>
 883     <table:table-row table:style-name="ro2">
 884      <table:table-cell table:number-columns-repeated="2"/>
 885      <table:table-cell table:style-name="ce21"/>
 886      <table:table-cell table:number-columns-repeated="8"/>
 887      <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
 888       <text:p>10</text:p>
 889      </table:table-cell>
 890      <table:table-cell table:number-columns-repeated="3"/>
 891     </table:table-row>
 892     <table:table-row table:style-name="ro2">
 893      <table:table-cell table:number-columns-repeated="2"/>
 894      <table:table-cell table:style-name="ce21"/>
 895      <table:table-cell table:number-columns-repeated="12"/>
 896     </table:table-row>
 897     <table:table-row table:style-name="ro2">
 898      <table:table-cell table:number-columns-repeated="2"/>
 899      <table:table-cell table:style-name="ce21"/>
 900      <table:table-cell table:number-columns-repeated="6"/>
 901      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 902       <text:p>Name</text:p>
 903      </table:table-cell>
 904      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 905       <text:p>Grade</text:p>
 906      </table:table-cell>
 907      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 908       <text:p>Age</text:p>
 909      </table:table-cell>
 910      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 911       <text:p>Distance to School</text:p>
 912      </table:table-cell>
 913      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 914       <text:p>Weight</text:p>
 915      </table:table-cell>
 916      <table:table-cell/>
 917     </table:table-row>
 918     <table:table-row table:style-name="ro2">
 919      <table:table-cell table:number-columns-repeated="2"/>
 920      <table:table-cell table:style-name="ce21"/>
 921      <table:table-cell table:number-columns-repeated="7"/>
 922      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
 923       <text:p>2</text:p>
 924      </table:table-cell>
 925      <table:table-cell office:value-type="string" calcext:value-type="string">
 926       <text:p>&gt;7</text:p>
 927      </table:table-cell>
 928      <table:table-cell table:number-columns-repeated="3"/>
 929     </table:table-row>
 930     <table:table-row table:style-name="ro2">
 931      <table:table-cell table:number-columns-repeated="2"/>
 932      <table:table-cell table:style-name="ce21"/>
 933      <table:table-cell table:number-columns-repeated="12"/>
 934     </table:table-row>
 935     <table:table-row table:style-name="ro2">
 936      <table:table-cell table:number-columns-repeated="2"/>
 937      <table:table-cell table:style-name="ce21"/>
 938      <table:table-cell table:number-columns-repeated="6"/>
 939      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 940       <text:p>Name</text:p>
 941      </table:table-cell>
 942      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 943       <text:p>Grade</text:p>
 944      </table:table-cell>
 945      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 946       <text:p>Age</text:p>
 947      </table:table-cell>
 948      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 949       <text:p>Distance to School</text:p>
 950      </table:table-cell>
 951      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 952       <text:p>Weight</text:p>
 953      </table:table-cell>
 954      <table:table-cell/>
 955     </table:table-row>
 956     <table:table-row table:style-name="ro2">
 957      <table:table-cell table:number-columns-repeated="2"/>
 958      <table:table-cell table:style-name="ce21"/>
 959      <table:table-cell table:number-columns-repeated="6"/>
 960      <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string">
 961       <text:p>&gt;=E</text:p>
 962      </table:table-cell>
 963      <table:table-cell table:number-columns-repeated="5"/>
 964     </table:table-row>
 965     <table:table-row table:style-name="ro2">
 966      <table:table-cell table:number-columns-repeated="2"/>
 967      <table:table-cell table:style-name="ce21"/>
 968      <table:table-cell table:number-columns-repeated="12"/>
 969     </table:table-row>
 970     <table:table-row table:style-name="ro2">
 971      <table:table-cell table:number-columns-repeated="2"/>
 972      <table:table-cell table:style-name="ce21"/>
 973      <table:table-cell table:number-columns-repeated="6"/>
 974      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 975       <text:p>Name</text:p>
 976      </table:table-cell>
 977      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 978       <text:p>Grade</text:p>
 979      </table:table-cell>
 980      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 981       <text:p>Age</text:p>
 982      </table:table-cell>
 983      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 984       <text:p>Distance to School</text:p>
 985      </table:table-cell>
 986      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 987       <text:p>Weight</text:p>
 988      </table:table-cell>
 989      <table:table-cell/>
 990     </table:table-row>
 991     <table:table-row table:style-name="ro2">
 992      <table:table-cell table:number-columns-repeated="2"/>
 993      <table:table-cell table:style-name="ce21"/>
 994      <table:table-cell table:number-columns-repeated="6"/>
 995      <table:table-cell office:value-type="string" calcext:value-type="string">
 996       <text:p>Frank</text:p>
 997      </table:table-cell>
 998      <table:table-cell table:number-columns-repeated="5"/>
 999     </table:table-row>
1000     <table:table-row table:style-name="ro2">
1001      <table:table-cell table:number-columns-repeated="2"/>
1002      <table:table-cell table:style-name="ce21"/>
1003      <table:table-cell table:number-columns-repeated="12"/>
1004     </table:table-row>
1005     <table:table-row table:style-name="ro2">
1006      <table:table-cell table:number-columns-repeated="2"/>
1007      <table:table-cell table:style-name="ce21"/>
1008      <table:table-cell table:number-columns-repeated="6"/>
1009      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1010       <text:p>Name</text:p>
1011      </table:table-cell>
1012      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1013       <text:p>Grade</text:p>
1014      </table:table-cell>
1015      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1016       <text:p>Age</text:p>
1017      </table:table-cell>
1018      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1019       <text:p>Distance to School</text:p>
1020      </table:table-cell>
1021      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1022       <text:p>Weight</text:p>
1023      </table:table-cell>
1024      <table:table-cell/>
1025     </table:table-row>
1026     <table:table-row table:style-name="ro2">
1027      <table:table-cell table:number-columns-repeated="2"/>
1028      <table:table-cell table:style-name="ce21"/>
1029      <table:table-cell table:number-columns-repeated="7"/>
1030      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
1031       <text:p>1</text:p>
1032      </table:table-cell>
1033      <table:table-cell table:number-columns-repeated="4"/>
1034     </table:table-row>
1035     <table:table-row table:style-name="ro2">
1036      <table:table-cell table:number-columns-repeated="2"/>
1037      <table:table-cell table:style-name="ce21"/>
1038      <table:table-cell table:number-columns-repeated="7"/>
1039      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1040       <text:p>2</text:p>
1041      </table:table-cell>
1042      <table:table-cell table:number-columns-repeated="4"/>
1043     </table:table-row>
1044     <table:table-row table:style-name="ro2">
1045      <table:table-cell table:number-columns-repeated="2"/>
1046      <table:table-cell table:style-name="ce21"/>
1047      <table:table-cell table:number-columns-repeated="7"/>
1048      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1049       <text:p>3</text:p>
1050      </table:table-cell>
1051      <table:table-cell table:number-columns-repeated="4"/>
1052     </table:table-row>
1053     <table:table-row table:style-name="ro2">
1054      <table:table-cell table:number-columns-repeated="2"/>
1055      <table:table-cell table:style-name="ce21"/>
1056      <table:table-cell table:number-columns-repeated="7"/>
1057      <table:table-cell office:value-type="float" office:value="4" calcext:value-type="float">
1058       <text:p>4</text:p>
1059      </table:table-cell>
1060      <table:table-cell table:number-columns-repeated="4"/>
1061     </table:table-row>
1062     <table:table-row table:style-name="ro2">
1063      <table:table-cell table:number-columns-repeated="2"/>
1064      <table:table-cell table:style-name="ce21"/>
1065      <table:table-cell table:number-columns-repeated="7"/>
1066      <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
1067       <text:p>5</text:p>
1068      </table:table-cell>
1069      <table:table-cell table:number-columns-repeated="4"/>
1070     </table:table-row>
1071     <table:table-row table:style-name="ro2">
1072      <table:table-cell table:number-columns-repeated="2"/>
1073      <table:table-cell table:style-name="ce21"/>
1074      <table:table-cell table:number-columns-repeated="12"/>
1075     </table:table-row>
1076     <table:table-row table:style-name="ro2">
1077      <table:table-cell table:number-columns-repeated="2"/>
1078      <table:table-cell table:style-name="ce21"/>
1079      <table:table-cell table:number-columns-repeated="6"/>
1080      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1081       <text:p>Name</text:p>
1082      </table:table-cell>
1083      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1084       <text:p>Grade</text:p>
1085      </table:table-cell>
1086      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1087       <text:p>Age</text:p>
1088      </table:table-cell>
1089      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1090       <text:p>Distance to School</text:p>
1091      </table:table-cell>
1092      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1093       <text:p>Weight</text:p>
1094      </table:table-cell>
1095      <table:table-cell/>
1096     </table:table-row>
1097     <table:table-row table:style-name="ro2">
1098      <table:table-cell table:number-columns-repeated="2"/>
1099      <table:table-cell table:style-name="ce21"/>
1100      <table:table-cell table:number-columns-repeated="7"/>
1101      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
1102       <text:p>1</text:p>
1103      </table:table-cell>
1104      <table:table-cell table:number-columns-repeated="4"/>
1105     </table:table-row>
1106     <table:table-row table:style-name="ro2">
1107      <table:table-cell table:number-columns-repeated="2"/>
1108      <table:table-cell table:style-name="ce21"/>
1109      <table:table-cell table:number-columns-repeated="7"/>
1110      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1111       <text:p>2</text:p>
1112      </table:table-cell>
1113      <table:table-cell table:number-columns-repeated="4"/>
1114     </table:table-row>
1115     <table:table-row table:style-name="ro2">
1116      <table:table-cell table:number-columns-repeated="2"/>
1117      <table:table-cell table:style-name="ce21"/>
1118      <table:table-cell table:number-columns-repeated="7"/>
1119      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1120       <text:p>3</text:p>
1121      </table:table-cell>
1122      <table:table-cell table:number-columns-repeated="4"/>
1123     </table:table-row>
1124     <table:table-row table:style-name="ro2">
1125      <table:table-cell table:number-columns-repeated="2"/>
1126      <table:table-cell table:style-name="ce21"/>
1127      <table:table-cell table:number-columns-repeated="12"/>
1128     </table:table-row>
1129     <table:table-row table:style-name="ro2">
1130      <table:table-cell table:number-columns-repeated="2"/>
1131      <table:table-cell table:style-name="ce21"/>
1132      <table:table-cell table:number-columns-repeated="6"/>
1133      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1134       <text:p>Name</text:p>
1135      </table:table-cell>
1136      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1137       <text:p>Grade</text:p>
1138      </table:table-cell>
1139      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1140       <text:p>Age</text:p>
1141      </table:table-cell>
1142      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1143       <text:p>Distance to School</text:p>
1144      </table:table-cell>
1145      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1146       <text:p>Weight</text:p>
1147      </table:table-cell>
1148      <table:table-cell/>
1149     </table:table-row>
1150     <table:table-row table:style-name="ro2">
1151      <table:table-cell table:number-columns-repeated="2"/>
1152      <table:table-cell table:style-name="ce21"/>
1153      <table:table-cell table:number-columns-repeated="7"/>
1154      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1155       <text:p>3</text:p>
1156      </table:table-cell>
1157      <table:table-cell table:number-columns-repeated="4"/>
1158     </table:table-row>
1159     <table:table-row table:style-name="ro2">
1160      <table:table-cell table:number-columns-repeated="2"/>
1161      <table:table-cell table:style-name="ce21"/>
1162      <table:table-cell table:number-columns-repeated="12"/>
1163     </table:table-row>
1164     <table:table-row table:style-name="ro2">
1165      <table:table-cell table:number-columns-repeated="2"/>
1166      <table:table-cell table:style-name="ce21"/>
1167      <table:table-cell table:number-columns-repeated="6"/>
1168      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1169       <text:p>Name</text:p>
1170      </table:table-cell>
1171      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1172       <text:p>Grade</text:p>
1173      </table:table-cell>
1174      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1175       <text:p>Age</text:p>
1176      </table:table-cell>
1177      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1178       <text:p>Distance to School</text:p>
1179      </table:table-cell>
1180      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1181       <text:p>Weight</text:p>
1182      </table:table-cell>
1183      <table:table-cell/>
1184     </table:table-row>
1185     <table:table-row table:style-name="ro2">
1186      <table:table-cell table:number-columns-repeated="2"/>
1187      <table:table-cell table:style-name="ce21"/>
1188      <table:table-cell table:number-columns-repeated="8"/>
1189      <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
1190       <text:p>10</text:p>
1191      </table:table-cell>
1192      <table:table-cell table:number-columns-repeated="3"/>
1193     </table:table-row>
1194     <table:table-row table:style-name="ro2">
1195      <table:table-cell table:number-columns-repeated="15"/>
1196     </table:table-row>
1197     <table:table-row table:style-name="ro2">
1198      <table:table-cell table:number-columns-repeated="9"/>
1199      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1200       <text:p>Name</text:p>
1201      </table:table-cell>
1202      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1203       <text:p>Grade</text:p>
1204      </table:table-cell>
1205      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1206       <text:p>Age</text:p>
1207      </table:table-cell>
1208      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1209       <text:p>Distance to School</text:p>
1210      </table:table-cell>
1211      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1212       <text:p>Weight</text:p>
1213      </table:table-cell>
1214      <table:table-cell/>
1215     </table:table-row>
1216     <table:table-row table:style-name="ro2">
1217      <table:table-cell table:number-columns-repeated="11"/>
1218      <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
1219       <text:p>7</text:p>
1220      </table:table-cell>
1221      <table:table-cell table:number-columns-repeated="3"/>
1222     </table:table-row>
1223     <table:table-row table:style-name="ro2">
1224      <table:table-cell table:number-columns-repeated="15"/>
1225     </table:table-row>
1226     <table:table-row table:style-name="ro2">
1227      <table:table-cell table:number-columns-repeated="9"/>
1228      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1229       <text:p>Name</text:p>
1230      </table:table-cell>
1231      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1232       <text:p>Grade</text:p>
1233      </table:table-cell>
1234      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1235       <text:p>Age</text:p>
1236      </table:table-cell>
1237      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1238       <text:p>Distance to School</text:p>
1239      </table:table-cell>
1240      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1241       <text:p>Weight</text:p>
1242      </table:table-cell>
1243      <table:table-cell/>
1244     </table:table-row>
1245     <table:table-row table:style-name="ro2">
1246      <table:table-cell table:number-columns-repeated="11"/>
1247      <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
1248       <text:p>8</text:p>
1249      </table:table-cell>
1250      <table:table-cell table:number-columns-repeated="3"/>
1251     </table:table-row>
1252     <table:table-row table:style-name="ro2">
1253      <table:table-cell table:number-columns-repeated="15"/>
1254     </table:table-row>
1255     <table:table-row table:style-name="ro2">
1256      <table:table-cell table:number-columns-repeated="9"/>
1257      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1258       <text:p>Name</text:p>
1259      </table:table-cell>
1260      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1261       <text:p>Grade</text:p>
1262      </table:table-cell>
1263      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1264       <text:p>Age</text:p>
1265      </table:table-cell>
1266      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1267       <text:p>Distance to School</text:p>
1268      </table:table-cell>
1269      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1270       <text:p>Weight</text:p>
1271      </table:table-cell>
1272      <table:table-cell/>
1273     </table:table-row>
1274     <table:table-row table:style-name="ro2">
1275      <table:table-cell table:number-columns-repeated="10"/>
1276      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1277       <text:p>2</text:p>
1278      </table:table-cell>
1279      <table:table-cell table:number-columns-repeated="4"/>
1280     </table:table-row>
1281     <table:table-row table:style-name="ro2">
1282      <table:table-cell table:number-columns-repeated="15"/>
1283     </table:table-row>
1284     <table:table-row table:style-name="ro2">
1285      <table:table-cell table:number-columns-repeated="9"/>
1286      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1287       <text:p>Name</text:p>
1288      </table:table-cell>
1289      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1290       <text:p>Grade</text:p>
1291      </table:table-cell>
1292      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1293       <text:p>Age</text:p>
1294      </table:table-cell>
1295      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1296       <text:p>Distance to School</text:p>
1297      </table:table-cell>
1298      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1299       <text:p>Weight</text:p>
1300      </table:table-cell>
1301      <table:table-cell/>
1302     </table:table-row>
1303     <table:table-row table:style-name="ro2">
1304      <table:table-cell table:number-columns-repeated="11"/>
1305      <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
1306       <text:p>9</text:p>
1307      </table:table-cell>
1308      <table:table-cell table:number-columns-repeated="3"/>
1309     </table:table-row>
1310     <table:table-row table:style-name="ro2">
1311      <table:table-cell table:number-columns-repeated="15"/>
1312     </table:table-row>
1313     <table:table-row table:style-name="ro2">
1314      <table:table-cell table:number-columns-repeated="9"/>
1315      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1316       <text:p>Name</text:p>
1317      </table:table-cell>
1318      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1319       <text:p>Grade</text:p>
1320      </table:table-cell>
1321      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1322       <text:p>Age</text:p>
1323      </table:table-cell>
1324      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1325       <text:p>Distance to School</text:p>
1326      </table:table-cell>
1327      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
1328       <text:p>Weight</text:p>
1329      </table:table-cell>
1330      <table:table-cell/>
1331     </table:table-row>
1332     <table:table-row table:style-name="ro2">
1333      <table:table-cell table:number-columns-repeated="9"/>
1334      <table:table-cell office:value-type="string" calcext:value-type="string">
1335       <text:p>[E-F].*</text:p>
1336      </table:table-cell>
1337      <table:table-cell table:number-columns-repeated="5"/>
1338     </table:table-row>
1339     <table:table-row table:style-name="ro2">
1340      <table:table-cell table:number-columns-repeated="15"/>
1341     </table:table-row>
1342     <table:table-row table:style-name="ro2">
1343      <table:table-cell table:number-columns-repeated="9"/>
1344      <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1345       <text:p>Name</text:p>
1346      </table:table-cell>
1347      <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1348       <text:p>Grade</text:p>
1349      </table:table-cell>
1350      <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1351       <text:p>Age</text:p>
1352      </table:table-cell>
1353      <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1354       <text:p>Distance to School</text:p>
1355      </table:table-cell>
1356      <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1357       <text:p>Weight</text:p>
1358      </table:table-cell>
1359      <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string">
1360       <text:p>Age</text:p>
1361      </table:table-cell>
1362     </table:table-row>
1363     <table:table-row table:style-name="ro2">
1364      <table:table-cell table:number-columns-repeated="9"/>
1365      <table:table-cell table:style-name="ce25" table:number-columns-repeated="2"/>
1366      <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string">
1367       <text:p>&gt;0</text:p>
1368      </table:table-cell>
1369      <table:table-cell table:style-name="ce25" table:number-columns-repeated="3"/>
1370     </table:table-row>
1371     <table:table-row table:style-name="ro2">
1372      <table:table-cell table:number-columns-repeated="9"/>
1373      <table:table-cell table:style-name="ce25" table:number-columns-repeated="6"/>
1374     </table:table-row>
1375     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048514">
1376      <table:table-cell table:number-columns-repeated="15"/>
1377     </table:table-row>
1378     <table:table-row table:style-name="ro2">
1379      <table:table-cell table:number-columns-repeated="15"/>
1380     </table:table-row>
1381     <calcext:conditional-formats>
1382      <calcext:conditional-format calcext:target-range-address="Sheet2.C8:Sheet2.C42 Sheet2.C2:Sheet2.C5">
1383       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1384       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1385       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1386      </calcext:conditional-format>
1387      <calcext:conditional-format calcext:target-range-address="Sheet2.C6:Sheet2.C7">
1388       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C6"/>
1389       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C6"/>
1390       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C6"/>
1391      </calcext:conditional-format>
1392     </calcext:conditional-formats>
1393    </table:table>
1394    <table:table table:name="&apos;file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1395     <table:table-source xlink:type="simple" xlink:href="/home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1396     <table:table-column table:number-columns-repeated="8"/>
1397     <table:table-row table:number-rows-repeated="2">
1398      <table:table-cell table:number-columns-repeated="8"/>
1399     </table:table-row>
1400     <table:table-row>
1401      <table:table-cell table:number-columns-repeated="7"/>
1402      <table:table-cell table:style-name="ce9" office:value-type="float" office:value="4">
1403       <text:p>4</text:p>
1404      </table:table-cell>
1405     </table:table-row>
1406    </table:table>
1407    <table:named-expressions>
1408     <table:named-range table:name="criteria" table:base-cell-address="$Sheet2.$J$59" table:cell-range-address="$Sheet2.$J$59:.$O$61"/>
1409     <table:named-range table:name="database" table:base-cell-address="$Sheet2.$J$1" table:cell-range-address="$Sheet2.$J$1:.$N$10"/>
1410    </table:named-expressions>
1411   </office:spreadsheet>
1412  </office:body>
1413 </office:document>