sc/qa/unit/data/functions/date_time/fods/yearfrac.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:table-cell-properties style:decimal-places="2"/>
   7    <style:paragraph-properties style:tab-stop-distance="36pt"/>
   8    <style:text-properties style:font-name="Arial" fo:language="en" fo:country="US" style:font-name-asian="Lucida Sans Unicode" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="Tahoma" style:language-complex="hi" style:country-complex="IN"/>
   9   </style:default-style>
  10   <number:number-style style:name="N0">
  11    <number:number number:min-integer-digits="1"/>
  12   </number:number-style>
  13   <number:currency-style style:name="N108P0" style:volatile="true">
  14    <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
  15    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  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:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
  21    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  22    <style:map style:condition="value()&gt;=0" style:apply-style-name="N108P0"/>
  23   </number:currency-style>
  24   <number:number-style style:name="N109">
  25    <number:number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1"/>
  26   </number:number-style>
  27   <number:number-style style:name="N110">
  28    <number:number number:decimal-places="3" loext:min-decimal-places="3" number:min-integer-digits="1"/>
  29   </number:number-style>
  30   <number:number-style style:name="N111">
  31    <number:number number:decimal-places="4" loext:min-decimal-places="4" number:min-integer-digits="1"/>
  32   </number:number-style>
  33   <number:number-style style:name="N112">
  34    <number:number number:decimal-places="5" loext:min-decimal-places="5" number:min-integer-digits="1"/>
  35   </number:number-style>
  36   <number:number-style style:name="N113">
  37    <number:number number:decimal-places="6" loext:min-decimal-places="6" number:min-integer-digits="1"/>
  38   </number:number-style>
  39   <number:number-style style:name="N114">
  40    <number:number number:decimal-places="7" loext:min-decimal-places="7" number:min-integer-digits="1"/>
  41   </number:number-style>
  42   <number:number-style style:name="N115">
  43    <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
  44   </number:number-style>
  45   <number:currency-style style:name="N117P0" style:volatile="true">
  46    <number:currency-symbol number:language="nl" number:country="NL">€</number:currency-symbol>
  47    <number:text> </number:text>
  48    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  49   </number:currency-style>
  50   <number:currency-style style:name="N117">
  51    <style:text-properties fo:color="#ff0000"/>
  52    <number:currency-symbol number:language="nl" number:country="NL">€</number:currency-symbol>
  53    <number:text> </number:text>
  54    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  55    <number:text>-</number:text>
  56    <style:map style:condition="value()&gt;=0" style:apply-style-name="N117P0"/>
  57   </number:currency-style>
  58   <number:currency-style style:name="N119P0" style:volatile="true">
  59    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  60    <number:text> </number:text>
  61    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  62   </number:currency-style>
  63   <number:currency-style style:name="N119">
  64    <style:text-properties fo:color="#ff0000"/>
  65    <number:text>-</number:text>
  66    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  67    <number:text> </number:text>
  68    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  69    <style:map style:condition="value()&gt;=0" style:apply-style-name="N119P0"/>
  70   </number:currency-style>
  71   <style:style style:name="Default" style:family="table-cell">
  72    <style:text-properties style:font-name-asian="SimSun" style:font-family-asian="SimSun" style:font-family-generic-asian="system" style:font-pitch-asian="variable"/>
  73   </style:style>
  74   <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
  75    <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"/>
  76   </style:style>
  77   <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N108"/>
  78   <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
  79    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
  80    <style:paragraph-properties fo:text-align="center"/>
  81    <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
  82   </style:style>
  83   <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
  84    <style:table-cell-properties style:rotation-angle="90"/>
  85   </style:style>
  86   <style:style style:name="Bez_20_názvu1" style:display-name="Bez názvu1" style:family="table-cell" style:parent-style-name="Default">
  87    <style:table-cell-properties fo:background-color="#ff3333"/>
  88   </style:style>
  89   <style:style style:name="Bez_20_názvu2" style:display-name="Bez názvu2" style:family="table-cell" style:parent-style-name="Default">
  90    <style:table-cell-properties fo:background-color="#99ff66"/>
  91   </style:style>
  92   <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
  93    <style:table-cell-properties fo:background-color="#ff3333"/>
  94   </style:style>
  95   <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
  96    <style:table-cell-properties fo:background-color="#99ff66"/>
  97   </style:style>
  98  </office:styles>
  99  <office:automatic-styles>
 100   <style:style style:name="co1" style:family="table-column">
 101    <style:table-column-properties fo:break-before="auto" style:column-width="207.81pt"/>
 102   </style:style>
 103   <style:style style:name="co2" style:family="table-column">
 104    <style:table-column-properties fo:break-before="auto" style:column-width="143.21pt"/>
 105   </style:style>
 106   <style:style style:name="co3" style:family="table-column">
 107    <style:table-column-properties fo:break-before="auto" style:column-width="190.46pt"/>
 108   </style:style>
 109   <style:style style:name="co4" style:family="table-column">
 110    <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
 111   </style:style>
 112   <style:style style:name="co5" style:family="table-column">
 113    <style:table-column-properties fo:break-before="auto" style:column-width="135.24pt"/>
 114   </style:style>
 115   <style:style style:name="co6" style:family="table-column">
 116    <style:table-column-properties fo:break-before="auto" style:column-width="129.74pt"/>
 117   </style:style>
 118   <style:style style:name="co7" style:family="table-column">
 119    <style:table-column-properties fo:break-before="auto" style:column-width="118.46pt"/>
 120   </style:style>
 121   <style:style style:name="co8" style:family="table-column">
 122    <style:table-column-properties fo:break-before="auto" style:column-width="64.26pt"/>
 123   </style:style>
 124   <style:style style:name="co9" style:family="table-column">
 125    <style:table-column-properties fo:break-before="auto" style:column-width="90.45pt"/>
 126   </style:style>
 127   <style:style style:name="co10" style:family="table-column">
 128    <style:table-column-properties fo:break-before="auto" style:column-width="51.7pt"/>
 129   </style:style>
 130   <style:style style:name="co11" style:family="table-column">
 131    <style:table-column-properties fo:break-before="auto" style:column-width="377.55pt"/>
 132   </style:style>
 133   <style:style style:name="ro1" style:family="table-row">
 134    <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 135   </style:style>
 136   <style:style style:name="ro2" style:family="table-row">
 137    <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 138   </style:style>
 139   <style:style style:name="ro3" style:family="table-row">
 140    <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 141   </style:style>
 142   <style:style style:name="ro4" style:family="table-row">
 143    <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 144   </style:style>
 145   <style:style style:name="ro5" style:family="table-row">
 146    <style:table-row-properties style:row-height="13.21pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 147   </style:style>
 148   <style:style style:name="ro6" style:family="table-row">
 149    <style:table-row-properties style:row-height="13.44pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 150   </style:style>
 151   <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
 152    <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
 153   </style:style>
 154   <number:number-style style:name="N1">
 155    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1"/>
 156   </number:number-style>
 157   <number:date-style style:name="N36" number:automatic-order="true">
 158    <number:day number:style="long"/>
 159    <number:text>.</number:text>
 160    <number:month number:style="long"/>
 161    <number:text>.</number:text>
 162    <number:year number:style="long"/>
 163   </number:date-style>
 164   <number:date-style style:name="N51" number:automatic-order="true">
 165    <number:day number:style="long"/>
 166    <number:text>.</number:text>
 167    <number:month number:style="long"/>
 168    <number:text>.</number:text>
 169    <number:year number:style="long"/>
 170    <number:text> </number:text>
 171    <number:hours number:style="long"/>
 172    <number:text>:</number:text>
 173    <number:minutes number:style="long"/>
 174    <number:text>:</number:text>
 175    <number:seconds number:style="long"/>
 176   </number:date-style>
 177   <number:boolean-style style:name="N99">
 178    <number:boolean/>
 179   </number:boolean-style>
 180   <number:number-style style:name="N10001" number:language="cs" number:country="CZ">
 181    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1"/>
 182   </number:number-style>
 183   <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
 184    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 185    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 186    <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"/>
 187   </style:style>
 188   <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
 189    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 190    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 191    <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"/>
 192   </style:style>
 193   <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
 194    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 195    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 196    <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"/>
 197   </style:style>
 198   <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
 199    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 200    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 201    <style:text-properties style:text-position=""/>
 202   </style:style>
 203   <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 204    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 205    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 206    <style:text-properties style:text-position=""/>
 207    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 208    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 209    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 210   </style:style>
 211   <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 212    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 213    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 214    <style:text-properties style:text-position=""/>
 215    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 216    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 217    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 218   </style:style>
 219   <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default">
 220    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 221    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 222    <style:text-properties style:text-position=""/>
 223    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 224    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 225    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 226   </style:style>
 227   <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
 228    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 229    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 230    <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"/>
 231   </style:style>
 232   <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
 233    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 234    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 235    <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"/>
 236   </style:style>
 237   <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
 238    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 239    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 240    <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"/>
 241   </style:style>
 242   <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default">
 243    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 244    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 245   </style:style>
 246   <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 247    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 248    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 249    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 250    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 251    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 252   </style:style>
 253   <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 254    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 255    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 256    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 257    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 258    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 259   </style:style>
 260   <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default">
 261    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 262    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 263    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 264    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 265    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 266   </style:style>
 267   <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default">
 268    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 269   </style:style>
 270   <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N51"/>
 271   <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"/>
 272   <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N113"/>
 273   <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N1">
 274    <style:table-cell-properties fo:background-color="#ffff00"/>
 275    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 276    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.F2"/>
 277    <style:map style:condition="cell-content()=0" style:apply-style-name="Bez_20_názvu1" style:base-cell-address="Sheet2.F2"/>
 278    <style:map style:condition="cell-content()=1" style:apply-style-name="Bez_20_názvu2" style:base-cell-address="Sheet2.F2"/>
 279   </style:style>
 280   <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N10001">
 281    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.F2"/>
 282    <style:map style:condition="cell-content()=0" style:apply-style-name="Bez_20_názvu1" style:base-cell-address="Sheet2.F2"/>
 283    <style:map style:condition="cell-content()=1" style:apply-style-name="Bez_20_názvu2" style:base-cell-address="Sheet2.F2"/>
 284   </style:style>
 285   <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default">
 286    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.F2"/>
 287    <style:map style:condition="cell-content()=0" style:apply-style-name="Bez_20_názvu1" style:base-cell-address="Sheet2.F2"/>
 288    <style:map style:condition="cell-content()=1" style:apply-style-name="Bez_20_názvu2" style:base-cell-address="Sheet2.F2"/>
 289   </style:style>
 290   <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default">
 291    <style:table-cell-properties fo:wrap-option="wrap"/>
 292   </style:style>
 293   <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
 294    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" style:vertical-align="middle"/>
 295    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 296   </style:style>
 297   <style:page-layout style:name="pm1">
 298    <style:page-layout-properties style:writing-mode="lr-tb"/>
 299    <style:header-style>
 300     <style:header-footer-properties fo:min-height="21.29pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
 301    </style:header-style>
 302    <style:footer-style>
 303     <style:header-footer-properties fo:min-height="21.29pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
 304    </style:footer-style>
 305   </style:page-layout>
 306   <style:page-layout style:name="pm2">
 307    <style:page-layout-properties style:writing-mode="lr-tb"/>
 308    <style:header-style>
 309     <style:header-footer-properties fo:min-height="21.29pt" 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">
 310      <style:background-image/>
 311     </style:header-footer-properties>
 312    </style:header-style>
 313    <style:footer-style>
 314     <style:header-footer-properties fo:min-height="21.29pt" 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">
 315      <style:background-image/>
 316     </style:header-footer-properties>
 317    </style:footer-style>
 318   </style:page-layout>
 319   <style:style style:name="T1" style:family="text">
 320    <style:text-properties fo:color="#0000ff"/>
 321   </style:style>
 322   <style:style style:name="T2" style:family="text">
 323    <style:text-properties fo:color="#ff0000"/>
 324   </style:style>
 325   <style:style style:name="T3" style:family="text">
 326    <style:text-properties style:text-position="super"/>
 327   </style:style>
 328  </office:automatic-styles>
 329  <office:master-styles>
 330   <style:master-page style:name="Default" style:page-layout-name="pm1">
 331    <style:header>
 332     <text:p><text:sheet-name>???</text:sheet-name></text:p>
 333    </style:header>
 334    <style:header-left style:display="false"/>
 335    <style:footer>
 336     <text:p>Page <text:page-number>1</text:page-number></text:p>
 337    </style:footer>
 338    <style:footer-left style:display="false"/>
 339   </style:master-page>
 340   <style:master-page style:name="Report" style:page-layout-name="pm2">
 341    <style:header>
 342     <style:region-left>
 343      <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
 344     </style:region-left>
 345     <style:region-right>
 346      <text:p><text:date style:data-style-name="N2" text:date-value="2016-05-11">00.00.0000</text:date>, <text:time style:data-style-name="N2" text:time-value="11:31:17.322000000">00:00:00</text:time></text:p>
 347     </style:region-right>
 348    </style:header>
 349    <style:header-left style:display="false"/>
 350    <style:footer>
 351     <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
 352    </style:footer>
 353    <style:footer-left style:display="false"/>
 354   </style:master-page>
 355  </office:master-styles>
 356  <office:body>
 357   <office:spreadsheet>
 358    <table:table table:name="Sheet1" table:style-name="ta1">
 359     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
 360     <table:table-column table:style-name="co2" table:default-cell-style-name="ce11"/>
 361     <table:table-column table:style-name="co3" table:default-cell-style-name="Default"/>
 362     <table:table-row table:style-name="ro1">
 363      <table:table-cell table:style-name="ce8" office:value-type="string" calcext:value-type="string">
 364       <text:p>YEARFRAC Function</text:p>
 365      </table:table-cell>
 366      <table:table-cell table:number-columns-repeated="2"/>
 367     </table:table-row>
 368     <table:table-row table:style-name="ro2">
 369      <table:table-cell table:number-columns-repeated="3"/>
 370     </table:table-row>
 371     <table:table-row table:style-name="ro3">
 372      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 373       <text:p>Result</text:p>
 374      </table:table-cell>
 375      <table:table-cell table:style-name="ce12" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 376       <text:p>PRAVDA</text:p>
 377      </table:table-cell>
 378      <table:table-cell/>
 379     </table:table-row>
 380     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 381      <table:table-cell table:number-columns-repeated="3"/>
 382     </table:table-row>
 383     <table:table-row table:style-name="ro4">
 384      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 385       <text:p>Sheet</text:p>
 386      </table:table-cell>
 387      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 388       <text:p>Result</text:p>
 389      </table:table-cell>
 390      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
 391       <text:p>Description</text:p>
 392      </table:table-cell>
 393     </table:table-row>
 394     <table:table-row table:style-name="ro5">
 395      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 396       <text:p>1</text:p>
 397      </table:table-cell>
 398      <table:table-cell table:style-name="ce13" table:formula="of:=AND([Sheet2.F2:.F100])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 399       <text:p>PRAVDA</text:p>
 400      </table:table-cell>
 401      <table:table-cell office:value-type="string" calcext:value-type="string">
 402       <text:p>Yearfrac formulas </text:p>
 403      </table:table-cell>
 404     </table:table-row>
 405     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
 406      <table:table-cell/>
 407      <table:table-cell table:style-name="ce14"/>
 408      <table:table-cell/>
 409     </table:table-row>
 410     <table:table-row table:style-name="ro2">
 411      <table:table-cell/>
 412      <table:table-cell table:style-name="ce14"/>
 413      <table:table-cell/>
 414     </table:table-row>
 415     <calcext:conditional-formats>
 416      <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B11">
 417       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
 418       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
 419       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
 420      </calcext:conditional-format>
 421      <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
 422       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
 423       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
 424       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
 425      </calcext:conditional-format>
 426     </calcext:conditional-formats>
 427    </table:table>
 428    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
 429     <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
 430     <table:table-column table:style-name="co6" table:default-cell-style-name="Default"/>
 431     <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
 432     <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
 433     <table:table-column table:style-name="co9" table:default-cell-style-name="Default"/>
 434     <table:table-column table:style-name="co10" table:default-cell-style-name="ce21"/>
 435     <table:table-column table:style-name="co11" table:default-cell-style-name="Default"/>
 436     <table:table-row table:style-name="ro2">
 437      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 438       <text:p>Date 1</text:p>
 439      </table:table-cell>
 440      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 441       <text:p>Date 2</text:p>
 442      </table:table-cell>
 443      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 444       <text:p>Function</text:p>
 445      </table:table-cell>
 446      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 447       <text:p>Formula</text:p>
 448      </table:table-cell>
 449      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 450       <text:p>Expected Value</text:p>
 451      </table:table-cell>
 452      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 453       <text:p>Correct?</text:p>
 454      </table:table-cell>
 455      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 456       <text:p>Test purpose</text:p>
 457      </table:table-cell>
 458     </table:table-row>
 459     <table:table-row table:style-name="ro2">
 460      <table:table-cell table:style-name="ce15" table:number-columns-repeated="5"/>
 461      <table:table-cell table:style-name="ce19" table:formula="of:=AND([.F3:.F24])" office:value-type="float" office:value="1" calcext:value-type="float">
 462       <text:p>1</text:p>
 463      </table:table-cell>
 464      <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
 465       <text:p>total of tests</text:p>
 466      </table:table-cell>
 467     </table:table-row>
 468     <table:table-row table:style-name="ro2">
 469      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2001-01-01T19:27:41" calcext:value-type="date">
 470       <text:p>01.01.2001 19:27:41</text:p>
 471      </table:table-cell>
 472      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T12:10:30" calcext:value-type="date">
 473       <text:p>01.01.2002 12:10:30</text:p>
 474      </table:table-cell>
 475      <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A3</text:span>;<text:span text:style-name="T2">B3</text:span>;0)</text:p>
 476      </table:table-cell>
 477      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A3];[.B3];0)" office:value-type="float" office:value="1" calcext:value-type="float">
 478       <text:p>1,000000</text:p>
 479      </table:table-cell>
 480      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float">
 481       <text:p>1,000000</text:p>
 482      </table:table-cell>
 483      <table:table-cell table:style-name="ce20" table:formula="of:=[.D3]=[.E3]" office:value-type="float" office:value="1" calcext:value-type="float">
 484       <text:p>1</text:p>
 485      </table:table-cell>
 486      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 487       <text:p>YEARFRAC ignores the time portion of the date, truncating it</text:p>
 488      </table:table-cell>
 489     </table:table-row>
 490     <table:table-row table:style-name="ro2">
 491      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2002-01-01" calcext:value-type="date">
 492       <text:p>01.01.2002</text:p>
 493      </table:table-cell>
 494      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2001-01-01" calcext:value-type="date">
 495       <text:p>01.01.2001</text:p>
 496      </table:table-cell>
 497      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A4</text:span>;<text:span text:style-name="T2">B4</text:span>;0)</text:p>
 498      </table:table-cell>
 499      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A4];[.B4];0)" office:value-type="float" office:value="1" calcext:value-type="float">
 500       <text:p>1,000000</text:p>
 501      </table:table-cell>
 502      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float">
 503       <text:p>1,000000</text:p>
 504      </table:table-cell>
 505      <table:table-cell table:style-name="ce20" table:formula="of:=[.D4]=[.E4]" office:value-type="float" office:value="1" calcext:value-type="float">
 506       <text:p>1</text:p>
 507      </table:table-cell>
 508      <table:table-cell office:value-type="string" calcext:value-type="string">
 509       <text:p>The order of the dates does not matter. <text:s/>Date 1 can be before or after Date 2</text:p>
 510      </table:table-cell>
 511     </table:table-row>
 512     <table:table-row table:style-name="ro2">
 513      <table:table-cell table:number-columns-repeated="2" table:style-name="ce17" office:value-type="date" office:date-value="2000-01-01" calcext:value-type="date">
 514       <text:p>01.01.2000</text:p>
 515      </table:table-cell>
 516      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A5</text:span>;<text:span text:style-name="T2">B5</text:span>;0)</text:p>
 517      </table:table-cell>
 518      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A5];[.B5];0)" office:value-type="float" office:value="0" calcext:value-type="float">
 519       <text:p>0,000000</text:p>
 520      </table:table-cell>
 521      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0" calcext:value-type="float">
 522       <text:p>0,000000</text:p>
 523      </table:table-cell>
 524      <table:table-cell table:style-name="ce20" table:formula="of:=[.D5]=[.E5]" office:value-type="float" office:value="1" calcext:value-type="float">
 525       <text:p>1</text:p>
 526      </table:table-cell>
 527      <table:table-cell office:value-type="string" calcext:value-type="string">
 528       <text:p>If the dates are equal, the result is 0</text:p>
 529      </table:table-cell>
 530     </table:table-row>
 531     <table:table-row table:style-name="ro2">
 532      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T19:27:41" calcext:value-type="date">
 533       <text:p>01.01.2002 19:27:41</text:p>
 534      </table:table-cell>
 535      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T12:10:30" calcext:value-type="date">
 536       <text:p>01.01.2002 12:10:30</text:p>
 537      </table:table-cell>
 538      <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A6</text:span>;<text:span text:style-name="T2">B6</text:span>;0)</text:p>
 539      </table:table-cell>
 540      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A6];[.B6];0)" office:value-type="float" office:value="0" calcext:value-type="float">
 541       <text:p>0,000000</text:p>
 542      </table:table-cell>
 543      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0" calcext:value-type="float">
 544       <text:p>0,000000</text:p>
 545      </table:table-cell>
 546      <table:table-cell table:style-name="ce20" table:formula="of:=[.D6]=[.E6]" office:value-type="float" office:value="1" calcext:value-type="float">
 547       <text:p>1</text:p>
 548      </table:table-cell>
 549      <table:table-cell office:value-type="string" calcext:value-type="string">
 550       <text:p>Again, ignore the time portion. <text:s/>If the dates are equal, the result is 0</text:p>
 551      </table:table-cell>
 552     </table:table-row>
 553     <table:table-row table:style-name="ro2">
 554      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-01-31" calcext:value-type="date">
 555       <text:p>31.01.2010</text:p>
 556      </table:table-cell>
 557      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-07-31" calcext:value-type="date">
 558       <text:p>31.07.2010</text:p>
 559      </table:table-cell>
 560      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A7</text:span>;<text:span text:style-name="T2">B7</text:span>;0)</text:p>
 561      </table:table-cell>
 562      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A7];[.B7];0)" office:value-type="float" office:value="0.5" calcext:value-type="float">
 563       <text:p>0,500000</text:p>
 564      </table:table-cell>
 565      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.5" calcext:value-type="float">
 566       <text:p>0,500000</text:p>
 567      </table:table-cell>
 568      <table:table-cell table:style-name="ce20" table:formula="of:=[.D7]=[.E7]" office:value-type="float" office:value="1" calcext:value-type="float">
 569       <text:p>1</text:p>
 570      </table:table-cell>
 571      <table:table-cell office:value-type="string" calcext:value-type="string">
 572       <text:p>both days-of-month are 31 → 180/360</text:p>
 573      </table:table-cell>
 574     </table:table-row>
 575     <table:table-row table:style-name="ro2">
 576      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-01-31" calcext:value-type="date">
 577       <text:p>31.01.2010</text:p>
 578      </table:table-cell>
 579      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-08-01" calcext:value-type="date">
 580       <text:p>01.08.2010</text:p>
 581      </table:table-cell>
 582      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A8</text:span>;<text:span text:style-name="T2">B8</text:span>;0)</text:p>
 583      </table:table-cell>
 584      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A8];[.B8];0)" office:value-type="float" office:value="0.502777777777778" calcext:value-type="float">
 585       <text:p>0,502778</text:p>
 586      </table:table-cell>
 587      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.502777777777778" calcext:value-type="float">
 588       <text:p>0,502778</text:p>
 589      </table:table-cell>
 590      <table:table-cell table:style-name="ce20" table:formula="of:=[.D8]=[.E8]" office:value-type="float" office:value="1" calcext:value-type="float">
 591       <text:p>1</text:p>
 592      </table:table-cell>
 593      <table:table-cell office:value-type="string" calcext:value-type="string">
 594       <text:p>date1&apos;s day-of-month is 31, but date2 is not → 181/360</text:p>
 595      </table:table-cell>
 596     </table:table-row>
 597     <table:table-row table:style-name="ro2">
 598      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-01-30" calcext:value-type="date">
 599       <text:p>30.01.2010</text:p>
 600      </table:table-cell>
 601      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-07-31" calcext:value-type="date">
 602       <text:p>31.07.2010</text:p>
 603      </table:table-cell>
 604      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A9</text:span>;<text:span text:style-name="T2">B9</text:span>;0)</text:p>
 605      </table:table-cell>
 606      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A9];[.B9];0)" office:value-type="float" office:value="0.5" calcext:value-type="float">
 607       <text:p>0,500000</text:p>
 608      </table:table-cell>
 609      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.5" calcext:value-type="float">
 610       <text:p>0,500000</text:p>
 611      </table:table-cell>
 612      <table:table-cell table:style-name="ce20" table:formula="of:=[.D9]=[.E9]" office:value-type="float" office:value="1" calcext:value-type="float">
 613       <text:p>1</text:p>
 614      </table:table-cell>
 615      <table:table-cell office:value-type="string" calcext:value-type="string">
 616       <text:p>date1&apos;s day-of-month is 30 and date2&apos;s is 31 → 180/360</text:p>
 617      </table:table-cell>
 618     </table:table-row>
 619     <table:table-row table:style-name="ro2">
 620      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-02-28" calcext:value-type="date">
 621       <text:p>28.02.2010</text:p>
 622      </table:table-cell>
 623      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2011-02-28" calcext:value-type="date">
 624       <text:p>28.02.2011</text:p>
 625      </table:table-cell>
 626      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A10</text:span>;<text:span text:style-name="T2">B10</text:span>;0)</text:p>
 627      </table:table-cell>
 628      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A10];[.B10];0)" office:value-type="float" office:value="1" calcext:value-type="float">
 629       <text:p>1,000000</text:p>
 630      </table:table-cell>
 631      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float">
 632       <text:p>1,000000</text:p>
 633      </table:table-cell>
 634      <table:table-cell table:style-name="ce20" table:formula="of:=[.D10]=[.E10]" office:value-type="float" office:value="1" calcext:value-type="float">
 635       <text:p>1</text:p>
 636      </table:table-cell>
 637      <table:table-cell office:value-type="string" calcext:value-type="string">
 638       <text:p>both days are last day of February (non leap year) → 360/360</text:p>
 639      </table:table-cell>
 640     </table:table-row>
 641     <table:table-row table:style-name="ro5">
 642      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2000-02-29" calcext:value-type="date">
 643       <text:p>29.02.2000</text:p>
 644      </table:table-cell>
 645      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-02-29" calcext:value-type="date">
 646       <text:p>29.02.2008</text:p>
 647      </table:table-cell>
 648      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A11</text:span>;<text:span text:style-name="T2">B11</text:span>;0)</text:p>
 649      </table:table-cell>
 650      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A11];[.B11];0)" office:value-type="float" office:value="8" calcext:value-type="float">
 651       <text:p>8,000000</text:p>
 652      </table:table-cell>
 653      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="8" calcext:value-type="float">
 654       <text:p>8,000000</text:p>
 655      </table:table-cell>
 656      <table:table-cell table:style-name="ce20" table:formula="of:=[.D11]=[.E11]" office:value-type="float" office:value="1" calcext:value-type="float">
 657       <text:p>1</text:p>
 658      </table:table-cell>
 659      <table:table-cell office:value-type="string" calcext:value-type="string">
 660       <text:p>both days are last day of February (leap year) → 8 full years</text:p>
 661      </table:table-cell>
 662     </table:table-row>
 663     <table:table-row table:style-name="ro2">
 664      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-02-28" calcext:value-type="date">
 665       <text:p>28.02.2010</text:p>
 666      </table:table-cell>
 667      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2010-08-30" calcext:value-type="date">
 668       <text:p>30.08.2010</text:p>
 669      </table:table-cell>
 670      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A12</text:span>;<text:span text:style-name="T2">B12</text:span>;0)</text:p>
 671      </table:table-cell>
 672      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A12];[.B12];0)" office:value-type="float" office:value="0.5" calcext:value-type="float">
 673       <text:p>0,500000</text:p>
 674      </table:table-cell>
 675      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.5" calcext:value-type="float">
 676       <text:p>0,500000</text:p>
 677      </table:table-cell>
 678      <table:table-cell table:style-name="ce20" table:formula="of:=[.D12]=[.E12]" office:value-type="float" office:value="1" calcext:value-type="float">
 679       <text:p>1</text:p>
 680      </table:table-cell>
 681      <table:table-cell office:value-type="string" calcext:value-type="string">
 682       <text:p>date1 is last date of February (non leap year) → 180/360</text:p>
 683      </table:table-cell>
 684     </table:table-row>
 685     <table:table-row table:style-name="ro2">
 686      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-02-29" calcext:value-type="date">
 687       <text:p>29.02.2008</text:p>
 688      </table:table-cell>
 689      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-08-30" calcext:value-type="date">
 690       <text:p>30.08.2008</text:p>
 691      </table:table-cell>
 692      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A13</text:span>;<text:span text:style-name="T2">B13</text:span>;0)</text:p>
 693      </table:table-cell>
 694      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A13];[.B13];0)" office:value-type="float" office:value="0.5" calcext:value-type="float">
 695       <text:p>0,500000</text:p>
 696      </table:table-cell>
 697      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.5" calcext:value-type="float">
 698       <text:p>0,500000</text:p>
 699      </table:table-cell>
 700      <table:table-cell table:style-name="ce20" table:formula="of:=[.D13]=[.E13]" office:value-type="float" office:value="1" calcext:value-type="float">
 701       <text:p>1</text:p>
 702      </table:table-cell>
 703      <table:table-cell office:value-type="string" calcext:value-type="string">
 704       <text:p>date1 is last date of February (leap year) → 180/360</text:p>
 705      </table:table-cell>
 706     </table:table-row>
 707     <table:table-row table:style-name="ro2">
 708      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2001-01-01T19:27:41" calcext:value-type="date">
 709       <text:p>01.01.2001 19:27:41</text:p>
 710      </table:table-cell>
 711      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T12:10:30" calcext:value-type="date">
 712       <text:p>01.01.2002 12:10:30</text:p>
 713      </table:table-cell>
 714      <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A14</text:span>;<text:span text:style-name="T2">B14</text:span>;1)</text:p>
 715      </table:table-cell>
 716      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A14];[.B14];1)" office:value-type="float" office:value="1" calcext:value-type="float">
 717       <text:p>1,000000</text:p>
 718      </table:table-cell>
 719      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float">
 720       <text:p>1,000000</text:p>
 721      </table:table-cell>
 722      <table:table-cell table:style-name="ce20" table:formula="of:=[.D14]=[.E14]" office:value-type="float" office:value="1" calcext:value-type="float">
 723       <text:p>1</text:p>
 724      </table:table-cell>
 725      <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string">
 726       <text:p>YEARFRAC ignores the time portion of the date, truncating it</text:p>
 727      </table:table-cell>
 728     </table:table-row>
 729     <table:table-row table:style-name="ro2">
 730      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2002-01-01" calcext:value-type="date">
 731       <text:p>01.01.2002</text:p>
 732      </table:table-cell>
 733      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2001-01-01" calcext:value-type="date">
 734       <text:p>01.01.2001</text:p>
 735      </table:table-cell>
 736      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A15</text:span>;<text:span text:style-name="T2">B15</text:span>;1)</text:p>
 737      </table:table-cell>
 738      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A15];[.B15];1)" office:value-type="float" office:value="1" calcext:value-type="float">
 739       <text:p>1,000000</text:p>
 740      </table:table-cell>
 741      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float">
 742       <text:p>1,000000</text:p>
 743      </table:table-cell>
 744      <table:table-cell table:style-name="ce20" table:formula="of:=[.D15]=[.E15]" office:value-type="float" office:value="1" calcext:value-type="float">
 745       <text:p>1</text:p>
 746      </table:table-cell>
 747      <table:table-cell office:value-type="string" calcext:value-type="string">
 748       <text:p>The order of the dates does not matter. <text:s/>Date 1 can be before or after Date 2</text:p>
 749      </table:table-cell>
 750     </table:table-row>
 751     <table:table-row table:style-name="ro2">
 752      <table:table-cell table:number-columns-repeated="2" table:style-name="ce17" office:value-type="date" office:date-value="2000-01-01" calcext:value-type="date">
 753       <text:p>01.01.2000</text:p>
 754      </table:table-cell>
 755      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A16</text:span>;<text:span text:style-name="T2">B16</text:span>;1)</text:p>
 756      </table:table-cell>
 757      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A16];[.B16];1)" office:value-type="float" office:value="0" calcext:value-type="float">
 758       <text:p>0,000000</text:p>
 759      </table:table-cell>
 760      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0" calcext:value-type="float">
 761       <text:p>0,000000</text:p>
 762      </table:table-cell>
 763      <table:table-cell table:style-name="ce20" table:formula="of:=[.D16]=[.E16]" office:value-type="float" office:value="1" calcext:value-type="float">
 764       <text:p>1</text:p>
 765      </table:table-cell>
 766      <table:table-cell office:value-type="string" calcext:value-type="string">
 767       <text:p>If the dates are equal, the result is 0</text:p>
 768      </table:table-cell>
 769     </table:table-row>
 770     <table:table-row table:style-name="ro2">
 771      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T19:27:41" calcext:value-type="date">
 772       <text:p>01.01.2002 19:27:41</text:p>
 773      </table:table-cell>
 774      <table:table-cell table:style-name="ce16" office:value-type="date" office:date-value="2002-01-01T12:10:30" calcext:value-type="date">
 775       <text:p>01.01.2002 12:10:30</text:p>
 776      </table:table-cell>
 777      <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A17</text:span>;<text:span text:style-name="T2">B17</text:span>;1)</text:p>
 778      </table:table-cell>
 779      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A17];[.B17];1)" office:value-type="float" office:value="0" calcext:value-type="float">
 780       <text:p>0,000000</text:p>
 781      </table:table-cell>
 782      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0" calcext:value-type="float">
 783       <text:p>0,000000</text:p>
 784      </table:table-cell>
 785      <table:table-cell table:style-name="ce20" table:formula="of:=[.D17]=[.E17]" office:value-type="float" office:value="1" calcext:value-type="float">
 786       <text:p>1</text:p>
 787      </table:table-cell>
 788      <table:table-cell office:value-type="string" calcext:value-type="string">
 789       <text:p>Again, ignore the time portion. <text:s/>If the dates are equal, the result is 0</text:p>
 790      </table:table-cell>
 791     </table:table-row>
 792     <table:table-row table:style-name="ro2">
 793      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2002-01-31" calcext:value-type="date">
 794       <text:p>31.01.2002</text:p>
 795      </table:table-cell>
 796      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2003-05-01" calcext:value-type="date">
 797       <text:p>01.05.2003</text:p>
 798      </table:table-cell>
 799      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A18</text:span>;<text:span text:style-name="T2">B18</text:span>;1)</text:p>
 800      </table:table-cell>
 801      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A18];[.B18];1)" office:value-type="float" office:value="1.24657534246575" calcext:value-type="float">
 802       <text:p>1,246575</text:p>
 803      </table:table-cell>
 804      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1.24657534246575" calcext:value-type="float">
 805       <text:p>1,246575</text:p>
 806      </table:table-cell>
 807      <table:table-cell table:style-name="ce20" table:formula="of:=[.D18]=[.E18]" office:value-type="float" office:value="1" calcext:value-type="float">
 808       <text:p>1</text:p>
 809      </table:table-cell>
 810      <table:table-cell office:value-type="string" calcext:value-type="string">
 811       <text:p>More than a year apart, no leap years → (365+90)/365</text:p>
 812      </table:table-cell>
 813     </table:table-row>
 814     <table:table-row table:style-name="ro2">
 815      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-01-31" calcext:value-type="date">
 816       <text:p>31.01.2008</text:p>
 817      </table:table-cell>
 818      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2009-05-01" calcext:value-type="date">
 819       <text:p>01.05.2009</text:p>
 820      </table:table-cell>
 821      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A19</text:span>;<text:span text:style-name="T2">B19</text:span>;1)</text:p>
 822      </table:table-cell>
 823      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A19];[.B19];1)" office:value-type="float" office:value="1.24760601915185" calcext:value-type="float">
 824       <text:p>1,247606</text:p>
 825      </table:table-cell>
 826      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1.24760601915185" calcext:value-type="float">
 827       <text:p>1,247606</text:p>
 828      </table:table-cell>
 829      <table:table-cell table:style-name="ce20" table:formula="of:=[.D19]=[.E19]" office:value-type="float" office:value="1" calcext:value-type="float">
 830       <text:p>1</text:p>
 831      </table:table-cell>
 832      <table:table-cell office:value-type="string" calcext:value-type="string">
 833       <text:p>More than a year apart, with leap year → (366 + 90)( (366+365)/2)</text:p>
 834      </table:table-cell>
 835     </table:table-row>
 836     <table:table-row table:style-name="ro2">
 837      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2007-01-31" calcext:value-type="date">
 838       <text:p>31.01.2007</text:p>
 839      </table:table-cell>
 840      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2009-05-01" calcext:value-type="date">
 841       <text:p>01.05.2009</text:p>
 842      </table:table-cell>
 843      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A20</text:span>;<text:span text:style-name="T2">B20</text:span>;1)</text:p>
 844      </table:table-cell>
 845      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A20];[.B20];1)" office:value-type="float" office:value="2.24726277372263" calcext:value-type="float">
 846       <text:p>2,247263</text:p>
 847      </table:table-cell>
 848      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="2.24726277372263" calcext:value-type="float">
 849       <text:p>2,247263</text:p>
 850      </table:table-cell>
 851      <table:table-cell table:style-name="ce20" table:formula="of:=[.D20]=[.E20]" office:value-type="float" office:value="1" calcext:value-type="float">
 852       <text:p>1</text:p>
 853      </table:table-cell>
 854      <table:table-cell office:value-type="string" calcext:value-type="string">
 855       <text:p>Several years apart, with leap year → (365 + 366 + 90)( (365 + 366 + 365)/3)</text:p>
 856      </table:table-cell>
 857     </table:table-row>
 858     <table:table-row table:style-name="ro2">
 859      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2007-01-31" calcext:value-type="date">
 860       <text:p>31.01.2007</text:p>
 861      </table:table-cell>
 862      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2007-05-01" calcext:value-type="date">
 863       <text:p>01.05.2007</text:p>
 864      </table:table-cell>
 865      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A21</text:span>;<text:span text:style-name="T2">B21</text:span>;1)</text:p>
 866      </table:table-cell>
 867      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A21];[.B21];1)" office:value-type="float" office:value="0.246575342465753" calcext:value-type="float">
 868       <text:p>0,246575</text:p>
 869      </table:table-cell>
 870      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.246575342465753" calcext:value-type="float">
 871       <text:p>0,246575</text:p>
 872      </table:table-cell>
 873      <table:table-cell table:style-name="ce20" table:formula="of:=[.D21]=[.E21]" office:value-type="float" office:value="1" calcext:value-type="float">
 874       <text:p>1</text:p>
 875      </table:table-cell>
 876      <table:table-cell office:value-type="string" calcext:value-type="string">
 877       <text:p>In same year (not leap year) → 90/365</text:p>
 878      </table:table-cell>
 879     </table:table-row>
 880     <table:table-row table:style-name="ro2">
 881      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-01-31" calcext:value-type="date">
 882       <text:p>31.01.2008</text:p>
 883      </table:table-cell>
 884      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-05-01" calcext:value-type="date">
 885       <text:p>01.05.2008</text:p>
 886      </table:table-cell>
 887      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A22</text:span>;<text:span text:style-name="T2">B22</text:span>;1)</text:p>
 888      </table:table-cell>
 889      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A22];[.B22];1)" office:value-type="float" office:value="0.248633879781421" calcext:value-type="float">
 890       <text:p>0,248634</text:p>
 891      </table:table-cell>
 892      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.248633879781421" calcext:value-type="float">
 893       <text:p>0,248634</text:p>
 894      </table:table-cell>
 895      <table:table-cell table:style-name="ce20" table:formula="of:=[.D22]=[.E22]" office:value-type="float" office:value="1" calcext:value-type="float">
 896       <text:p>1</text:p>
 897      </table:table-cell>
 898      <table:table-cell office:value-type="string" calcext:value-type="string">
 899       <text:p>in same year (leap year) → 91/366</text:p>
 900      </table:table-cell>
 901     </table:table-row>
 902     <table:table-row table:style-name="ro2">
 903      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2007-12-15" calcext:value-type="date">
 904       <text:p>15.12.2007</text:p>
 905      </table:table-cell>
 906      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-03-14" calcext:value-type="date">
 907       <text:p>14.03.2008</text:p>
 908      </table:table-cell>
 909      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A23</text:span>;<text:span text:style-name="T2">B23</text:span>;1)</text:p>
 910      </table:table-cell>
 911      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A23];[.B23];1)" office:value-type="float" office:value="0.245901639344262" calcext:value-type="float">
 912       <text:p>0,245902</text:p>
 913      </table:table-cell>
 914      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.245901639344262" calcext:value-type="float">
 915       <text:p>0,245902</text:p>
 916      </table:table-cell>
 917      <table:table-cell table:style-name="ce20" table:formula="of:=[.D23]=[.E23]" office:value-type="float" office:value="1" calcext:value-type="float">
 918       <text:p>1</text:p>
 919      </table:table-cell>
 920      <table:table-cell office:value-type="string" calcext:value-type="string">
 921       <text:p>Less than a year, but February 29 is in range</text:p>
 922      </table:table-cell>
 923     </table:table-row>
 924     <table:table-row table:style-name="ro6">
 925      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2007-12-01" calcext:value-type="date">
 926       <text:p>01.12.2007</text:p>
 927      </table:table-cell>
 928      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2008-02-29" calcext:value-type="date">
 929       <text:p>29.02.2008</text:p>
 930      </table:table-cell>
 931      <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A24</text:span>;<text:span text:style-name="T2">B24</text:span>;1)</text:p>
 932      </table:table-cell>
 933      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A24];[.B24];1)" office:value-type="float" office:value="0.245901639344262" calcext:value-type="float">
 934       <text:p>0,245902</text:p>
 935      </table:table-cell>
 936      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.245901639344262" calcext:value-type="float">
 937       <text:p>0,245902</text:p>
 938      </table:table-cell>
 939      <table:table-cell table:style-name="ce20" table:formula="of:=[.D24]=[.E24]" office:value-type="float" office:value="1" calcext:value-type="float">
 940       <text:p>1</text:p>
 941      </table:table-cell>
 942      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>Less than a year, but date 2 is February 29<text:span text:style-name="T3">th</text:span></text:p>
 943      </table:table-cell>
 944     </table:table-row>
 945     <table:table-row table:style-name="ro2">
 946      <table:table-cell table:number-columns-repeated="2"/>
 947      <table:table-cell office:value-type="string" calcext:value-type="string">
 948       <text:p>YEARFRAC(A13;B13;3)</text:p>
 949      </table:table-cell>
 950      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A11];[.B11];3)" office:value-type="float" office:value="8.0054794520548" calcext:value-type="float">
 951       <text:p>8,005479</text:p>
 952      </table:table-cell>
 953      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="8.0054794520548" calcext:value-type="float">
 954       <text:p>8,005479</text:p>
 955      </table:table-cell>
 956      <table:table-cell table:style-name="ce20" table:formula="of:=[.D25]=[.E25]" office:value-type="float" office:value="1" calcext:value-type="float">
 957       <text:p>1</text:p>
 958      </table:table-cell>
 959      <table:table-cell office:value-type="string" calcext:value-type="string">
 960       <text:p>Base 3</text:p>
 961      </table:table-cell>
 962     </table:table-row>
 963     <table:table-row table:style-name="ro2">
 964      <table:table-cell table:style-name="ce15"/>
 965      <table:table-cell/>
 966      <table:table-cell office:value-type="string" calcext:value-type="string">
 967       <text:p>YEARFRAC(A24;B24;4)</text:p>
 968      </table:table-cell>
 969      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A22];[.B22];4)" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
 970       <text:p>0,252778</text:p>
 971      </table:table-cell>
 972      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
 973       <text:p>0,252778</text:p>
 974      </table:table-cell>
 975      <table:table-cell table:style-name="ce20" table:formula="of:=[.D26]=[.E26]" office:value-type="float" office:value="1" calcext:value-type="float">
 976       <text:p>1</text:p>
 977      </table:table-cell>
 978      <table:table-cell office:value-type="string" calcext:value-type="string">
 979       <text:p>Base 4</text:p>
 980      </table:table-cell>
 981     </table:table-row>
 982     <table:table-row table:style-name="ro5">
 983      <table:table-cell table:number-columns-repeated="2"/>
 984      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(&quot;2008-01-31&quot;;<text:span text:style-name="T1">B24</text:span>;0)</text:p>
 985      </table:table-cell>
 986      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC(&quot;2008-01-31&quot;;[.B22];0)" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
 987       <text:p>0,252778</text:p>
 988      </table:table-cell>
 989      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
 990       <text:p>0,252778</text:p>
 991      </table:table-cell>
 992      <table:table-cell table:style-name="ce20" table:formula="of:=[.D27]=[.E27]" office:value-type="float" office:value="1" calcext:value-type="float">
 993       <text:p>1</text:p>
 994      </table:table-cell>
 995      <table:table-cell office:value-type="string" calcext:value-type="string">
 996       <text:p>date in “ “</text:p>
 997      </table:table-cell>
 998     </table:table-row>
 999     <table:table-row table:style-name="ro5">
