sc/qa/unit/data/functions/text/fods/concatenate.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:meta><meta:creation-date>2016-05-23T19:52:21.032366237</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e</meta:generator><meta:document-statistic meta:table-count="2" meta:cell-count="51" meta:object-count="0"/></office:meta>
   5  <office:settings>
   6   <config:config-item-set config:name="ooo:view-settings">
   7    <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item>
   8    <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item>
   9    <config:config-item config:name="VisibleAreaWidth" config:type="int">33385</config:config-item>
  10    <config:config-item config:name="VisibleAreaHeight" config:type="int">4400</config:config-item>
  11    <config:config-item-map-indexed config:name="Views">
  12     <config:config-item-map-entry>
  13      <config:config-item config:name="ViewId" config:type="string">view1</config:config-item>
  14      <config:config-item-map-named config:name="Tables">
  15       <config:config-item-map-entry config:name="Sheet1">
  16        <config:config-item config:name="CursorPositionX" config:type="int">2</config:config-item>
  17        <config:config-item config:name="CursorPositionY" config:type="int">8</config:config-item>
  18        <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item>
  19        <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item>
  20        <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item>
  21        <config:config-item config:name="VerticalSplitPosition" config:type="int">0</config:config-item>
  22        <config:config-item config:name="ActiveSplitRange" config:type="short">2</config:config-item>
  23        <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item>
  24        <config:config-item config:name="PositionRight" config:type="int">0</config:config-item>
  25        <config:config-item config:name="PositionTop" config:type="int">0</config:config-item>
  26        <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item>
  27        <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
  28        <config:config-item config:name="ZoomValue" config:type="int">85</config:config-item>
  29        <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
  30        <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
  31        <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item>
  32       </config:config-item-map-entry>
  33       <config:config-item-map-entry config:name="Sheet2">
  34        <config:config-item config:name="CursorPositionX" config:type="int">3</config:config-item>
  35        <config:config-item config:name="CursorPositionY" config:type="int">8</config:config-item>
  36        <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item>
  37        <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item>
  38        <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item>
  39        <config:config-item config:name="VerticalSplitPosition" config:type="int">0</config:config-item>
  40        <config:config-item config:name="ActiveSplitRange" config:type="short">2</config:config-item>
  41        <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item>
  42        <config:config-item config:name="PositionRight" config:type="int">0</config:config-item>
  43        <config:config-item config:name="PositionTop" config:type="int">0</config:config-item>
  44        <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item>
  45        <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
  46        <config:config-item config:name="ZoomValue" config:type="int">85</config:config-item>
  47        <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
  48        <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
  49        <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item>
  50       </config:config-item-map-entry>
  51      </config:config-item-map-named>
  52      <config:config-item config:name="ActiveTable" config:type="string">Sheet2</config:config-item>
  53      <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1241</config:config-item>
  54      <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
  55      <config:config-item config:name="ZoomValue" config:type="int">85</config:config-item>
  56      <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
  57      <config:config-item config:name="ShowPageBreakPreview" config:type="boolean">false</config:config-item>
  58      <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item>
  59      <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item>
  60      <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
  61      <config:config-item config:name="GridColor" config:type="long">12632256</config:config-item>
  62      <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item>
  63      <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item>
  64      <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item>
  65      <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item>
  66      <config:config-item config:name="IsValueHighlightingEnabled" config:type="boolean">false</config:config-item>
  67      <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
  68      <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
  69      <config:config-item config:name="RasterResolutionX" config:type="int">1270</config:config-item>
  70      <config:config-item config:name="RasterResolutionY" config:type="int">1270</config:config-item>
  71      <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item>
  72      <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item>
  73      <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean">true</config:config-item>
  74      <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item>
  75     </config:config-item-map-entry>
  76    </config:config-item-map-indexed>
  77   </config:config-item-set>
  78   <config:config-item-set config:name="ooo:configuration-settings">
  79    <config:config-item config:name="SyntaxStringRef" config:type="short">7</config:config-item>
  80    <config:config-item config:name="IsDocumentShared" config:type="boolean">false</config:config-item>
  81    <config:config-item config:name="LoadReadonly" config:type="boolean">false</config:config-item>
  82    <config:config-item config:name="AllowPrintJobCancel" config:type="boolean">true</config:config-item>
  83    <config:config-item config:name="UpdateFromTemplate" config:type="boolean">true</config:config-item>
  84    <config:config-item config:name="IsKernAsianPunctuation" config:type="boolean">false</config:config-item>
  85    <config:config-item config:name="EmbedFonts" config:type="boolean">false</config:config-item>
  86    <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
  87    <config:config-item config:name="RasterResolutionX" config:type="int">1270</config:config-item>
  88    <config:config-item config:name="RasterResolutionY" config:type="int">1270</config:config-item>
  89    <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item>
  90    <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean">true</config:config-item>
  91    <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item>
  92    <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
  93    <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item>
  94    <config:config-item config:name="SaveVersionOnClose" config:type="boolean">false</config:config-item>
  95    <config:config-item config:name="GridColor" config:type="long">12632256</config:config-item>
  96    <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
  97    <config:config-item config:name="PrinterName" config:type="string">Lexmark-E352dn</config:config-item>
  98    <config:config-item-map-indexed config:name="ForbiddenCharacters">
  99     <config:config-item-map-entry>
 100      <config:config-item config:name="Language" config:type="string">en</config:config-item>
 101      <config:config-item config:name="Country" config:type="string">US</config:config-item>
 102      <config:config-item config:name="Variant" config:type="string"/>
 103      <config:config-item config:name="BeginLine" config:type="string"/>
 104      <config:config-item config:name="EndLine" config:type="string"/>
 105     </config:config-item-map-entry>
 106    </config:config-item-map-indexed>
 107    <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item>
 108    <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item>
 109    <config:config-item config:name="LinkUpdateMode" config:type="short">3</config:config-item>
 110    <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item>
 111    <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item>
 112    <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item>
 113    <config:config-item config:name="AutoCalculate" config:type="boolean">true</config:config-item>
 114    <config:config-item config:name="PrinterSetup" config:type="base64Binary">rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==</config:config-item>
 115    <config:config-item config:name="ApplyUserData" config:type="boolean">false</config:config-item>
 116    <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item>
 117   </config:config-item-set>
 118  </office:settings>
 119  <office:scripts>
 120   <office:script script:language="ooo:Basic">
 121    <ooo:libraries xmlns:ooo="http://openoffice.org/2004/office" xmlns:xlink="http://www.w3.org/1999/xlink">
 122     <ooo:library-embedded ooo:name="Standard"/>
 123    </ooo:libraries>
 124   </office:script>
 125  </office:scripts>
 126  <office:font-face-decls>
 127   <style:font-face style:name="Liberation Serif" svg:font-family="&apos;Liberation Serif&apos;" style:font-family-generic="roman" style:font-pitch="variable"/>
 128   <style:font-face style:name="Liberation Sans" svg:font-family="&apos;Liberation Sans&apos;" style:font-family-generic="swiss" style:font-pitch="variable"/>
 129   <style:font-face style:name="DejaVu Sans" svg:font-family="&apos;DejaVu Sans&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
 130   <style:font-face style:name="Droid Sans Devanagari" svg:font-family="&apos;Droid Sans Devanagari&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
 131   <style:font-face style:name="Droid Sans Fallback" svg:font-family="&apos;Droid Sans Fallback&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
 132   <style:font-face style:name="Mangal" svg:font-family="Mangal" style:font-family-generic="system" style:font-pitch="variable"/>
 133   <style:font-face style:name="Microsoft YaHei" svg:font-family="&apos;Microsoft YaHei&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
 134  </office:font-face-decls>
 135  <office:styles>
 136   <style:default-style style:family="table-cell">
 137    <style:paragraph-properties style:tab-stop-distance="36pt"/>
 138    <style:text-properties style:font-name="Liberation Sans" fo:language="en" fo:country="US" style:font-name-asian="DejaVu Sans" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="DejaVu Sans" style:language-complex="hi" style:country-complex="IN"/>
 139   </style:default-style>
 140   <number:number-style style:name="N0">
 141    <number:number number:min-integer-digits="1"/>
 142   </number:number-style>
 143   <number:currency-style style:name="N122P0" style:volatile="true">
 144    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 145    <number:text> </number:text>
 146    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 147   </number:currency-style>
 148   <number:currency-style style:name="N122">
 149    <style:text-properties fo:color="#ff0000"/>
 150    <number:text>-</number:text>
 151    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 152    <number:text> </number:text>
 153    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 154    <style:map style:condition="value()&gt;=0" style:apply-style-name="N122P0"/>
 155   </number:currency-style>
 156   <number:currency-style style:name="N124P0" style:volatile="true">
 157    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 158    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 159   </number:currency-style>
 160   <number:currency-style style:name="N124">
 161    <number:text>-</number:text>
 162    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 163    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 164    <style:map style:condition="value()&gt;=0" style:apply-style-name="N124P0"/>
 165   </number:currency-style>
 166   <number:currency-style style:name="N126P0" style:volatile="true">
 167    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 168    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 169   </number:currency-style>
 170   <number:currency-style style:name="N126">
 171    <number:text>-</number:text>
 172    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 173    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 174    <style:map style:condition="value()&gt;=0" style:apply-style-name="N126P0"/>
 175   </number:currency-style>
 176   <number:currency-style style:name="N127P0" style:volatile="true">
 177    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 178    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 179   </number:currency-style>
 180   <number:currency-style style:name="N127">
 181    <style:text-properties fo:color="#ff0000"/>
 182    <number:text>-</number:text>
 183    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 184    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 185    <style:map style:condition="value()&gt;=0" style:apply-style-name="N127P0"/>
 186   </number:currency-style>
 187   <number:currency-style style:name="N128P0" style:volatile="true">
 188    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 189    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 190   </number:currency-style>
 191   <number:currency-style style:name="N128">
 192    <style:text-properties fo:color="#ff0000"/>
 193    <number:text>-</number:text>
 194    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 195    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 196    <style:map style:condition="value()&gt;=0" style:apply-style-name="N128P0"/>
 197   </number:currency-style>
 198   <number:currency-style style:name="N130P0" style:volatile="true">
 199    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 200    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 201   </number:currency-style>
 202   <number:currency-style style:name="N130">
 203    <style:text-properties fo:color="#ff0000"/>
 204    <number:text>-</number:text>
 205    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 206    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 207    <style:map style:condition="value()&gt;=0" style:apply-style-name="N130P0"/>
 208   </number:currency-style>
 209   <number:number-style style:name="N132P0" style:volatile="true">
 210    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 211    <number:text> </number:text>
 212   </number:number-style>
 213   <number:number-style style:name="N132">
 214    <number:text>(</number:text>
 215    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 216    <number:text>)</number:text>
 217    <style:map style:condition="value()&gt;=0" style:apply-style-name="N132P0"/>
 218   </number:number-style>
 219   <number:number-style style:name="N134P0" style:volatile="true">
 220    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 221    <number:text> </number:text>
 222   </number:number-style>
 223   <number:number-style style:name="N134">
 224    <number:text>(</number:text>
 225    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 226    <number:text>)</number:text>
 227    <style:map style:condition="value()&gt;=0" style:apply-style-name="N134P0"/>
 228   </number:number-style>
 229   <number:currency-style style:name="N136P0" style:volatile="true">
 230    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 231    <loext:fill-character> </loext:fill-character>
 232    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 233   </number:currency-style>
 234   <number:currency-style style:name="N136">
 235    <number:text>-</number:text>
 236    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 237    <loext:fill-character> </loext:fill-character>
 238    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 239    <style:map style:condition="value()&gt;=0" style:apply-style-name="N136P0"/>
 240   </number:currency-style>
 241   <number:currency-style style:name="N138P0" style:volatile="true">
 242    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 243    <loext:fill-character> </loext:fill-character>
 244    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 245   </number:currency-style>
 246   <number:currency-style style:name="N138">
 247    <number:text>-</number:text>
 248    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 249    <loext:fill-character> </loext:fill-character>
 250    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 251    <style:map style:condition="value()&gt;=0" style:apply-style-name="N138P0"/>
 252   </number:currency-style>
 253   <number:number-style style:name="N139">
 254    <number:number number:decimal-places="9" loext:min-decimal-places="9" number:min-integer-digits="1"/>
 255   </number:number-style>
 256   <number:number-style style:name="N140">
 257    <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
 258   </number:number-style>
 259   <number:number-style style:name="N141">
 260    <number:number number:decimal-places="10" loext:min-decimal-places="10" number:min-integer-digits="1"/>
 261   </number:number-style>
 262   <number:number-style style:name="N142">
 263    <number:number number:decimal-places="11" loext:min-decimal-places="11" number:min-integer-digits="1"/>
 264   </number:number-style>
 265   <number:number-style style:name="N143">
 266    <number:number number:decimal-places="12" loext:min-decimal-places="12" number:min-integer-digits="1"/>
 267   </number:number-style>
 268   <number:number-style style:name="N144">
 269    <number:number number:decimal-places="13" loext:min-decimal-places="13" number:min-integer-digits="1"/>
 270   </number:number-style>
 271   <number:number-style style:name="N145">
 272    <number:number number:decimal-places="14" loext:min-decimal-places="14" number:min-integer-digits="1"/>
 273   </number:number-style>
 274   <number:number-style style:name="N146">
 275    <number:number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1"/>
 276   </number:number-style>
 277   <number:number-style style:name="N147">
 278    <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/>
 279   </number:number-style>
 280   <number:number-style style:name="N148">
 281    <number:number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1"/>
 282   </number:number-style>
 283   <number:number-style style:name="N149">
 284    <number:number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1"/>
 285   </number:number-style>
 286   <number:currency-style style:name="N151P0" style:volatile="true">
 287    <number:currency-symbol number:language="en" number:country="IE">€</number:currency-symbol>
 288    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 289   </number:currency-style>
 290   <number:currency-style style:name="N151">
 291    <style:text-properties fo:color="#ff0000"/>
 292    <number:text>-</number:text>
 293    <number:currency-symbol number:language="en" number:country="IE">€</number:currency-symbol>
 294    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 295    <style:map style:condition="value()&gt;=0" style:apply-style-name="N151P0"/>
 296   </number:currency-style>
 297   <number:currency-style style:name="N153P0" style:volatile="true">
 298    <number:currency-symbol number:language="pt" number:country="BR">R$</number:currency-symbol>
 299    <number:text> </number:text>
 300    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 301   </number:currency-style>
 302   <number:currency-style style:name="N153">
 303    <style:text-properties fo:color="#ff0000"/>
 304    <number:text>-</number:text>
 305    <number:currency-symbol number:language="pt" number:country="BR">R$</number:currency-symbol>
 306    <number:text> </number:text>
 307    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 308    <style:map style:condition="value()&gt;=0" style:apply-style-name="N153P0"/>
 309   </number:currency-style>
 310   <number:currency-style style:name="N155P0" style:volatile="true">
 311    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 312    <number:text> </number:text>
 313    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 314   </number:currency-style>
 315   <number:currency-style style:name="N155">
 316    <style:text-properties fo:color="#ff0000"/>
 317    <number:text>-</number:text>
 318    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 319    <number:text> </number:text>
 320    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 321    <style:map style:condition="value()&gt;=0" style:apply-style-name="N155P0"/>
 322   </number:currency-style>
 323   <number:number-style style:name="N157P0" style:volatile="true">
 324    <number:text>\</number:text>
 325    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 326   </number:number-style>
 327   <number:number-style style:name="N157">
 328    <number:text>\-</number:text>
 329    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 330    <style:map style:condition="value()&gt;=0" style:apply-style-name="N157P0"/>
 331   </number:number-style>
 332   <number:number-style style:name="N158P0" style:volatile="true">
 333    <number:text>\</number:text>
 334    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 335   </number:number-style>
 336   <number:number-style style:name="N158">
 337    <style:text-properties fo:color="#ff0000"/>
 338    <number:text>\-</number:text>
 339    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 340    <style:map style:condition="value()&gt;=0" style:apply-style-name="N158P0"/>
 341   </number:number-style>
 342   <number:number-style style:name="N160P0" style:volatile="true">
 343    <number:text>\</number:text>
 344    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 345   </number:number-style>
 346   <number:number-style style:name="N160">
 347    <number:text>\-</number:text>
 348    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 349    <style:map style:condition="value()&gt;=0" style:apply-style-name="N160P0"/>
 350   </number:number-style>
 351   <number:number-style style:name="N161P0" style:volatile="true">
 352    <number:text>\</number:text>
 353    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 354   </number:number-style>
 355   <number:number-style style:name="N161">
 356    <style:text-properties fo:color="#ff0000"/>
 357    <number:text>\-</number:text>
 358    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 359    <style:map style:condition="value()&gt;=0" style:apply-style-name="N161P0"/>
 360   </number:number-style>
 361   <number:number-style style:name="N163P0" style:volatile="true">
 362    <number:text>$</number:text>
 363    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 364    <number:text> </number:text>
 365   </number:number-style>
 366   <number:number-style style:name="N163">
 367    <number:text>($</number:text>
 368    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 369    <number:text>)</number:text>
 370    <style:map style:condition="value()&gt;=0" style:apply-style-name="N163P0"/>
 371   </number:number-style>
 372   <number:number-style style:name="N164P0" style:volatile="true">
 373    <number:text>$</number:text>
 374    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 375    <number:text> </number:text>
 376   </number:number-style>
 377   <number:number-style style:name="N164">
 378    <style:text-properties fo:color="#ff0000"/>
 379    <number:text>($</number:text>
 380    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 381    <number:text>)</number:text>
 382    <style:map style:condition="value()&gt;=0" style:apply-style-name="N164P0"/>
 383   </number:number-style>
 384   <number:number-style style:name="N166P0" style:volatile="true">
 385    <number:text>$</number:text>
 386    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 387    <number:text> </number:text>
 388   </number:number-style>
 389   <number:number-style style:name="N166">
 390    <number:text>($</number:text>
 391    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 392    <number:text>)</number:text>
 393    <style:map style:condition="value()&gt;=0" style:apply-style-name="N166P0"/>
 394   </number:number-style>
 395   <number:number-style style:name="N167P0" style:volatile="true">
 396    <number:text>$</number:text>
 397    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 398    <number:text> </number:text>
 399   </number:number-style>
 400   <number:number-style style:name="N167">
 401    <style:text-properties fo:color="#ff0000"/>
 402    <number:text>($</number:text>
 403    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 404    <number:text>)</number:text>
 405    <style:map style:condition="value()&gt;=0" style:apply-style-name="N167P0"/>
 406   </number:number-style>
 407   <number:number-style style:name="N171P0" style:volatile="true">
 408    <loext:text> </loext:text>
 409    <loext:fill-character> </loext:fill-character>
 410    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 411    <number:text> </number:text>
 412   </number:number-style>
 413   <number:number-style style:name="N171P1" style:volatile="true">
 414    <loext:text> </loext:text>
 415    <loext:fill-character> </loext:fill-character>
 416    <number:text>-</number:text>
 417    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 418    <number:text> </number:text>
 419   </number:number-style>
 420   <number:number-style style:name="N171P2" style:volatile="true">
 421    <loext:text> </loext:text>
 422    <loext:fill-character> </loext:fill-character>
 423    <number:text>- </number:text>
 424   </number:number-style>
 425   <number:text-style style:name="N171">
 426    <number:text> </number:text>
 427    <number:text-content/>
 428    <number:text> </number:text>
 429    <style:map style:condition="value()&gt;0" style:apply-style-name="N171P0"/>
 430    <style:map style:condition="value()&lt;0" style:apply-style-name="N171P1"/>
 431    <style:map style:condition="value()=0" style:apply-style-name="N171P2"/>
 432   </number:text-style>
 433   <number:number-style style:name="N175P0" style:volatile="true">
 434    <loext:text> \</loext:text>
 435    <loext:fill-character> </loext:fill-character>
 436    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 437    <number:text> </number:text>
 438   </number:number-style>
 439   <number:number-style style:name="N175P1" style:volatile="true">
 440    <loext:text> \</loext:text>
 441    <loext:fill-character> </loext:fill-character>
 442    <number:text>-</number:text>
 443    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 444    <number:text> </number:text>
 445   </number:number-style>
 446   <number:number-style style:name="N175P2" style:volatile="true">
 447    <loext:text> \</loext:text>
 448    <loext:fill-character> </loext:fill-character>
 449    <number:text>- </number:text>
 450   </number:number-style>
 451   <number:text-style style:name="N175">
 452    <number:text> </number:text>
 453    <number:text-content/>
 454    <number:text> </number:text>
 455    <style:map style:condition="value()&gt;0" style:apply-style-name="N175P0"/>
 456    <style:map style:condition="value()&lt;0" style:apply-style-name="N175P1"/>
 457    <style:map style:condition="value()=0" style:apply-style-name="N175P2"/>
 458   </number:text-style>
 459   <number:number-style style:name="N179P0" style:volatile="true">
 460    <loext:text> </loext:text>
 461    <loext:fill-character> </loext:fill-character>
 462    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 463    <number:text> </number:text>
 464   </number:number-style>
 465   <number:number-style style:name="N179P1" style:volatile="true">
 466    <loext:text> </loext:text>
 467    <loext:fill-character> </loext:fill-character>
 468    <number:text>-</number:text>
 469    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 470    <number:text> </number:text>
 471   </number:number-style>
 472   <number:number-style style:name="N179P2" style:volatile="true">
 473    <loext:text> </loext:text>
 474    <loext:fill-character> </loext:fill-character>
 475    <number:text>-</number:text>
 476    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/>
 477    <number:text> </number:text>
 478   </number:number-style>
 479   <number:text-style style:name="N179">
 480    <number:text> </number:text>
 481    <number:text-content/>
 482    <number:text> </number:text>
 483    <style:map style:condition="value()&gt;0" style:apply-style-name="N179P0"/>
 484    <style:map style:condition="value()&lt;0" style:apply-style-name="N179P1"/>
 485    <style:map style:condition="value()=0" style:apply-style-name="N179P2"/>
 486   </number:text-style>
 487   <number:number-style style:name="N183P0" style:volatile="true">
 488    <loext:text> \</loext:text>
 489    <loext:fill-character> </loext:fill-character>
 490    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 491    <number:text> </number:text>
 492   </number:number-style>
 493   <number:number-style style:name="N183P1" style:volatile="true">
 494    <loext:text> \</loext:text>
 495    <loext:fill-character> </loext:fill-character>
 496    <number:text>-</number:text>
 497    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 498    <number:text> </number:text>
 499   </number:number-style>
 500   <number:number-style style:name="N183P2" style:volatile="true">
 501    <loext:text> \</loext:text>
 502    <loext:fill-character> </loext:fill-character>
 503    <number:text>-</number:text>
 504    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/>
 505    <number:text> </number:text>
 506   </number:number-style>
 507   <number:text-style style:name="N183">
 508    <number:text> </number:text>
 509    <number:text-content/>
 510    <number:text> </number:text>
 511    <style:map style:condition="value()&gt;0" style:apply-style-name="N183P0"/>
 512    <style:map style:condition="value()&lt;0" style:apply-style-name="N183P1"/>
 513    <style:map style:condition="value()=0" style:apply-style-name="N183P2"/>
 514   </number:text-style>
 515   <number:time-style style:name="N184">
 516    <number:minutes number:style="long"/>
 517    <number:text>:</number:text>
 518    <number:seconds number:style="long"/>
 519   </number:time-style>
 520   <number:time-style style:name="N185" number:truncate-on-overflow="false">
 521    <number:hours/>
 522    <number:text>:</number:text>
 523    <number:minutes number:style="long"/>
 524    <number:text>:</number:text>
 525    <number:seconds number:style="long"/>
 526   </number:time-style>
 527   <number:time-style style:name="N186">
 528    <number:minutes number:style="long"/>
 529    <number:text>:</number:text>
 530    <number:seconds number:style="long" number:decimal-places="1"/>
 531   </number:time-style>
 532   <number:number-style style:name="N187">
 533    <number:scientific-number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1" number:min-exponent-digits="1" loext:exponent-interval="3" loext:forced-exponent-sign="true"/>
 534   </number:number-style>
 535   <number:date-style style:name="N10121" number:language="en" number:country="US">
 536    <number:month/>
 537    <number:text>/</number:text>
 538    <number:day/>
 539    <number:text>/</number:text>
 540    <number:year number:style="long"/>
 541   </number:date-style>
 542   <number:date-style style:name="N10122" number:language="en" number:country="US">
 543    <number:day/>
 544    <number:text>-</number:text>
 545    <number:month number:textual="true"/>
 546    <number:text>-</number:text>
 547    <number:year/>
 548   </number:date-style>
 549   <number:date-style style:name="N10123" number:language="en" number:country="US">
 550    <number:day/>
 551    <number:text>-</number:text>
 552    <number:month number:textual="true"/>
 553   </number:date-style>
 554   <number:date-style style:name="N10124" number:language="en" number:country="US">
 555    <number:month number:textual="true"/>
 556    <number:text>-</number:text>
 557    <number:year/>
 558   </number:date-style>
 559   <number:time-style style:name="N10125" number:language="en" number:country="US">
 560    <number:hours/>
 561    <number:text>:</number:text>
 562    <number:minutes number:style="long"/>
 563    <number:text> </number:text>
 564    <number:am-pm/>
 565   </number:time-style>
 566   <number:time-style style:name="N10126" number:language="en" number:country="US">
 567    <number:hours/>
 568    <number:text>:</number:text>
 569    <number:minutes number:style="long"/>
 570    <number:text>:</number:text>
 571    <number:seconds number:style="long"/>
 572    <number:text> </number:text>
 573    <number:am-pm/>
 574   </number:time-style>
 575   <number:time-style style:name="N10127" number:language="en" number:country="US">
 576    <number:hours/>
 577    <number:text>:</number:text>
 578    <number:minutes number:style="long"/>
 579   </number:time-style>
 580   <number:time-style style:name="N10128" number:language="en" number:country="US">
 581    <number:hours/>
 582    <number:text>:</number:text>
 583    <number:minutes number:style="long"/>
 584    <number:text>:</number:text>
 585    <number:seconds number:style="long"/>
 586   </number:time-style>
 587   <number:date-style style:name="N10129" number:language="en" number:country="US">
 588    <number:month/>
 589    <number:text>/</number:text>
 590    <number:day/>
 591    <number:text>/</number:text>
 592    <number:year number:style="long"/>
 593    <number:text> </number:text>
 594    <number:hours/>
 595    <number:text>:</number:text>
 596    <number:minutes number:style="long"/>
 597   </number:date-style>
 598   <number:number-style style:name="N10131P0" style:volatile="true" number:language="en" number:country="US">
 599    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 600    <number:text> </number:text>
 601   </number:number-style>
 602   <number:number-style style:name="N10131" number:language="en" number:country="US">
 603    <style:text-properties fo:color="#ff0000"/>
 604    <number:text>(</number:text>
 605    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 606    <number:text>)</number:text>
 607    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10131P0"/>
 608   </number:number-style>
 609   <number:number-style style:name="N10133P0" style:volatile="true" number:language="en" number:country="US">
 610    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 611    <number:text> </number:text>
 612   </number:number-style>
 613   <number:number-style style:name="N10133" number:language="en" number:country="US">
 614    <style:text-properties fo:color="#ff0000"/>
 615    <number:text>(</number:text>
 616    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 617    <number:text>)</number:text>
 618    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10133P0"/>
 619   </number:number-style>
 620   <number:currency-style style:name="N10135P0" style:volatile="true" number:language="en" number:country="US">
 621    <number:currency-symbol/>
 622    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 623    <number:text> </number:text>
 624   </number:currency-style>
 625   <number:currency-style style:name="N10135" number:language="en" number:country="US">
 626    <number:text>(</number:text>
 627    <number:currency-symbol/>
 628    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 629    <number:text>)</number:text>
 630    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10135P0"/>
 631   </number:currency-style>
 632   <number:currency-style style:name="N10136P0" style:volatile="true" number:language="en" number:country="US">
 633    <number:currency-symbol/>
 634    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 635    <number:text> </number:text>
 636   </number:currency-style>
 637   <number:currency-style style:name="N10136" number:language="en" number:country="US">
 638    <style:text-properties fo:color="#ff0000"/>
 639    <number:text>(</number:text>
 640    <number:currency-symbol/>
 641    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 642    <number:text>)</number:text>
 643    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10136P0"/>
 644   </number:currency-style>
 645   <number:currency-style style:name="N10138P0" style:volatile="true" number:language="en" number:country="US">
 646    <number:currency-symbol/>
 647    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 648    <number:text> </number:text>
 649   </number:currency-style>
 650   <number:currency-style style:name="N10138" number:language="en" number:country="US">
 651    <number:text>(</number:text>
 652    <number:currency-symbol/>
 653    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 654    <number:text>)</number:text>
 655    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10138P0"/>
 656   </number:currency-style>
 657   <number:currency-style style:name="N10139P0" style:volatile="true" number:language="en" number:country="US">
 658    <number:currency-symbol/>
 659    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 660    <number:text> </number:text>
 661   </number:currency-style>
 662   <number:currency-style style:name="N10139" number:language="en" number:country="US">
 663    <style:text-properties fo:color="#ff0000"/>
 664    <number:text>(</number:text>
 665    <number:currency-symbol/>
 666    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 667    <number:text>)</number:text>
 668    <style:map style:condition="value()&gt;=0" style:apply-style-name="N10139P0"/>
 669   </number:currency-style>
 670   <style:style style:name="Default" style:family="table-cell">
 671    <style:text-properties style:font-name-asian="Droid Sans Fallback" style:font-family-asian="&apos;Droid Sans Fallback&apos;" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-name-complex="Droid Sans Devanagari" style:font-family-complex="&apos;Droid Sans Devanagari&apos;" style:font-family-generic-complex="system" style:font-pitch-complex="variable"/>
 672   </style:style>
 673   <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
 674    <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"/>
 675   </style:style>
 676   <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N122"/>
 677   <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
 678    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 679    <style:paragraph-properties fo:text-align="center"/>
 680    <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
 681   </style:style>
 682   <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
 683    <style:table-cell-properties style:rotation-angle="90"/>
 684   </style:style>
 685   <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
 686    <style:table-cell-properties fo:background-color="#ff3333"/>
 687   </style:style>
 688   <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
 689    <style:table-cell-properties fo:background-color="#99ff66"/>
 690   </style:style>
 691  </office:styles>
 692  <office:automatic-styles>
 693   <style:style style:name="co1" style:family="table-column">
 694    <style:table-column-properties fo:break-before="auto" style:column-width="185.7pt"/>
 695   </style:style>
 696   <style:style style:name="co2" style:family="table-column">
 697    <style:table-column-properties fo:break-before="auto" style:column-width="252.51pt"/>
 698   </style:style>
 699   <style:style style:name="co3" style:family="table-column">
 700    <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
 701   </style:style>
 702   <style:style style:name="co4" style:family="table-column">
 703    <style:table-column-properties fo:break-before="auto" style:column-width="115.51pt"/>
 704   </style:style>
 705   <style:style style:name="co5" style:family="table-column">
 706    <style:table-column-properties fo:break-before="auto" style:column-width="107.09pt"/>
 707   </style:style>
 708   <style:style style:name="co6" style:family="table-column">
 709    <style:table-column-properties fo:break-before="auto" style:column-width="50.94pt"/>
 710   </style:style>
 711   <style:style style:name="co7" style:family="table-column">
 712    <style:table-column-properties fo:break-before="auto" style:column-width="178.44pt"/>
 713   </style:style>
 714   <style:style style:name="co8" style:family="table-column">
 715    <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/>
 716   </style:style>
 717   <style:style style:name="co9" style:family="table-column">
 718    <style:table-column-properties fo:break-before="auto" style:column-width="47.85pt"/>
 719   </style:style>
 720   <style:style style:name="co10" style:family="table-column">
 721    <style:table-column-properties fo:break-before="auto" style:column-width="115.74pt"/>
 722   </style:style>
 723   <style:style style:name="co11" style:family="table-column">
 724    <style:table-column-properties fo:break-before="auto" style:column-width="38.44pt"/>
 725   </style:style>
 726   <style:style style:name="ro1" style:family="table-row">
 727    <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 728   </style:style>
 729   <style:style style:name="ro2" style:family="table-row">
 730    <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 731   </style:style>
 732   <style:style style:name="ro3" style:family="table-row">
 733    <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 734   </style:style>
 735   <style:style style:name="ro4" style:family="table-row">
 736    <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 737   </style:style>
 738   <style:style style:name="ro5" style:family="table-row">
 739    <style:table-row-properties style:row-height="14.66pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 740   </style:style>
 741   <style:style style:name="ro6" style:family="table-row">
 742    <style:table-row-properties style:row-height="23.84pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 743   </style:style>
 744   <style:style style:name="ro7" style:family="table-row">
 745    <style:table-row-properties style:row-height="35.04pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 746   </style:style>
 747   <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
 748    <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
 749   </style:style>
 750   <number:boolean-style style:name="N99">
 751    <number:boolean/>
 752   </number:boolean-style>
 753   <number:text-style style:name="N100">
 754    <number:text-content/>
 755   </number:text-style>
 756   <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
 757   <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
 758    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 759    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 760    <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"/>
 761   </style:style>
 762   <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
 763    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 764    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 765    <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"/>
 766   </style:style>
 767   <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
 768    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 769    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 770    <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"/>
 771   </style:style>
 772   <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
 773    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 774    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 775   </style:style>
 776   <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 777    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 778    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 779    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 780    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 781    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 782   </style:style>
 783   <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 784    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 785    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 786    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 787    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 788    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 789   </style:style>
 790   <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
 791    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 792    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 793    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 794    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 795    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 796   </style:style>
 797   <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
 798    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 799    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 800    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 801   </style:style>
 802   <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
 803    <style:table-cell-properties fo:wrap-option="wrap"/>
 804    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 805   </style:style>
 806   <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 807    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 808    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 809    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 810    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 811    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 812   </style:style>
 813   <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default">
 814    <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 815   </style:style>
 816   <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">
 817    <style:table-cell-properties fo:wrap-option="wrap"/>
 818    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 819   </style:style>
 820   <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default">
 821    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 822   </style:style>
 823   <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default">
 824    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 825   </style:style>
 826   <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N100">
 827    <style:table-cell-properties fo:padding="2.01pt"/>
 828   </style:style>
 829   <style:style style:name="ta_extref" style:family="table">
 830    <style:table-properties table:display="false"/>
 831   </style:style>
 832   <style:page-layout style:name="pm1">
 833    <style:page-layout-properties style:writing-mode="lr-tb"/>
 834    <style:header-style>
 835     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
 836    </style:header-style>
 837    <style:footer-style>
 838     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
 839    </style:footer-style>
 840   </style:page-layout>
 841   <style:page-layout style:name="pm2">
 842    <style:page-layout-properties style:writing-mode="lr-tb"/>
 843    <style:header-style>
 844     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 845      <style:background-image/>
 846     </style:header-footer-properties>
 847    </style:header-style>
 848    <style:footer-style>
 849     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 850      <style:background-image/>
 851     </style:header-footer-properties>
 852    </style:footer-style>
 853   </style:page-layout>
 854  </office:automatic-styles>
 855  <office:master-styles>
 856   <style:master-page style:name="Default" style:page-layout-name="pm1">
 857    <style:header>
 858     <text:p><text:sheet-name>???</text:sheet-name></text:p>
 859    </style:header>
 860    <style:header-left style:display="false"/>
 861    <style:footer>
 862     <text:p>Page <text:page-number>1</text:page-number></text:p>
 863    </style:footer>
 864    <style:footer-left style:display="false"/>
 865   </style:master-page>
 866   <style:master-page style:name="Report" style:page-layout-name="pm2">
 867    <style:header>
 868     <style:region-left>
 869      <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
 870     </style:region-left>
 871     <style:region-right>
 872      <text:p><text:date style:data-style-name="N2" text:date-value="2016-09-25">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="13:34:12.355600477">00:00:00</text:time></text:p>
 873     </style:region-right>
 874    </style:header>
 875    <style:header-left style:display="false"/>
 876    <style:footer>
 877     <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
 878    </style:footer>
 879    <style:footer-left style:display="false"/>
 880   </style:master-page>
 881  </office:master-styles>
 882  <office:body>
 883   <office:spreadsheet>
 884    <table:calculation-settings table:automatic-find-labels="false"/>
 885    <table:table table:name="Sheet1" table:style-name="ta1">
 886     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
 887     <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/>
 888     <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
 889     <table:table-row table:style-name="ro1">
 890      <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
 891       <text:p>CONCATENATE Function</text:p>
 892      </table:table-cell>
 893      <table:table-cell table:number-columns-repeated="2"/>
 894     </table:table-row>
 895     <table:table-row table:style-name="ro2">
 896      <table:table-cell table:number-columns-repeated="3"/>
 897     </table:table-row>
 898     <table:table-row table:style-name="ro3">
 899      <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string">
 900       <text:p>Result</text:p>
 901      </table:table-cell>
 902      <table:table-cell table:style-name="ce6" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 903       <text:p>TRUE</text:p>
 904      </table:table-cell>
 905      <table:table-cell/>
 906     </table:table-row>
 907     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 908      <table:table-cell table:number-columns-repeated="3"/>
 909     </table:table-row>
 910     <table:table-row table:style-name="ro4">
 911      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 912       <text:p>Sheet</text:p>
 913      </table:table-cell>
 914      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 915       <text:p>Result</text:p>
 916      </table:table-cell>
 917      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 918       <text:p>Description</text:p>
 919      </table:table-cell>
 920     </table:table-row>
 921     <table:table-row table:style-name="ro2">
 922      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 923       <text:p>1</text:p>
 924      </table:table-cell>
 925      <table:table-cell table:style-name="ce7" table:formula="of:=AND([Sheet2.C2:.C100])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 926       <text:p>TRUE</text:p>
 927      </table:table-cell>
 928      <table:table-cell office:value-type="string" calcext:value-type="string">
 929       <text:p>Simple CONCATENATE formulas with local references and values</text:p>
 930      </table:table-cell>
 931     </table:table-row>
 932     <table:table-row table:style-name="ro2" table:number-rows-repeated="30">
 933      <table:table-cell/>
 934      <table:table-cell table:style-name="ce8"/>
 935      <table:table-cell/>
 936     </table:table-row>
 937     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
 938      <table:table-cell table:number-columns-repeated="3"/>
 939     </table:table-row>
 940     <table:table-row table:style-name="ro2">
 941      <table:table-cell table:number-columns-repeated="3"/>
 942     </table:table-row>
 943     <calcext:conditional-formats>
 944      <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
 945       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
 946       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
 947       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
 948      </calcext:conditional-format>
 949      <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
 950       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
 951       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
 952       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
 953      </calcext:conditional-format>
 954     </calcext:conditional-formats>
 955    </table:table>
 956    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
 957     <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
 958     <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
 959     <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/>
 960     <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
 961     <table:table-column table:style-name="co6" table:default-cell-style-name="Default"/>
 962     <table:table-column table:style-name="co8" table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
 963     <table:table-column table:style-name="co9" table:default-cell-style-name="Default"/>
 964     <table:table-column table:style-name="co3" table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
 965     <table:table-column table:style-name="co10" table:default-cell-style-name="Default"/>
 966     <table:table-column table:style-name="co11" table:number-columns-repeated="6" table:default-cell-style-name="Default"/>
 967     <table:table-row table:style-name="ro5">
 968      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 969       <text:p>Function</text:p>
 970      </table:table-cell>
 971      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 972       <text:p>Expected</text:p>
 973      </table:table-cell>
 974      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 975       <text:p>Correct</text:p>
 976      </table:table-cell>
 977      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 978       <text:p>FunctionString</text:p>
 979      </table:table-cell>
 980      <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
 981       <text:p>Comment</text:p>
 982      </table:table-cell>
 983      <table:table-cell table:number-columns-repeated="3"/>
 984      <table:table-cell table:style-name="ce13" office:value-type="string" calcext:value-type="string">
 985       <text:p>Data </text:p>
 986      </table:table-cell>
 987      <table:table-cell table:style-name="ce14" table:number-columns-repeated="2"/>
 988      <table:table-cell/>
 989      <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
 990       <text:p>cat</text:p>
 991      </table:table-cell>
 992      <table:table-cell table:number-columns-repeated="6"/>
 993     </table:table-row>
 994     <table:table-row table:style-name="ro6">
 995      <table:table-cell table:formula="of:=CONCATENATE(&quot;Good &quot;;&quot;Morning &quot;;&quot;Mrs. &quot;;&quot;Doe&quot;)" office:value-type="string" office:string-value="Good Morning Mrs. Doe" calcext:value-type="string">
 996       <text:p>Good Morning Mrs. Doe</text:p>
 997      </table:table-cell>
 998      <table:table-cell office:value-type="string" calcext:value-type="string">
 999       <text:p>Good Morning Mrs. Doe</text:p>
