sc/qa/unit/data/functions/date_time/fods/years.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="N122P0" 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="N122">
  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="N122P0"/>
  24   </number:currency-style>
  25   <number:currency-style style:name="N124P0" 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="N124">
  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="N124P0"/>
  34   </number:currency-style>
  35   <number:currency-style style:name="N126P0" 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="N126">
  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="N126P0"/>
  44   </number:currency-style>
  45   <number:currency-style style:name="N127P0" 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="N127">
  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="N127P0"/>
  55   </number:currency-style>
  56   <number:currency-style style:name="N128P0" 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="N128">
  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="N128P0"/>
  66   </number:currency-style>
  67   <number:currency-style style:name="N130P0" 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="N130">
  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="N130P0"/>
  77   </number:currency-style>
  78   <number:number-style style:name="N132P0" 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="N132">
  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="N132P0"/>
  87   </number:number-style>
  88   <number:number-style style:name="N134P0" 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="N134">
  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="N134P0"/>
  97   </number:number-style>
  98   <number:currency-style style:name="N136P0" 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="N136">
 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="N136P0"/>
 109   </number:currency-style>
 110   <number:currency-style style:name="N138P0" 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="N138">
 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="N138P0"/>
 121   </number:currency-style>
 122   <number:currency-style style:name="N140P0" 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="N140">
 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="N140P0"/>
 133   </number:currency-style>
 134   <number:currency-style style:name="N141P0" 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="N141">
 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="N141P0"/>
 145   </number:currency-style>
 146   <number:currency-style style:name="N142P0" 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="N142">
 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="N142P0"/>
 158   </number:currency-style>
 159   <number:currency-style style:name="N144P0" 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="N144">
 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="N144P0"/>
 171   </number:currency-style>
 172   <number:number-style style:name="N145">
 173    <number:number number:decimal-places="9" loext:min-decimal-places="9" number:min-integer-digits="1"/>
 174   </number:number-style>
 175   <number:number-style style:name="N146">
 176    <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
 177   </number:number-style>
 178   <number:number-style style:name="N147">
 179    <number:number number:decimal-places="10" loext:min-decimal-places="10" number:min-integer-digits="1"/>
 180   </number:number-style>
 181   <number:number-style style:name="N148">
 182    <number:number number:decimal-places="11" loext:min-decimal-places="11" number:min-integer-digits="1"/>
 183   </number:number-style>
 184   <number:number-style style:name="N149">
 185    <number:number number:decimal-places="12" loext:min-decimal-places="12" number:min-integer-digits="1"/>
 186   </number:number-style>
 187   <number:number-style style:name="N150">
 188    <number:number number:decimal-places="13" loext:min-decimal-places="13" number:min-integer-digits="1"/>
 189   </number:number-style>
 190   <number:number-style style:name="N151">
 191    <number:number number:decimal-places="14" loext:min-decimal-places="14" number:min-integer-digits="1"/>
 192   </number:number-style>
 193   <number:number-style style:name="N152">
 194    <number:number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1"/>
 195   </number:number-style>
 196   <number:number-style style:name="N153">
 197    <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/>
 198   </number:number-style>
 199   <number:number-style style:name="N154">
 200    <number:number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1"/>
 201   </number:number-style>
 202   <number:number-style style:name="N155">
 203    <number:number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1"/>
 204   </number:number-style>
 205   <number:number-style style:name="N156">
 206    <number:number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1"/>
 207   </number:number-style>
 208   <number:number-style style:name="N157">
 209    <number:number number:decimal-places="3" loext:min-decimal-places="3" number:min-integer-digits="1"/>
 210   </number:number-style>
 211   <number:number-style style:name="N158">
 212    <number:number number:decimal-places="4" loext:min-decimal-places="4" number:min-integer-digits="1"/>
 213   </number:number-style>
 214   <number:number-style style:name="N159">
 215    <number:number number:decimal-places="5" loext:min-decimal-places="5" number:min-integer-digits="1"/>
 216   </number:number-style>
 217   <number:number-style style:name="N160">
 218    <number:number number:decimal-places="6" loext:min-decimal-places="6" number:min-integer-digits="1"/>
 219   </number:number-style>
 220   <number:number-style style:name="N161">
 221    <number:number number:decimal-places="7" loext:min-decimal-places="7" number:min-integer-digits="1"/>
 222   </number:number-style>
 223   <number:currency-style style:name="N163P0" style:volatile="true">
 224    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 225    <number:text> </number:text>
 226    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 227   </number:currency-style>
 228   <number:currency-style style:name="N163">
 229    <style:text-properties fo:color="#ff0000"/>
 230    <number:text>-</number:text>
 231    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 232    <number:text> </number:text>
 233    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 234    <style:map style:condition="value()&gt;=0" style:apply-style-name="N163P0"/>
 235   </number:currency-style>
 236   <number:number-style style:name="N165P0" style:volatile="true">
 237    <number:text/>
 238   </number:number-style>
 239   <number:currency-style style:name="N165">
 240    <style:text-properties fo:color="#ff0000"/>
 241    <number:text>-</number:text>
 242    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 243    <number:text> </number:text>
 244    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 245    <style:map style:condition="value()&gt;=0" style:apply-style-name="N165P0"/>
 246   </number:currency-style>
 247   <number:date-style style:name="N166">
 248    <number:day-of-week/>
 249    <number:text> </number:text>
 250    <number:day number:style="long"/>
 251    <number:text>/</number:text>
 252    <number:month number:style="long"/>
 253    <number:text>/</number:text>
 254    <number:year/>
 255   </number:date-style>
 256   <number:date-style style:name="N167">
 257    <number:day-of-week number:style="long"/>
 258    <number:text>  </number:text>
 259    <number:day number:style="long"/>
 260    <number:text>/</number:text>
 261    <number:month number:style="long"/>
 262    <number:text>/</number:text>
 263    <number:year/>
 264   </number:date-style>
 265   <number:currency-style style:name="N169P0" style:volatile="true">
 266    <number:currency-symbol number:language="de" number:country="AT">€</number:currency-symbol>
 267    <number:text> </number:text>
 268    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 269   </number:currency-style>
 270   <number:currency-style style:name="N169">
 271    <style:text-properties fo:color="#ff0000"/>
 272    <number:text>-</number:text>
 273    <number:currency-symbol number:language="de" number:country="AT">€</number:currency-symbol>
 274    <number:text> </number:text>
 275    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 276    <style:map style:condition="value()&gt;=0" style:apply-style-name="N169P0"/>
 277   </number:currency-style>
 278   <style:style style:name="Default" style:family="table-cell">
 279    <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"/>
 280   </style:style>
 281   <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
 282    <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"/>
 283   </style:style>
 284   <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N122"/>
 285   <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
 286    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 287    <style:paragraph-properties fo:text-align="center"/>
 288    <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
 289   </style:style>
 290   <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
 291    <style:table-cell-properties style:rotation-angle="90"/>
 292   </style:style>
 293   <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
 294    <style:table-cell-properties fo:background-color="#ff3333"/>
 295   </style:style>
 296   <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
 297    <style:table-cell-properties fo:background-color="#99ff66"/>
 298   </style:style>
 299  </office:styles>
 300  <office:automatic-styles>
 301   <style:style style:name="co1" style:family="table-column">
 302    <style:table-column-properties fo:break-before="auto" style:column-width="185.7pt"/>
 303   </style:style>
 304   <style:style style:name="co2" style:family="table-column">
 305    <style:table-column-properties fo:break-before="auto" style:column-width="252.51pt"/>
 306   </style:style>
 307   <style:style style:name="co3" style:family="table-column">
 308    <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
 309   </style:style>
 310   <style:style style:name="co4" style:family="table-column">
 311    <style:table-column-properties fo:break-before="auto" style:column-width="124.44pt"/>
 312   </style:style>
 313   <style:style style:name="co5" style:family="table-column">
 314    <style:table-column-properties fo:break-before="auto" style:column-width="72.71pt"/>
 315   </style:style>
 316   <style:style style:name="co6" style:family="table-column">
 317    <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/>
 318   </style:style>
 319   <style:style style:name="co7" style:family="table-column">
 320    <style:table-column-properties fo:break-before="auto" style:column-width="219.71pt"/>
 321   </style:style>
 322   <style:style style:name="co8" style:family="table-column">
 323    <style:table-column-properties fo:break-before="auto" style:column-width="140.94pt"/>
 324   </style:style>
 325   <style:style style:name="co9" style:family="table-column">
 326    <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/>
 327   </style:style>
 328   <style:style style:name="co10" style:family="table-column">
 329    <style:table-column-properties fo:break-before="auto" style:column-width="71.21pt"/>
 330   </style:style>
 331   <style:style style:name="co11" style:family="table-column">
 332    <style:table-column-properties fo:break-before="auto" style:column-width="28.46pt"/>
 333   </style:style>
 334   <style:style style:name="ro1" style:family="table-row">
 335    <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 336   </style:style>
 337   <style:style style:name="ro2" style:family="table-row">
 338    <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 339   </style:style>
 340   <style:style style:name="ro3" style:family="table-row">
 341    <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 342   </style:style>
 343   <style:style style:name="ro4" style:family="table-row">
 344    <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 345   </style:style>
 346   <style:style style:name="ro5" style:family="table-row">
 347    <style:table-row-properties style:row-height="13.21pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 348   </style:style>
 349   <style:style style:name="ro6" style:family="table-row">
 350    <style:table-row-properties style:row-height="137.51pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 351   </style:style>
 352   <style:style style:name="ro7" style:family="table-row">
 353    <style:table-row-properties style:row-height="46.15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 354   </style:style>
 355   <style:style style:name="ro8" style:family="table-row">
 356    <style:table-row-properties style:row-height="15.36pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 357   </style:style>
 358   <style:style style:name="ro9" style:family="table-row">
 359    <style:table-row-properties style:row-height="35.04pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 360   </style:style>
 361   <style:style style:name="ro10" style:family="table-row">
 362    <style:table-row-properties style:row-height="24.01pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 363   </style:style>
 364   <style:style style:name="ro11" style:family="table-row">
 365    <style:table-row-properties style:row-height="79.31pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 366   </style:style>
 367   <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
 368    <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
 369   </style:style>
 370   <number:date-style style:name="N36" number:automatic-order="true">
 371    <number:month number:style="long"/>
 372    <number:text>/</number:text>
 373    <number:day number:style="long"/>
 374    <number:text>/</number:text>
 375    <number:year number:style="long"/>
 376   </number:date-style>
 377   <number:boolean-style style:name="N99">
 378    <number:boolean/>
 379   </number:boolean-style>
 380   <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
 381   <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
 382    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 383    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 384    <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"/>
 385   </style:style>
 386   <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
 387    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 388    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 389    <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"/>
 390   </style:style>
 391   <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
 392    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 393    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 394    <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"/>
 395   </style:style>
 396   <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
 397    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 398    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 399   </style:style>
 400   <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 401    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 402    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 403    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 404    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 405    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 406   </style:style>
 407   <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 408    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 409    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 410    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 411    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 412    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 413   </style:style>
 414   <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
 415    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 416    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 417    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 418    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 419    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 420   </style:style>
 421   <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
 422    <style:table-cell-properties fo:wrap-option="wrap"/>
 423    <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="Liberation Serif" 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="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" 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"/>
 424   </style:style>
 425   <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
 426    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 427    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 428    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 429   </style:style>
 430   <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default">
 431    <style:text-properties fo:language="nl" fo:country="NL"/>
 432   </style:style>
 433   <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default">
 434    <style:text-properties style:font-name="Liberation Serif" fo:language="en" fo:country="US" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 435   </style:style>
 436   <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">
 437    <style:table-cell-properties fo:background-color="transparent"/>
 438   </style:style>
 439   <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 440    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 441    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 442    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 443    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 444    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 445   </style:style>
 446   <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 447    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 448    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 449    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/>
 450    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/>
 451    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/>
 452   </style:style>
 453   <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 454    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 455    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 456    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C7"/>
 457    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C7"/>
 458    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C7"/>
 459   </style:style>
 460   <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 461    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 462    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 463    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C7"/>
 464    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C7"/>
 465    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C7"/>
 466   </style:style>
 467   <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 468    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C10"/>
 469    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C10"/>
 470    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C10"/>
 471   </style:style>
 472   <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default">
 473    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/>
 474    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/>
 475    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/>
 476   </style:style>
 477   <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 478    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 479    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 480    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 481    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 482    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 483   </style:style>
 484   <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 485    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 486    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 487    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C16"/>
 488    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C16"/>
 489    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C16"/>
 490   </style:style>
 491   <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 492    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 493    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 494    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C19"/>
 495    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C19"/>
 496    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C19"/>
 497   </style:style>
 498   <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
 499    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 500    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 501    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 502    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 503    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 504   </style:style>
 505   <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default">
 506    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 507    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 508    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 509   </style:style>
 510   <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
 511    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 512    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 513    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 514   </style:style>
 515   <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">
 516    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 517    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 518    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 519    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 520    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 521   </style:style>
 522   <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default">
 523    <style:text-properties style:font-name="Liberation Serif" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 524   </style:style>
 525   <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default">
 526    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 527   </style:style>
 528   <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36">
 529    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 530   </style:style>
 531   <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"/>
 532   <style:style style:name="ta_extref" style:family="table">
 533    <style:table-properties table:display="false"/>
 534   </style:style>
 535   <style:page-layout style:name="pm1">
 536    <style:page-layout-properties style:writing-mode="lr-tb"/>
 537    <style:header-style>
 538     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
 539    </style:header-style>
 540    <style:footer-style>
 541     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
 542    </style:footer-style>
 543   </style:page-layout>
 544   <style:page-layout style:name="pm2">
 545    <style:page-layout-properties style:writing-mode="lr-tb"/>
 546    <style:header-style>
 547     <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">
 548      <style:background-image/>
 549     </style:header-footer-properties>
 550    </style:header-style>
 551    <style:footer-style>
 552     <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">
 553      <style:background-image/>
 554     </style:header-footer-properties>
 555    </style:footer-style>
 556   </style:page-layout>
 557  </office:automatic-styles>
 558  <office:master-styles>
 559   <style:master-page style:name="Default" style:page-layout-name="pm1">
 560    <style:header>
 561     <text:p><text:sheet-name>???</text:sheet-name></text:p>
 562    </style:header>
 563    <style:header-left style:display="false"/>
 564    <style:footer>
 565     <text:p>Page <text:page-number>1</text:page-number></text:p>
 566    </style:footer>
 567    <style:footer-left style:display="false"/>
 568   </style:master-page>
 569   <style:master-page style:name="Report" style:page-layout-name="pm2">
 570    <style:header>
 571     <style:region-left>
 572      <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
 573     </style:region-left>
 574     <style:region-right>
 575      <text:p><text:date style:data-style-name="N2" text:date-value="2016-07-16">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="16:34:52.437011940">00:00:00</text:time></text:p>
 576     </style:region-right>
 577    </style:header>
 578    <style:header-left style:display="false"/>
 579    <style:footer>
 580     <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
 581    </style:footer>
 582    <style:footer-left style:display="false"/>
 583   </style:master-page>
 584  </office:master-styles>
 585  <office:body>
 586   <office:spreadsheet>
 587    <table:calculation-settings table:automatic-find-labels="false"/>
 588    <table:table table:name="Sheet1" table:style-name="ta1">
 589     <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
 590     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
 591     <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/>
 592     <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
 593     <table:table-row table:style-name="ro1">
 594      <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
 595       <text:p>YEARS Function</text:p>
 596      </table:table-cell>
 597      <table:table-cell table:number-columns-repeated="2"/>
 598     </table:table-row>
 599     <table:table-row table:style-name="ro2">
 600      <table:table-cell table:number-columns-repeated="3"/>
 601     </table:table-row>
 602     <table:table-row table:style-name="ro3">
 603      <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string">
 604       <text:p>Result</text:p>
 605      </table:table-cell>
 606      <table:table-cell table:style-name="ce6" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 607       <text:p>TRUE</text:p>
 608      </table:table-cell>
 609      <table:table-cell/>
 610     </table:table-row>
 611     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 612      <table:table-cell table:number-columns-repeated="3"/>
 613     </table:table-row>
 614     <table:table-row table:style-name="ro4">
 615      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 616       <text:p>Sheet</text:p>
 617      </table:table-cell>
 618      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 619       <text:p>Result</text:p>
 620      </table:table-cell>
 621      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 622       <text:p>Description</text:p>
 623      </table:table-cell>
 624     </table:table-row>
 625     <table:table-row table:style-name="ro5">
 626      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 627       <text:p>1</text:p>
 628      </table:table-cell>
 629      <table:table-cell table:style-name="ce7" table:formula="of:=AND([Sheet2.C2:.C49])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 630       <text:p>TRUE</text:p>
 631      </table:table-cell>
 632      <table:table-cell office:value-type="string" calcext:value-type="string">
 633       <text:p>SimpleYEARS formulas with local references and values</text:p>
 634      </table:table-cell>
 635     </table:table-row>
 636     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 637      <table:table-cell/>
 638      <table:table-cell table:style-name="ce8"/>
 639      <table:table-cell/>
 640     </table:table-row>
 641     <table:table-row table:style-name="ro2">
 642      <table:table-cell/>
 643      <table:table-cell table:style-name="ce8"/>
 644      <table:table-cell table:style-name="ce9"/>
 645     </table:table-row>
 646     <table:table-row table:style-name="ro2" table:number-rows-repeated="26">
 647      <table:table-cell/>
 648      <table:table-cell table:style-name="ce8"/>
 649      <table:table-cell/>
 650     </table:table-row>
 651     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
 652      <table:table-cell table:number-columns-repeated="3"/>
 653     </table:table-row>
 654     <table:table-row table:style-name="ro2">
 655      <table:table-cell table:number-columns-repeated="3"/>
 656     </table:table-row>
 657     <calcext:conditional-formats>
 658      <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
 659       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
 660       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
 661       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
 662      </calcext:conditional-format>
 663      <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
 664       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
 665       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
 666       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
 667      </calcext:conditional-format>
 668     </calcext:conditional-formats>
 669    </table:table>
 670    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
 671     <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
 672     <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
 673     <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
 674     <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/>
 675     <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
 676     <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
 677     <table:table-column table:style-name="co9" table:number-columns-repeated="4" table:default-cell-style-name="Default"/>
 678     <table:table-column table:style-name="co6" table:default-cell-style-name="Default"/>
 679     <table:table-column table:style-name="co10" table:default-cell-style-name="Default"/>
 680     <table:table-column table:style-name="co11" table:default-cell-style-name="Default"/>
 681     <table:table-column table:style-name="co3" table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
 682     <table:table-row table:style-name="ro2">
 683      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 684       <text:p>Function</text:p>
 685      </table:table-cell>
 686      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 687       <text:p>Expected</text:p>
 688      </table:table-cell>
 689      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 690       <text:p>Correct</text:p>
 691      </table:table-cell>
 692      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 693       <text:p>FunctionString</text:p>
 694      </table:table-cell>
 695      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 696       <text:p>Comment</text:p>
 697      </table:table-cell>
 698      <table:table-cell table:number-columns-repeated="4"/>
 699      <table:table-cell table:style-name="ce28"/>
 700      <table:table-cell office:value-type="string" calcext:value-type="string">
 701       <text:p>DATA</text:p>
 702      </table:table-cell>
 703      <table:table-cell table:style-name="ce28"/>
 704      <table:table-cell table:style-name="ce5" table:number-matrix-columns-spanned="1" table:number-matrix-rows-spanned="7" table:formula="of:={1|0|0|0|0|0|1}" office:value-type="float" office:value="1" calcext:value-type="float">
 705       <text:p>1</text:p>
 706      </table:table-cell>
 707      <table:table-cell table:style-name="ce28"/>
 708     </table:table-row>
 709     <table:table-row table:style-name="ro2">
 710      <table:table-cell table:formula="of:=ORG.OPENOFFICE.YEARS([.K2];[.K3];[.K4:.K6])" office:value-type="string" office:string-value="" calcext:value-type="error">
 711       <text:p>#VALUE!</text:p>
 712      </table:table-cell>
 713      <table:table-cell office:value-type="string" calcext:value-type="string">
 714       <text:p>err</text:p>
 715      </table:table-cell>
 716      <table:table-cell table:style-name="ce14" table:formula="of:=ISERROR([.A2])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 717       <text:p>TRUE</text:p>
 718      </table:table-cell>
 719      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=YEARS(K2,K3,K4:K6)" calcext:value-type="string">
 720       <text:p>=YEARS(K2,K3,K4:K6)</text:p>
 721      </table:table-cell>
 722      <table:table-cell table:number-columns-repeated="6"/>
 723      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2014-11-01" calcext:value-type="date">
 724       <text:p>11/01/2014</text:p>
 725      </table:table-cell>
 726      <table:table-cell/>
 727      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="0" calcext:value-type="float">
 728       <text:p>0</text:p>
 729      </table:table-cell>
 730      <table:table-cell/>
 731     </table:table-row>
 732     <table:table-row table:style-name="ro2">
 733      <table:table-cell table:style-name="ce11" table:formula="of:=ORG.OPENOFFICE.YEARS([.K2];[.K2];[.K2])" office:value-type="string" office:string-value="" calcext:value-type="error">
 734       <text:p>Err:502</text:p>
 735      </table:table-cell>
 736      <table:table-cell office:value-type="string" calcext:value-type="string">
 737       <text:p>err</text:p>
 738      </table:table-cell>
 739      <table:table-cell table:style-name="ce14" table:formula="of:=ISERROR([.A3])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 740       <text:p>TRUE</text:p>
 741      </table:table-cell>
 742      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=YEARS(K2,K2,K2)" calcext:value-type="string">
 743       <text:p>=YEARS(K2,K2,K2)</text:p>
 744      </table:table-cell>
 745      <table:table-cell table:number-columns-repeated="6"/>
 746      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2017-11-30" calcext:value-type="date">
 747       <text:p>11/30/2017</text:p>
 748      </table:table-cell>
 749      <table:table-cell/>
 750      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="0" calcext:value-type="float">
 751       <text:p>0</text:p>
 752      </table:table-cell>
 753      <table:table-cell/>
 754     </table:table-row>
 755     <table:table-row table:style-name="ro2">
 756      <table:table-cell table:style-name="ce11" table:formula="of:=ORG.OPENOFFICE.YEARS([.K2];[.K3];[.L2])" office:value-type="float" office:value="3" calcext:value-type="float">
 757       <text:p>3</text:p>
 758      </table:table-cell>
 759      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
 760       <text:p>3</text:p>
 761      </table:table-cell>
 762      <table:table-cell table:style-name="ce15" table:formula="of:=[.A4]=[.B4]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 763       <text:p>TRUE</text:p>
 764      </table:table-cell>
 765      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=YEARS(K2,K3,L2)" calcext:value-type="string">
 766       <text:p>=YEARS(K2,K3,L2)</text:p>
 767      </table:table-cell>
 768      <table:table-cell table:number-columns-repeated="5"/>
 769      <table:table-cell table:style-name="ce28"/>
 770      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2014-11-11" calcext:value-type="date">
 771       <text:p>11/11/2014</text:p>
 772      </table:table-cell>
 773      <table:table-cell table:style-name="ce28"/>
 774      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="0" calcext:value-type="float">
 775       <text:p>0</text:p>
 776      </table:table-cell>
 777      <table:table-cell table:style-name="ce28"/>
 778     </table:table-row>
 779     <table:table-row table:style-name="ro2">
 780      <table:table-cell table:style-name="ce11" table:formula="of:=ORG.OPENOFFICE.YEARS([.K2];[.K3];)" office:value-type="string" office:string-value="" calcext:value-type="error">
 781       <text:p>Err:502</text:p>
 782      </table:table-cell>
 783      <table:table-cell office:value-type="string" calcext:value-type="string">
 784       <text:p>err</text:p>
 785      </table:table-cell>
 786      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A5])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 787       <text:p>TRUE</text:p>
 788      </table:table-cell>
 789      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=YEARS(K2,K3,)" calcext:value-type="string">
 790       <text:p>=YEARS(K2,K3,)</text:p>
 791      </table:table-cell>
 792      <table:table-cell table:number-columns-repeated="6"/>
 793      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2014-11-27" calcext:value-type="date">
 794       <text:p>11/27/2014</text:p>
 795      </table:table-cell>
 796      <table:table-cell/>
 797      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="0" calcext:value-type="float">
 798       <text:p>0</text:p>
 799      </table:table-cell>
 800      <table:table-cell/>
 801     </table:table-row>
 802     <table:table-row table:style-name="ro2">
 803      <table:table-cell table:style-name="ce11" table:formula="of:=ORG.OPENOFFICE.YEARS([.K3];[.K2];)" office:value-type="string" office:string-value="" calcext:value-type="error">
 804       <text:p>Err:502</text:p>
 805      </table:table-cell>
 806      <table:table-cell office:value-type="string" calcext:value-type="string">
 807       <text:p>err</text:p>
 808      </table:table-cell>
 809      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A6])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 810       <text:p>TRUE</text:p>
 811      </table:table-cell>
 812      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=YEARS(K3,K2,)" calcext:value-type="string">
 813       <text:p>=YEARS(K3,K2,)</text:p>
 814      </table:table-cell>
 815      <table:table-cell table:number-columns-repeated="6"/>
 816      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2014-11-28" calcext:value-type="date">
 817       <text:p>11/28/2014</text:p>
 818      </table:table-cell>
 819      <table:table-cell/>
 820      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="0" calcext:value-type="float">
 821       <text:p>0</text:p>
 822      </table:table-cell>
 823      <table:table-cell/>
 824     </table:table-row>
 825     <table:table-row table:style-name="ro2">
 826      <table:table-cell table:style-name="ce11" table:formula="of:=ORG.OPENOFFICE.YEARS([.K2];[.K2]+6;;{1|0|1|0|1|0|1})" office:value-type="string" office:string-value="" calcext:value-type="error">
 827       <text:p>Err:504</text:p>
 828      </table:table-cell>
 829      <table:table-cell office:value-type="string" calcext:value-type="string">
 830       <text:p>err</text:p>
 831      </table:table-cell>
 832      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A7])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 833       <text:p>TRUE</text:p>
 834      </table:table-cell>
 835      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=YEARS(K2,K2+6,,{1;0;1;0;1;0;1})" calcext:value-type="string">
 836       <text:p>=YEARS(K2,K2+6,,{1;0;1;0;1;0;1})</text:p>
 837      </table:table-cell>
 838      <table:table-cell table:number-columns-repeated="5"/>
 839      <table:table-cell table:style-name="ce28"/>
 840      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2001-12-24" calcext:value-type="date">
 841       <text:p>12/24/2001</text:p>
 842      </table:table-cell>
 843      <table:table-cell table:style-name="ce28"/>
 844      <table:table-cell table:style-name="ce5" office:value-type="float" office:value="1" calcext:value-type="float">
 845       <text:p>1</text:p>
 846      </table:table-cell>
 847      <table:table-cell table:style-name="ce28"/>
 848     </table:table-row>
 849     <table:table-row table:style-name="ro5">
 850      <table:table-cell table:formula="of:=ORG.OPENOFFICE.YEARS(day1ref;day2ref;one)" office:value-type="float" office:value="3" calcext:value-type="float">
 851       <text:p>3</text:p>
 852      </table:table-cell>
 853      <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
 854       <text:p>3</text:p>
 855      </table:table-cell>
 856      <table:table-cell table:style-name="ce17" table:formula="of:=[.A8]=[.B8]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 857       <text:p>TRUE</text:p>
 858      </table:table-cell>
 859      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=YEARS(day1ref,day2ref,one)" calcext:value-type="string">
 860       <text:p>=YEARS(day1ref,day2ref,one)</text:p>
 861      </table:table-cell>
 862      <table:table-cell table:number-columns-repeated="6"/>
 863      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2001-12-25" calcext:value-type="date">
 864       <text:p>12/25/2001</text:p>
 865      </table:table-cell>
 866      <table:table-cell table:number-columns-repeated="3"/>
 867     </table:table-row>
 868     <table:table-row table:style-name="ro5">
 869      <table:table-cell table:style-name="ce12" table:formula="of:=ORG.OPENOFFICE.YEARS(DATE(2014;1;15);DATE(2016;4;1);0)" office:value-type="float" office:value="2" calcext:value-type="float">
 870       <text:p>2</text:p>
 871      </table:table-cell>
 872      <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
 873       <text:p>2</text:p>
 874      </table:table-cell>
 875      <table:table-cell table:style-name="ce15" table:formula="of:=[.A9]=[.B9]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 876       <text:p>TRUE</text:p>
 877      </table:table-cell>
 878      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=YEARS(DATE(2014,1,15),DATE(2016,4,1),0)" calcext:value-type="string">
 879       <text:p>=YEARS(DATE(2014,1,15),DATE(2016,4,1),0)</text:p>
 880      </table:table-cell>
 881      <table:table-cell table:number-columns-repeated="6"/>
 882      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2001-12-26" calcext:value-type="date">
 883       <text:p>12/26/2001</text:p>
 884      </table:table-cell>
 885      <table:table-cell table:number-columns-repeated="3"/>
 886     </table:table-row>
 887     <table:table-row table:style-name="ro2">
 888      <table:table-cell table:style-name="ce13" table:formula="of:=ORG.OPENOFFICE.WEEKS(DATE(2014;11;1);DATE(2014;11;30);{&quot;Hello&quot;|&quot;Eike&quot;|&quot;!&quot;})" office:value-type="string" office:string-value="" calcext:value-type="error">
 889       <text:p>#VALUE!</text:p>
 890      </table:table-cell>
 891      <table:table-cell office:value-type="string" calcext:value-type="string">
 892       <text:p>Err</text:p>
 893      </table:table-cell>
 894      <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A10])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 895       <text:p>TRUE</text:p>
 896      </table:table-cell>
 897      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=WEEKS(DATE(2014,11,1),DATE(2014,11,30),{&quot;Hello&quot;;&quot;Eike&quot;;&quot;!&quot;})" calcext:value-type="string">
 898       <text:p>=WEEKS(DATE(2014,11,1),DATE(2014,11,30),{&quot;Hello&quot;;&quot;Eike&quot;;&quot;!&quot;})</text:p>
 899      </table:table-cell>
 900      <table:table-cell office:value-type="string" calcext:value-type="string">
 901       <text:p>TDF#100409</text:p>
 902      </table:table-cell>
 903      <table:table-cell table:number-columns-repeated="4"/>
 904      <table:table-cell table:style-name="ce28"/>
 905      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2001-12-31" calcext:value-type="date">
 906       <text:p>12/31/2001</text:p>
 907      </table:table-cell>
 908      <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
 909     </table:table-row>
 910     <table:table-row table:style-name="ro2">
 911      <table:table-cell table:style-name="ce13" table:formula="of:=ORG.OPENOFFICE.YEARS([.K16];[.K17];0)" office:value-type="float" office:value="115" calcext:value-type="float">
 912       <text:p>115</text:p>
 913      </table:table-cell>
 914      <table:table-cell office:value-type="float" office:value="115" calcext:value-type="float">
 915       <text:p>115</text:p>
 916      </table:table-cell>
 917      <table:table-cell table:style-name="ce18" table:formula="of:=[.A11]=[.B11]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 918       <text:p>TRUE</text:p>
 919      </table:table-cell>
 920      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=YEARS(K16,K17,0)" calcext:value-type="string">
 921       <text:p>=YEARS(K16,K17,0)</text:p>
 922      </table:table-cell>
 923      <table:table-cell table:number-columns-repeated="6"/>
 924      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2002-01-01" calcext:value-type="date">
 925       <text:p>01/01/2002</text:p>
 926      </table:table-cell>
 927      <table:table-cell table:number-columns-repeated="3"/>
 928     </table:table-row>
 929     <table:table-row table:style-name="ro2">
 930      <table:table-cell table:style-name="ce12" table:formula="of:=ORG.OPENOFFICE.YEARS(DATE(2014;1;15);DATE(2016;4;1);2)" office:value-type="string" office:string-value="" calcext:value-type="error">
 931       <text:p>Err:502</text:p>
 932      </table:table-cell>
 933      <table:table-cell office:value-type="string" calcext:value-type="string">
 934       <text:p>Err</text:p>
 935      </table:table-cell>
 936      <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A12])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 937       <text:p>TRUE</text:p>
 938      </table:table-cell>
 939      <table:table-cell table:style-name="ce27" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=YEARS(DATE(2014,1,15),DATE(2016,4,1),2)" calcext:value-type="string">
 940       <text:p>=YEARS(DATE(2014,1,15),DATE(2016,4,1),2)</text:p>
 941      </table:table-cell>
 942      <table:table-cell office:value-type="string" calcext:value-type="string">
 943       <text:p>Tdf#100440</text:p>
 944      </table:table-cell>
 945      <table:table-cell table:number-columns-repeated="5"/>
 946      <table:table-cell office:value-type="float" office:value="17" calcext:value-type="float">
 947       <text:p>17</text:p>
 948      </table:table-cell>
 949      <table:table-cell table:number-columns-repeated="3"/>
 950     </table:table-row>
 951     <table:table-row table:style-name="ro2">
 952      <table:table-cell table:number-columns-repeated="2"/>
 953      <table:table-cell table:style-name="ce19"/>
 954      <table:table-cell table:style-name="ce27"/>
 955      <table:table-cell table:number-columns-repeated="5"/>
 956      <table:table-cell table:style-name="ce28"/>
 957      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2001-12-01" calcext:value-type="date">
 958       <text:p>12/01/2001</text:p>
 959      </table:table-cell>
 960      <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
 961     </table:table-row>
 962     <table:table-row table:style-name="ro2">
 963      <table:table-cell table:number-columns-repeated="2"/>
 964      <table:table-cell table:style-name="ce20"/>
 965      <table:table-cell table:style-name="ce27"/>
 966      <table:table-cell table:number-columns-repeated="10"/>
 967     </table:table-row>
 968     <table:table-row table:style-name="ro2">
 969      <table:table-cell table:number-columns-repeated="2"/>
 970      <table:table-cell table:style-name="ce20"/>
 971      <table:table-cell table:style-name="ce27"/>
 972      <table:table-cell table:number-columns-repeated="6"/>
 973      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="1899-12-30" calcext:value-type="date">
 974       <text:p>12/30/1899</text:p>
 975      </table:table-cell>
 976      <table:table-cell table:number-columns-repeated="3"/>
 977     </table:table-row>
 978     <table:table-row table:style-name="ro2">
 979      <table:table-cell table:number-columns-repeated="2"/>
 980      <table:table-cell table:style-name="ce21"/>
 981      <table:table-cell table:number-columns-repeated="6"/>
 982      <table:table-cell table:style-name="ce29"/>
 983      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="1899-12-30" calcext:value-type="date">
 984       <text:p>12/30/1899</text:p>
 985      </table:table-cell>
 986      <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
 987     </table:table-row>
 988     <table:table-row table:style-name="ro2">
 989      <table:table-cell table:number-columns-repeated="2"/>
 990      <table:table-cell table:style-name="ce21"/>
 991      <table:table-cell/>
 992      <table:table-cell office:value-type="string" calcext:value-type="string">
 993       <text:p>Tdf#96756 bug</text:p>
 994      </table:table-cell>
 995      <table:table-cell table:number-columns-repeated="5"/>
 996      <table:table-cell table:style-name="ce30" office:value-type="date" office:date-value="2015-01-02" calcext:value-type="date">
 997       <text:p>01/02/2015</text:p>
 998      </table:table-cell>
 999      <table:table-cell table:number-columns-repeated="3"/>