1000      <table:table-cell table:number-columns-repeated="2"/>
1001      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(DATE(2008;1;31);<text:span text:style-name="T1">B24</text:span>;0)</text:p>
1002      </table:table-cell>
1003      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC(DATE(2008;1;31);[.B22];0)" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
1004       <text:p>0,252778</text:p>
1005      </table:table-cell>
1006      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="0.252777777777778" calcext:value-type="float">
1007       <text:p>0,252778</text:p>
1008      </table:table-cell>
1009      <table:table-cell table:style-name="ce20" table:formula="of:=[.D28]=[.E28]" office:value-type="float" office:value="1" calcext:value-type="float">
1010       <text:p>1</text:p>
1011      </table:table-cell>
1012      <table:table-cell office:value-type="string" calcext:value-type="string">
1013       <text:p>date as function DATE</text:p>
1014      </table:table-cell>
1015     </table:table-row>
1016     <table:table-row table:style-name="ro2">
1017      <table:table-cell table:number-columns-repeated="2"/>
1018      <table:table-cell office:value-type="string" calcext:value-type="string">
1019       <text:p>YEARFRAC(DATE(1958;3;1);DATE(1996;1;1);1)</text:p>
1020      </table:table-cell>
1021      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC(DATE(1958;3;1);DATE(1996;1;1);1)" office:value-type="float" office:value="37.8364338364338" calcext:value-type="float">
1022       <text:p>37,836434</text:p>
1023      </table:table-cell>
1024      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="37.8364338364338" calcext:value-type="float">
1025       <text:p>37,836434</text:p>
1026      </table:table-cell>
1027      <table:table-cell table:style-name="ce20" table:formula="of:=[.D29]=[.E29]" office:value-type="float" office:value="1" calcext:value-type="float">
1028       <text:p>1</text:p>
1029      </table:table-cell>
1030      <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="2">
1031       <text:p>Bug 40100</text:p>
1032      </table:table-cell>
1033     </table:table-row>
1034     <table:table-row table:style-name="ro2">
1035      <table:table-cell table:number-columns-repeated="2"/>
1036      <table:table-cell office:value-type="string" calcext:value-type="string">
1037       <text:p>YEARFRAC(DATE(1958;3;1);DATE(1995;12;31);1)</text:p>
1038      </table:table-cell>
1039      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC(DATE(1958;3;1);DATE(1995;12;31);1)" office:value-type="float" office:value="37.8357230348008" calcext:value-type="float">
1040       <text:p>37,835723</text:p>
1041      </table:table-cell>
1042      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="37.8357230348008" calcext:value-type="float">
1043       <text:p>37,835723</text:p>
1044      </table:table-cell>
1045      <table:table-cell table:style-name="ce20" table:formula="of:=[.D30]=[.E30]" office:value-type="float" office:value="1" calcext:value-type="float">
1046       <text:p>1</text:p>
1047      </table:table-cell>
1048      <table:covered-table-cell/>
1049     </table:table-row>
1050     <table:table-row table:style-name="ro5">
1051      <table:table-cell/>
1052      <table:table-cell table:style-name="ce17" table:formula="of:=DATE(2008;2;29)" office:value-type="date" office:date-value="2008-02-29" calcext:value-type="date">
1053       <text:p>29.02.2008</text:p>
1054      </table:table-cell>
1055      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A33</text:span>;<text:span text:style-name="T2">B26</text:span>;1)</text:p>
1056      </table:table-cell>
1057      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A31];[.B24];1)" office:value-type="float" office:value="108.165617144137" calcext:value-type="float">
1058       <text:p>108,165617</text:p>
1059      </table:table-cell>
1060      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="108.165617144137" calcext:value-type="float">
1061       <text:p>108,165617</text:p>
1062      </table:table-cell>
1063      <table:table-cell table:style-name="ce20" table:formula="of:=[.D31]=[.E31]" office:value-type="float" office:value="1" calcext:value-type="float">
1064       <text:p>1</text:p>
1065      </table:table-cell>
1066      <table:table-cell office:value-type="string" calcext:value-type="string">
1067       <text:p>AOO bug 122543</text:p>
1068      </table:table-cell>
1069     </table:table-row>
1070     <table:table-row table:style-name="ro5">
1071      <table:table-cell table:number-columns-repeated="2"/>
1072      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A33</text:span>;yearFracDate;1)</text:p>
1073      </table:table-cell>
1074      <table:table-cell table:style-name="ce18" table:formula="of:=YEARFRAC([.A31];yearFracDate;1)" office:value-type="float" office:value="108.165617144137" calcext:value-type="float">
1075       <text:p>108,165617</text:p>
1076      </table:table-cell>
1077      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="108.165617144137" calcext:value-type="float">
1078       <text:p>108,165617</text:p>
1079      </table:table-cell>
1080      <table:table-cell table:style-name="ce20" table:formula="of:=[.D32]=[.E32]" office:value-type="float" office:value="1" calcext:value-type="float">
1081       <text:p>1</text:p>
1082      </table:table-cell>
1083      <table:table-cell office:value-type="string" calcext:value-type="string">
1084       <text:p>yearFracDate name</text:p>
1085      </table:table-cell>
1086     </table:table-row>
1087     <table:table-row table:style-name="ro6">
1088      <table:table-cell table:number-columns-repeated="2"/>
1089      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>YEARFRAC(<text:span text:style-name="T1">A5</text:span>;<text:span text:style-name="T2">B5</text:span>)</text:p>
1090      </table:table-cell>
1091      <table:table-cell table:formula="of:=YEARFRAC([.A3];[.B3])" office:value-type="float" office:value="1" calcext:value-type="float">
1092       <text:p>1</text:p>
1093      </table:table-cell>
1094      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
1095       <text:p>1</text:p>
1096      </table:table-cell>
1097      <table:table-cell table:style-name="ce20" table:formula="of:=[.D33]=[.E33]" office:value-type="float" office:value="1" calcext:value-type="float">
1098       <text:p>1</text:p>
1099      </table:table-cell>
1100      <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>without 3<text:span text:style-name="T3">rd</text:span> argument</text:p>
1101      </table:table-cell>
1102     </table:table-row>
1103     <table:table-row table:style-name="ro2">
1104      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2003-02-28" calcext:value-type="date">
1105       <text:p>28-02-2003</text:p>
1106      </table:table-cell>
1107      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2004-02-29" calcext:value-type="date">
1108       <text:p>29-02-2004</text:p>
1109      </table:table-cell>
1110      <table:table-cell office:value-type="string" calcext:value-type="string">
1111       <text:p>=(B34-A34)/YEARFRAC(A34;B34;1)</text:p>
1112      </table:table-cell>
1113      <table:table-cell table:style-name="ce18" table:formula="of:=([.B34]-[.A34])/YEARFRAC([.A34];[.B34];1)" office:value-type="float" office:value="365.5" calcext:value-type="float">
1114       <text:p>365,500000</text:p>
1115      </table:table-cell>
1116      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="365.500000" calcext:value-type="float">
1117       <text:p>365,500000</text:p>
1118      </table:table-cell>
1119      <table:table-cell table:style-name="ce20" table:formula="of:=[.D34]=[.E34]" office:value-type="float" office:value="1" calcext:value-type="float">
1120       <text:p>1</text:p>
1121      </table:table-cell>
1122      <table:table-cell office:value-type="string" calcext:value-type="string">
1123       <text:p>tdf69569, days in year</text:p>
1124      </table:table-cell>
1125     </table:table-row>
1126     <table:table-row table:style-name="ro2">
1127      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2003-02-28" calcext:value-type="date">
1128       <text:p>28-02-2003</text:p>
1129      </table:table-cell>
1130      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2004-02-28" calcext:value-type="date">
1131       <text:p>28-02-2004</text:p>
1132      </table:table-cell>
1133      <table:table-cell office:value-type="string" calcext:value-type="string">
1134       <text:p>=(B35-A35)/YEARFRAC(A35;B35;1)</text:p>
1135      </table:table-cell>
1136      <table:table-cell table:style-name="ce18" table:formula="of:=([.B35]-[.A35])/YEARFRAC([.A35];[.B35];1)" office:value-type="float" office:value="365" calcext:value-type="float">
1137       <text:p>365,000000</text:p>
1138      </table:table-cell>
1139      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="365.000000" calcext:value-type="float">
1140       <text:p>365,000000</text:p>
1141      </table:table-cell>
1142      <table:table-cell table:style-name="ce20" table:formula="of:=[.D35]=[.E35]" office:value-type="float" office:value="1" calcext:value-type="float">
1143       <text:p>1</text:p>
1144      </table:table-cell>
1145      <table:table-cell office:value-type="string" calcext:value-type="string">
1146       <text:p>tdf69569, days in year</text:p>
1147      </table:table-cell>
1148     </table:table-row>
1149     <table:table-row table:style-name="ro2">
1150      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2004-02-28" calcext:value-type="date">
1151       <text:p>28-02-2004</text:p>
1152      </table:table-cell>
1153      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2005-02-28" calcext:value-type="date">
1154       <text:p>28-02-2005</text:p>
1155      </table:table-cell>
1156      <table:table-cell office:value-type="string" calcext:value-type="string">
1157       <text:p>=(B36-A36)/YEARFRAC(A36;B36;1)</text:p>
1158      </table:table-cell>
1159      <table:table-cell table:style-name="ce18" table:formula="of:=([.B36]-[.A36])/YEARFRAC([.A36];[.B36];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1160       <text:p>366,000000</text:p>
1161      </table:table-cell>
1162      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1163       <text:p>366,000000</text:p>
1164      </table:table-cell>
1165      <table:table-cell table:style-name="ce20" table:formula="of:=[.D36]=[.E36]" office:value-type="float" office:value="1" calcext:value-type="float">
1166       <text:p>1</text:p>
1167      </table:table-cell>
1168      <table:table-cell office:value-type="string" calcext:value-type="string">
1169       <text:p>tdf69569, days in year</text:p>
1170      </table:table-cell>
1171     </table:table-row>
1172     <table:table-row table:style-name="ro2">
1173      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-01-01" calcext:value-type="date">
1174       <text:p>01-01-2016</text:p>
1175      </table:table-cell>
1176      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-01-31" calcext:value-type="date">
1177       <text:p>31-01-2016</text:p>
1178      </table:table-cell>
1179      <table:table-cell office:value-type="string" calcext:value-type="string">
1180       <text:p>=(B37-A37)/YEARFRAC(A37;B37;1)</text:p>
1181      </table:table-cell>
1182      <table:table-cell table:style-name="ce18" table:formula="of:=([.B37]-[.A37])/YEARFRAC([.A37];[.B37];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1183       <text:p>366,000000</text:p>
1184      </table:table-cell>
1185      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1186       <text:p>366,000000</text:p>
1187      </table:table-cell>
1188      <table:table-cell table:style-name="ce20" table:formula="of:=[.D37]=[.E37]" office:value-type="float" office:value="1" calcext:value-type="float">
1189       <text:p>1</text:p>
1190      </table:table-cell>
1191      <table:table-cell office:value-type="string" calcext:value-type="string">
1192       <text:p>tdf69569, days in year</text:p>
1193      </table:table-cell>
1194     </table:table-row>
1195     <table:table-row table:style-name="ro2">
1196      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-01-01" calcext:value-type="date">
1197       <text:p>01-01-2016</text:p>
1198      </table:table-cell>
1199      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2017-01-01" calcext:value-type="date">
1200       <text:p>01-01-2017</text:p>
1201      </table:table-cell>
1202      <table:table-cell office:value-type="string" calcext:value-type="string">
1203       <text:p>=(B38-A38)/YEARFRAC(A38;B38;1)</text:p>
1204      </table:table-cell>
1205      <table:table-cell table:style-name="ce18" table:formula="of:=([.B38]-[.A38])/YEARFRAC([.A38];[.B38];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1206       <text:p>366,000000</text:p>
1207      </table:table-cell>
1208      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1209       <text:p>366,000000</text:p>
1210      </table:table-cell>
1211      <table:table-cell table:style-name="ce20" table:formula="of:=[.D38]=[.E38]" office:value-type="float" office:value="1" calcext:value-type="float">
1212       <text:p>1</text:p>
1213      </table:table-cell>
1214      <table:table-cell office:value-type="string" calcext:value-type="string">
1215       <text:p>tdf69569, days in year</text:p>
1216      </table:table-cell>
1217     </table:table-row>
1218     <table:table-row table:style-name="ro2">
1219      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-01-31" calcext:value-type="date">
1220       <text:p>31-01-2016</text:p>
1221      </table:table-cell>
1222      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2017-01-01" calcext:value-type="date">
1223       <text:p>01-01-2017</text:p>
1224      </table:table-cell>
1225      <table:table-cell office:value-type="string" calcext:value-type="string">
1226       <text:p>=(B39-A39)/YEARFRAC(A39;B39;1)</text:p>
1227      </table:table-cell>
1228      <table:table-cell table:style-name="ce18" table:formula="of:=([.B39]-[.A39])/YEARFRAC([.A39];[.B39];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1229       <text:p>366,000000</text:p>
1230      </table:table-cell>
1231      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1232       <text:p>366,000000</text:p>
1233      </table:table-cell>
1234      <table:table-cell table:style-name="ce20" table:formula="of:=[.D39]=[.E39]" office:value-type="float" office:value="1" calcext:value-type="float">
1235       <text:p>1</text:p>
1236      </table:table-cell>
1237      <table:table-cell office:value-type="string" calcext:value-type="string">
1238       <text:p>tdf69569, days in year</text:p>
1239      </table:table-cell>
1240     </table:table-row>
1241     <table:table-row table:style-name="ro2">
1242      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-01-31" calcext:value-type="date">
1243       <text:p>31-01-2016</text:p>
1244      </table:table-cell>
1245      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2017-01-31" calcext:value-type="date">
1246       <text:p>31-01-2017</text:p>
1247      </table:table-cell>
1248      <table:table-cell office:value-type="string" calcext:value-type="string">
1249       <text:p>=(B40-A40)/YEARFRAC(A40;B40;1)</text:p>
1250      </table:table-cell>
1251      <table:table-cell table:style-name="ce18" table:formula="of:=([.B40]-[.A40])/YEARFRAC([.A40];[.B40];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1252       <text:p>366,000000</text:p>
1253      </table:table-cell>
1254      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1255       <text:p>366,000000</text:p>
1256      </table:table-cell>
1257      <table:table-cell table:style-name="ce20" table:formula="of:=[.D40]=[.E40]" office:value-type="float" office:value="1" calcext:value-type="float">
1258       <text:p>1</text:p>
1259      </table:table-cell>
1260      <table:table-cell office:value-type="string" calcext:value-type="string">
1261       <text:p>tdf69569, days in year</text:p>
1262      </table:table-cell>
1263     </table:table-row>
1264     <table:table-row table:style-name="ro2">
1265      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-02-29" calcext:value-type="date">
1266       <text:p>29-02-2016</text:p>
1267      </table:table-cell>
1268      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-05-01" calcext:value-type="date">
1269       <text:p>01-05-2016</text:p>
1270      </table:table-cell>
1271      <table:table-cell office:value-type="string" calcext:value-type="string">
1272       <text:p>=(B41-A41)/YEARFRAC(A41;B41;1)</text:p>
1273      </table:table-cell>
1274      <table:table-cell table:style-name="ce18" table:formula="of:=([.B41]-[.A41])/YEARFRAC([.A41];[.B41];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1275       <text:p>366,000000</text:p>
1276      </table:table-cell>
1277      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1278       <text:p>366,000000</text:p>
1279      </table:table-cell>
1280      <table:table-cell table:style-name="ce20" table:formula="of:=[.D41]=[.E41]" office:value-type="float" office:value="1" calcext:value-type="float">
1281       <text:p>1</text:p>
1282      </table:table-cell>
1283      <table:table-cell office:value-type="string" calcext:value-type="string">
1284       <text:p>tdf69569, days in year</text:p>
1285      </table:table-cell>
1286     </table:table-row>
1287     <table:table-row table:style-name="ro2">
1288      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-04-30" calcext:value-type="date">
1289       <text:p>30-04-2016</text:p>
1290      </table:table-cell>
1291      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-09-01" calcext:value-type="date">
1292       <text:p>01-09-2016</text:p>
1293      </table:table-cell>
1294      <table:table-cell office:value-type="string" calcext:value-type="string">
1295       <text:p>=(B42-A42)/YEARFRAC(A42;B42;1)</text:p>
1296      </table:table-cell>
1297      <table:table-cell table:style-name="ce18" table:formula="of:=([.B42]-[.A42])/YEARFRAC([.A42];[.B42];1)" office:value-type="float" office:value="366" calcext:value-type="float">
1298       <text:p>366,000000</text:p>
1299      </table:table-cell>
1300      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="366.000000" calcext:value-type="float">
1301       <text:p>366,000000</text:p>
1302      </table:table-cell>
1303      <table:table-cell table:style-name="ce20" table:formula="of:=[.D42]=[.E42]" office:value-type="float" office:value="1" calcext:value-type="float">
1304       <text:p>1</text:p>
1305      </table:table-cell>
1306      <table:table-cell office:value-type="string" calcext:value-type="string">
1307       <text:p>tdf69569, days in year</text:p>
1308      </table:table-cell>
1309     </table:table-row>
1310     <table:table-row table:style-name="ro2">
1311      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2016-11-30" calcext:value-type="date">
1312       <text:p>30-11-2016</text:p>
1313      </table:table-cell>
1314      <table:table-cell table:style-name="ce17" office:value-type="date" office:date-value="2017-09-29" calcext:value-type="date">
1315       <text:p>29-09-2017</text:p>
1316      </table:table-cell>
1317      <table:table-cell office:value-type="string" calcext:value-type="string">
1318       <text:p>=(B43-A43)/YEARFRAC(A43;B43;1)</text:p>
1319      </table:table-cell>
1320      <table:table-cell table:style-name="ce18" table:formula="of:=([.B43]-[.A43])/YEARFRAC([.A43];[.B43];1)" office:value-type="float" office:value="365" calcext:value-type="float">
1321       <text:p>365.000000</text:p>
1322      </table:table-cell>
1323      <table:table-cell table:style-name="ce18" office:value-type="float" office:value="365.000000" calcext:value-type="float">
1324       <text:p>365,000000</text:p>
1325      </table:table-cell>
1326      <table:table-cell table:style-name="ce20" table:formula="of:=[.D43]=[.E43]" office:value-type="float" office:value="1" calcext:value-type="float">
1327       <text:p>1</text:p>
1328      </table:table-cell>
1329      <table:table-cell office:value-type="string" calcext:value-type="string">
1330       <text:p>tdf69569, days in year</text:p>
1331      </table:table-cell>
1332     </table:table-row>
1333     <table:table-row table:style-name="ro2" table:number-rows-repeated="157">
1334      <table:table-cell table:number-columns-repeated="7"/>
1335     </table:table-row>
1336     <table:table-row table:style-name="ro2">
1337      <table:table-cell table:number-columns-repeated="7"/>
1338     </table:table-row>
1339     <calcext:conditional-formats>
1340      <calcext:conditional-format calcext:target-range-address="Sheet2.F2:Sheet2.F201">
1341       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.F2"/>
1342       <calcext:condition calcext:apply-style-name="Bez názvu1" calcext:value="=0" calcext:base-cell-address="Sheet2.F2"/>
1343       <calcext:condition calcext:apply-style-name="Bez názvu2" calcext:value="=1" calcext:base-cell-address="Sheet2.F2"/>
1344      </calcext:conditional-format>
1345     </calcext:conditional-formats>
1346    </table:table>
1347    <table:named-expressions>
1348     <table:named-range table:name="yearFracDate" table:base-cell-address="$Sheet2.$B$33" table:cell-range-address="$Sheet2.$B$31"/>
1349    </table:named-expressions>
1350   </office:spreadsheet>
1351  </office:body>
1352 </office:document>