1000      </table:table-cell>
1001      <table:table-cell table:style-name="ce11" table:formula="of:=[.A2]=[.B2]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1002       <text:p>TRUE</text:p>
1003      </table:table-cell>
1004      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=CONCATENATE(&quot;Good &quot;,&quot;Morning &quot;,&quot;Mrs. &quot;,&quot;Doe&quot;)" calcext:value-type="string">
1005       <text:p>=CONCATENATE(&quot;Good &quot;,&quot;Morning &quot;,&quot;Mrs. &quot;,&quot;Doe&quot;)</text:p>
1006      </table:table-cell>
1007      <table:table-cell table:number-columns-repeated="4"/>
1008      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1009       <text:p>brook trout</text:p>
1010      </table:table-cell>
1011      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1012       <text:p>Andreas</text:p>
1013      </table:table-cell>
1014      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1015       <text:p>Hauser</text:p>
1016      </table:table-cell>
1017      <table:table-cell/>
1018      <table:table-cell office:value-type="string" calcext:value-type="string">
1019       <text:p>dog</text:p>
1020      </table:table-cell>
1021      <table:table-cell table:number-columns-repeated="6"/>
1022     </table:table-row>
1023     <table:table-row table:style-name="ro7">
1024      <table:table-cell table:style-name="ce10" table:formula="of:=CONCATENATE(&quot;Stream population for &quot;; [.I2]; &quot; &quot;; [.I3]; &quot; is &quot;; [.I4]; &quot;/mile.&quot;)" office:value-type="string" office:string-value="Stream population for brook trout species is 32/mile." calcext:value-type="string">
1025       <text:p>Stream population for brook trout species is 32/mile.</text:p>
1026      </table:table-cell>
1027      <table:table-cell office:value-type="string" calcext:value-type="string">
1028       <text:p>Stream population for brook trout species is 32/mile.</text:p>
1029      </table:table-cell>
1030      <table:table-cell table:style-name="ce11" table:formula="of:=[.A3]=[.B3]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1031       <text:p>TRUE</text:p>
1032      </table:table-cell>
1033      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=CONCATENATE(&quot;Stream population for &quot;, I2, &quot; &quot;, I3, &quot; is &quot;, I4, &quot;/mile.&quot;)" calcext:value-type="string">
1034       <text:p>=CONCATENATE(&quot;Stream population for &quot;, I2, &quot; &quot;, I3, &quot; is &quot;, I4, &quot;/mile.&quot;)</text:p>
1035      </table:table-cell>
1036      <table:table-cell table:number-columns-repeated="4"/>
1037      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1038       <text:p>species</text:p>
1039      </table:table-cell>
1040      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1041       <text:p>Fourth</text:p>
1042      </table:table-cell>
1043      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1044       <text:p>Pine</text:p>
1045      </table:table-cell>
1046      <table:table-cell/>
1047      <table:table-cell office:value-type="string" calcext:value-type="string">
1048       <text:p>mouse</text:p>
1049      </table:table-cell>
1050      <table:table-cell table:number-columns-repeated="6"/>
1051     </table:table-row>
1052     <table:table-row table:style-name="ro2">
1053      <table:table-cell table:style-name="ce10" table:formula="of:=CONCATENATE([.I2]; &quot; &quot;; [.J2])" office:value-type="string" office:string-value="brook trout Andreas" calcext:value-type="string">
1054       <text:p>brook trout Andreas</text:p>
1055      </table:table-cell>
1056      <table:table-cell office:value-type="string" calcext:value-type="string">
1057       <text:p>brook trout Andreas</text:p>
1058      </table:table-cell>
1059      <table:table-cell table:style-name="ce11" table:formula="of:=[.A4]=[.B4]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1060       <text:p>TRUE</text:p>
1061      </table:table-cell>
1062      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=CONCATENATE(I2, &quot; &quot;, J2)" calcext:value-type="string">
1063       <text:p>=CONCATENATE(I2, &quot; &quot;, J2)</text:p>
1064      </table:table-cell>
1065      <table:table-cell table:number-columns-repeated="4"/>
1066      <table:table-cell table:style-name="ce10" office:value-type="float" office:value="32" calcext:value-type="float">
1067       <text:p>32</text:p>
1068      </table:table-cell>
1069      <table:table-cell table:style-name="ce14" table:number-columns-repeated="2"/>
1070      <table:table-cell/>
1071      <table:table-cell table:formula="of:=CONCATENATE([.M1:.M3])" office:value-type="string" office:string-value="" calcext:value-type="error">
1072       <text:p>#VALUE!</text:p>
1073      </table:table-cell>
1074      <table:table-cell office:value-type="string" calcext:value-type="string">
1075       <text:p>AOO 117662</text:p>
1076      </table:table-cell>
1077      <table:table-cell table:number-columns-repeated="5"/>
1078     </table:table-row>
1079     <table:table-row table:style-name="ro2">
1080      <table:table-cell table:style-name="ce10" table:formula="of:=CONCATENATE([.J2]; &quot;, &quot;; [.I2])" office:value-type="string" office:string-value="Andreas, brook trout" calcext:value-type="string">
1081       <text:p>Andreas, brook trout</text:p>
1082      </table:table-cell>
1083      <table:table-cell office:value-type="string" calcext:value-type="string">
1084       <text:p>Andreas, brook trout</text:p>
1085      </table:table-cell>
1086      <table:table-cell table:style-name="ce11" table:formula="of:=[.A5]=[.B5]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1087       <text:p>TRUE</text:p>
1088      </table:table-cell>
1089      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=CONCATENATE(J2, &quot;, &quot;, I2)" calcext:value-type="string">
1090       <text:p>=CONCATENATE(J2, &quot;, &quot;, I2)</text:p>
1091      </table:table-cell>
1092      <table:table-cell table:number-columns-repeated="4"/>
1093      <table:table-cell table:style-name="ce13" table:number-columns-repeated="2"/>
1094      <table:table-cell table:style-name="ce14"/>
1095      <table:table-cell table:number-columns-repeated="8"/>
1096     </table:table-row>
1097     <table:table-row table:style-name="ro2">
1098      <table:table-cell table:style-name="ce10" table:formula="of:=CONCATENATE([.J3]; &quot; &amp; &quot;; [.K3])" office:value-type="string" office:string-value="Fourth &amp; Pine" calcext:value-type="string">
1099       <text:p>Fourth &amp; Pine</text:p>
1100      </table:table-cell>
1101      <table:table-cell office:value-type="string" calcext:value-type="string">
1102       <text:p>Fourth &amp; Pine</text:p>
1103      </table:table-cell>
1104      <table:table-cell table:style-name="ce11" table:formula="of:=[.A6]=[.B6]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1105       <text:p>TRUE</text:p>
1106      </table:table-cell>
1107      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=CONCATENATE(J3, &quot; &amp; &quot;, K3)" calcext:value-type="string">
1108       <text:p>=CONCATENATE(J3, &quot; &amp; &quot;, K3)</text:p>
1109      </table:table-cell>
1110      <table:table-cell table:number-columns-repeated="5"/>
1111      <table:table-cell table:style-name="ce10"/>
1112      <table:table-cell table:style-name="ce14"/>
1113      <table:table-cell table:number-columns-repeated="8"/>
1114     </table:table-row>
1115     <table:table-row table:style-name="ro2">
1116      <table:table-cell table:formula="of:=CONCATENATE(TRANSPOSE(1))" office:value-type="string" office:string-value="1" calcext:value-type="string">
1117       <text:p>1</text:p>
1118      </table:table-cell>
1119      <table:table-cell office:value-type="string" calcext:value-type="string">
1120       <text:p>1</text:p>
1121      </table:table-cell>
1122      <table:table-cell table:style-name="ce11" table:formula="of:=[.A7]=[.B7]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1123       <text:p>TRUE</text:p>
1124      </table:table-cell>
1125      <table:table-cell table:style-name="ce12" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=CONCATENATE(TRANSPOSE(1))" calcext:value-type="string">
1126       <text:p>=CONCATENATE(TRANSPOSE(1))</text:p>
1127      </table:table-cell>
1128      <table:table-cell table:number-columns-repeated="5"/>
1129      <table:table-cell table:style-name="ce10"/>
1130      <table:table-cell table:style-name="ce14"/>
1131      <table:table-cell table:number-columns-repeated="8"/>
1132     </table:table-row>
1133     <table:table-row table:style-name="ro2">
1134      <table:table-cell table:number-columns-repeated="2"/>
1135      <table:table-cell table:style-name="ce11"/>
1136      <table:table-cell table:style-name="ce12"/>
1137      <table:table-cell table:number-columns-repeated="5"/>
1138      <table:table-cell table:style-name="ce10"/>
1139      <table:table-cell table:style-name="ce14"/>
1140      <table:table-cell table:number-columns-repeated="8"/>
1141     </table:table-row>
1142     <table:table-row table:style-name="ro2">
1143      <table:table-cell table:number-columns-repeated="2"/>
1144      <table:table-cell table:style-name="ce11"/>
1145      <table:table-cell table:style-name="ce12"/>
1146      <table:table-cell table:number-columns-repeated="5"/>
1147      <table:table-cell table:style-name="ce10"/>
1148      <table:table-cell table:number-columns-repeated="9"/>
1149     </table:table-row>
1150     <table:table-row table:style-name="ro2" table:number-rows-repeated="28">
1151      <table:table-cell table:number-columns-repeated="2"/>
1152      <table:table-cell table:style-name="ce11"/>
1153      <table:table-cell table:style-name="ce12"/>
1154      <table:table-cell table:number-columns-repeated="6"/>
1155      <table:table-cell table:style-name="ce10"/>
1156      <table:table-cell table:number-columns-repeated="8"/>
1157     </table:table-row>
1158     <table:table-row table:style-name="ro2">
1159      <table:table-cell table:number-columns-repeated="2"/>
1160      <table:table-cell table:style-name="ce11"/>
1161      <table:table-cell table:style-name="ce12"/>
1162      <table:table-cell table:number-columns-repeated="5"/>
1163      <table:table-cell table:style-name="ce15"/>
1164      <table:table-cell table:style-name="ce10"/>
1165      <table:table-cell table:number-columns-repeated="8"/>
1166     </table:table-row>
1167     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1168      <table:table-cell table:number-columns-repeated="2"/>
1169      <table:table-cell table:style-name="ce11"/>
1170      <table:table-cell table:style-name="ce12"/>
1171      <table:table-cell table:number-columns-repeated="6"/>
1172      <table:table-cell table:style-name="ce10"/>
1173      <table:table-cell table:number-columns-repeated="8"/>
1174     </table:table-row>
1175     <table:table-row table:style-name="ro2">
1176      <table:table-cell table:number-columns-repeated="2"/>
1177      <table:table-cell table:style-name="ce11"/>
1178      <table:table-cell table:style-name="ce12"/>
1179      <table:table-cell table:number-columns-repeated="5"/>
1180      <table:table-cell table:style-name="ce15"/>
1181      <table:table-cell table:style-name="ce10"/>
1182      <table:table-cell table:number-columns-repeated="8"/>
1183     </table:table-row>
1184     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1185      <table:table-cell table:number-columns-repeated="2"/>
1186      <table:table-cell table:style-name="ce11"/>
1187      <table:table-cell table:style-name="ce12"/>
1188      <table:table-cell table:number-columns-repeated="6"/>
1189      <table:table-cell table:style-name="ce10"/>
1190      <table:table-cell table:number-columns-repeated="8"/>
1191     </table:table-row>
1192     <table:table-row table:style-name="ro2">
1193      <table:table-cell table:number-columns-repeated="2"/>
1194      <table:table-cell table:style-name="ce11"/>
1195      <table:table-cell table:style-name="ce12"/>
1196      <table:table-cell table:number-columns-repeated="5"/>
1197      <table:table-cell table:style-name="ce15"/>
1198      <table:table-cell table:style-name="ce10"/>
1199      <table:table-cell table:number-columns-repeated="8"/>
1200     </table:table-row>
1201     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1202      <table:table-cell table:number-columns-repeated="2"/>
1203      <table:table-cell table:style-name="ce11"/>
1204      <table:table-cell table:style-name="ce12"/>
1205      <table:table-cell table:number-columns-repeated="6"/>
1206      <table:table-cell table:style-name="ce10"/>
1207      <table:table-cell table:number-columns-repeated="8"/>
1208     </table:table-row>
1209     <table:table-row table:style-name="ro2">
1210      <table:table-cell table:number-columns-repeated="2"/>
1211      <table:table-cell table:style-name="ce11"/>
1212      <table:table-cell table:style-name="ce12"/>
1213      <table:table-cell table:number-columns-repeated="5"/>
1214      <table:table-cell table:style-name="ce15"/>
1215      <table:table-cell table:style-name="ce10"/>
1216      <table:table-cell table:number-columns-repeated="8"/>
1217     </table:table-row>
1218     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1219      <table:table-cell table:number-columns-repeated="2"/>
1220      <table:table-cell table:style-name="ce11"/>
1221      <table:table-cell table:style-name="ce12"/>
1222      <table:table-cell table:number-columns-repeated="6"/>
1223      <table:table-cell table:style-name="ce10"/>
1224      <table:table-cell table:number-columns-repeated="8"/>
1225     </table:table-row>
1226     <table:table-row table:style-name="ro2">
1227      <table:table-cell table:number-columns-repeated="2"/>
1228      <table:table-cell table:style-name="ce11"/>
1229      <table:table-cell table:style-name="ce12"/>
1230      <table:table-cell table:number-columns-repeated="5"/>
1231      <table:table-cell table:style-name="ce15"/>
1232      <table:table-cell table:style-name="ce10"/>
1233      <table:table-cell table:number-columns-repeated="8"/>
1234     </table:table-row>
1235     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1236      <table:table-cell table:number-columns-repeated="2"/>
1237      <table:table-cell table:style-name="ce11"/>
1238      <table:table-cell table:style-name="ce12"/>
1239      <table:table-cell table:number-columns-repeated="6"/>
1240      <table:table-cell table:style-name="ce10"/>
1241      <table:table-cell table:number-columns-repeated="8"/>
1242     </table:table-row>
1243     <table:table-row table:style-name="ro2">
1244      <table:table-cell table:number-columns-repeated="2"/>
1245      <table:table-cell table:style-name="ce11"/>
1246      <table:table-cell table:style-name="ce12"/>
1247      <table:table-cell table:number-columns-repeated="5"/>
1248      <table:table-cell table:style-name="ce15"/>
1249      <table:table-cell table:style-name="ce10"/>
1250      <table:table-cell table:number-columns-repeated="8"/>
1251     </table:table-row>
1252     <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
1253      <table:table-cell table:number-columns-repeated="2"/>
1254      <table:table-cell table:style-name="ce11"/>
1255      <table:table-cell table:style-name="ce12"/>
1256      <table:table-cell table:number-columns-repeated="6"/>
1257      <table:table-cell table:style-name="ce10"/>
1258      <table:table-cell table:number-columns-repeated="8"/>
1259     </table:table-row>
1260     <table:table-row table:style-name="ro2">
1261      <table:table-cell table:number-columns-repeated="2"/>
1262      <table:table-cell table:style-name="ce11"/>
1263      <table:table-cell table:style-name="ce12"/>
1264      <table:table-cell table:number-columns-repeated="5"/>
1265      <table:table-cell table:style-name="ce15"/>
1266      <table:table-cell table:style-name="ce10"/>
1267      <table:table-cell table:number-columns-repeated="8"/>
1268     </table:table-row>
1269     <table:table-row table:style-name="ro2" table:number-rows-repeated="202">
1270      <table:table-cell table:number-columns-repeated="2"/>
1271      <table:table-cell table:style-name="ce11"/>
1272      <table:table-cell table:style-name="ce12"/>
1273      <table:table-cell table:number-columns-repeated="6"/>
1274      <table:table-cell table:style-name="ce10"/>
1275      <table:table-cell table:number-columns-repeated="8"/>
1276     </table:table-row>
1277     <table:table-row table:style-name="ro2" table:number-rows-repeated="4">
1278      <table:table-cell table:number-columns-repeated="2"/>
1279      <table:table-cell table:style-name="ce11"/>
1280      <table:table-cell table:style-name="ce12"/>
1281      <table:table-cell table:number-columns-repeated="15"/>
1282     </table:table-row>
1283     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048313">
1284      <table:table-cell table:number-columns-repeated="19"/>
1285     </table:table-row>
1286     <table:table-row table:style-name="ro2">
1287      <table:table-cell table:number-columns-repeated="19"/>
1288     </table:table-row>
1289     <calcext:conditional-formats>
1290      <calcext:conditional-format calcext:target-range-address="Sheet2.C2:Sheet2.C262">
1291       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1292       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1293       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1294      </calcext:conditional-format>
1295     </calcext:conditional-formats>
1296    </table:table>
1297    <table:table table:name="&apos;file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/code.fods/clean.fods/clean.fods/clean.fods/clean.fods/char.fods/char.fods/base.fods/base.fods/asc.fods/arabic.fods/vlookup.fods/hlookup.fods/dstdevp.fods/dstdevp.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1298     <table:table-source xlink:type="simple" xlink:href="code.fods/clean.fods/clean.fods/clean.fods/clean.fods/char.fods/char.fods/base.fods/base.fods/asc.fods/arabic.fods/vlookup.fods/hlookup.fods/dstdevp.fods/dstdevp.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1299     <table:table-column table:number-columns-repeated="8"/>
1300     <table:table-row table:number-rows-repeated="2">
1301      <table:table-cell table:number-columns-repeated="8"/>
1302     </table:table-row>
1303     <table:table-row>
1304      <table:table-cell table:number-columns-repeated="7"/>
1305      <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4">
1306       <text:p>4</text:p>
1307      </table:table-cell>
1308     </table:table-row>
1309    </table:table>
1310    <table:named-expressions>
1311     <table:named-range table:name="column1" table:base-cell-address="$Sheet1.$A$2" table:cell-range-address="$Sheet2.$AF$2:.$AF$5"/>
1312     <table:named-range table:name="table" table:base-cell-address="$Sheet1.$A$2" table:cell-range-address="$Sheet2.$AC$2:.$AD$5"/>
1313    </table:named-expressions>
1314   </office:spreadsheet>
1315  </office:body>
1316 </office:document>