1000     </table:table-row>
1001     <table:table-row table:style-name="ro2">
1002      <table:table-cell table:number-columns-repeated="2"/>
1003      <table:table-cell table:style-name="Default"/>
1004      <table:table-cell table:number-columns-repeated="11"/>
1005     </table:table-row>
1006     <table:table-row table:style-name="ro2">
1007      <table:table-cell table:number-columns-repeated="2"/>
1008      <table:table-cell table:style-name="ce22"/>
1009      <table:table-cell table:style-name="ce27"/>
1010      <table:table-cell table:number-columns-repeated="10"/>
1011     </table:table-row>
1012     <table:table-row table:style-name="ro2" table:number-rows-repeated="4">
1013      <table:table-cell table:number-columns-repeated="2"/>
1014      <table:table-cell table:style-name="ce23"/>
1015      <table:table-cell table:number-columns-repeated="11"/>
1016     </table:table-row>
1017     <table:table-row table:style-name="ro6">
1018      <table:table-cell table:number-columns-repeated="2"/>
1019      <table:table-cell table:style-name="ce23"/>
1020      <table:table-cell table:number-columns-repeated="6"/>
1021      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARS</text:p><text:p/><text:p>Calculates the difference in years between two dates.</text:p><text:p>Syntax</text:p><text:p/><text:p>YEARS(StartDate; EndDate; Type)</text:p><text:p/><text:p>StartDate is the first date</text:p><text:p/><text:p>EndDate is the second date</text:p><text:p/><text:p>Type calculates the type of difference. Possible values are 0 (interval) and 1 (in calendar years).</text:p>
1022      </table:table-cell>
1023      <table:table-cell table:number-columns-repeated="4"/>
1024     </table:table-row>
1025     <table:table-row table:style-name="ro7">
1026      <table:table-cell table:number-columns-repeated="2"/>
1027      <table:table-cell table:style-name="ce23"/>
1028      <table:table-cell table:number-columns-repeated="11"/>
1029     </table:table-row>
1030     <table:table-row table:style-name="ro8">
1031      <table:table-cell table:number-columns-repeated="2"/>
1032      <table:table-cell table:style-name="ce23"/>
1033      <table:table-cell table:number-columns-repeated="11"/>
1034     </table:table-row>
1035     <table:table-row table:style-name="ro9">
1036      <table:table-cell table:number-columns-repeated="2"/>
1037      <table:table-cell table:style-name="ce23"/>
1038      <table:table-cell table:number-columns-repeated="6"/>
1039      <table:table-cell table:style-name="ce30"/>
1040      <table:table-cell table:number-columns-repeated="4"/>
1041     </table:table-row>
1042     <table:table-row table:style-name="ro10">
1043      <table:table-cell table:number-columns-repeated="2"/>
1044      <table:table-cell table:style-name="ce19"/>
1045      <table:table-cell table:number-columns-repeated="11"/>
1046     </table:table-row>
1047     <table:table-row table:style-name="ro10">
1048      <table:table-cell table:number-columns-repeated="2"/>
1049      <table:table-cell table:style-name="ce24"/>
1050      <table:table-cell table:number-columns-repeated="11"/>
1051     </table:table-row>
1052     <table:table-row table:style-name="ro11">
1053      <table:table-cell table:number-columns-repeated="2"/>
1054      <table:table-cell table:style-name="ce25"/>
1055      <table:table-cell table:number-columns-repeated="11"/>
1056     </table:table-row>
1057     <table:table-row table:style-name="ro2">
1058      <table:table-cell table:number-columns-repeated="2"/>
1059      <table:table-cell table:style-name="ce25"/>
1060      <table:table-cell table:number-columns-repeated="11"/>
1061     </table:table-row>
1062     <table:table-row table:style-name="ro2" table:number-rows-repeated="69">
1063      <table:table-cell table:number-columns-repeated="2"/>
1064      <table:table-cell table:style-name="ce26"/>
1065      <table:table-cell table:number-columns-repeated="11"/>
1066     </table:table-row>
1067     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048475">
1068      <table:table-cell table:number-columns-repeated="14"/>
1069     </table:table-row>
1070     <table:table-row table:style-name="ro2">
1071      <table:table-cell table:number-columns-repeated="14"/>
1072     </table:table-row>
1073     <calcext:conditional-formats>
1074      <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C100 Sheet2.C20:Sheet2.C27 Sheet2.C2:Sheet2.C3 Sheet2.C14:Sheet2.C15">
1075       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1076       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1077       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1078      </calcext:conditional-format>
1079      <calcext:conditional-format calcext:target-range-address="Sheet2.C16:Sheet2.C17">
1080       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C16"/>
1081       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C16"/>
1082       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C16"/>
1083      </calcext:conditional-format>
1084      <calcext:conditional-format calcext:target-range-address="Sheet2.C19:Sheet2.C19">
1085       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C19"/>
1086       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C19"/>
1087       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C19"/>
1088      </calcext:conditional-format>
1089      <calcext:conditional-format calcext:target-range-address="Sheet2.C5:Sheet2.C7">
1090       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C7"/>
1091       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C7"/>
1092       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C7"/>
1093      </calcext:conditional-format>
1094      <calcext:conditional-format calcext:target-range-address="Sheet2.C5:Sheet2.C8">
1095       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C7"/>
1096       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C7"/>
1097       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C7"/>
1098      </calcext:conditional-format>
1099      <calcext:conditional-format calcext:target-range-address="Sheet2.C19:Sheet2.C29 Sheet2.C13:Sheet2.C17 Sheet2.C4:Sheet2.C9">
1100       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C3"/>
1101       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C3"/>
1102       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C3"/>
1103      </calcext:conditional-format>
1104      <calcext:conditional-format calcext:target-range-address="Sheet2.C10:Sheet2.C12">
1105       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C10"/>
1106       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C10"/>
1107       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C10"/>
1108      </calcext:conditional-format>
1109     </calcext:conditional-formats>
1110    </table:table>
1111    <table:table table:name="&apos;file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/years.fods/years.fods/years.fods/years.fods/years.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1112     <table:table-source xlink:type="simple" xlink:href="years.fods/years.fods/years.fods/years.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1113     <table:table-column table:number-columns-repeated="8"/>
1114     <table:table-row table:number-rows-repeated="2">
1115      <table:table-cell table:number-columns-repeated="8"/>
1116     </table:table-row>
1117     <table:table-row>
1118      <table:table-cell table:number-columns-repeated="7"/>
1119      <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4">
1120       <text:p>4</text:p>
1121      </table:table-cell>
1122     </table:table-row>
1123    </table:table>
1124    <table:named-expressions>
1125     <table:named-range table:name="day1ref" table:base-cell-address="$Sheet2.$K$2" table:cell-range-address="$Sheet2.$K$2"/>
1126     <table:named-range table:name="day2ref" table:base-cell-address="$Sheet2.$K$3" table:cell-range-address="$Sheet2.$K$3"/>
1127     <table:named-range table:name="days" table:base-cell-address="$Sheet2.$K$4" table:cell-range-address="$Sheet2.$K$4:.$K$6"/>
1128     <table:named-range table:name="one" table:base-cell-address="$Sheet2.$M$1" table:cell-range-address="$Sheet2.$M$1"/>
1129    </table:named-expressions>
1130   </office:spreadsheet>
1131  </office:body>
1132 </office:document>