Quelle  lookup_target.fods   Sprache: unbekannt

<?xml version="1.0" encoding="UTF-8"?>

<office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta: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:rpt="http://openoffice.org/2005/report" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d: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:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:drawooo="http://openoffice.org/2010/draw" 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: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:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:css3t="http://www.w3.org/TR/css3-text/" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" office:version="1.4" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
 <office:meta>
  <meta:generator>LibreOfficeDev/26.2.0.0.alpha0$Windows_X86_64 LibreOffice_project/36d2b5d4cec0ac3408b33a1b3e938a5ce9daf897
  </meta:generator>
  <meta:document-statistic meta:table-count="1" meta:object-count="0" meta:cell-count="130"/>
 </office:meta>
 <office:settings>
  <config:config-item-set config:name="ooo:view-settings">
   <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item>
   <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item>
   <config:config-item config:name="VisibleAreaWidth" config:type="int">31186</config:config-item>
   <config:config-item config:name="VisibleAreaHeight" config:type="int">13801</config:config-item>
   <config:config-item-map-indexed config:name="Views">
    <config:config-item-map-entry>
     <config:config-item config:name="ViewId" config:type="string">view1</config:config-item>
     <config:config-item-map-named config:name="Tables">
      <config:config-item-map-entry config:name="LOOKUP_test">
       <config:config-item config:name="CursorPositionX" config:type="int">1</config:config-item>
       <config:config-item config:name="CursorPositionY" config:type="int">7</config:config-item>
       <config:config-item config:name="ActiveSplitRange" config:type="short">2</config:config-item>
       <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item>
       <config:config-item config:name="PositionRight" config:type="int">0</config:config-item>
       <config:config-item config:name="PositionTop" config:type="int">0</config:config-item>
       <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item>
       <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
       <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item>
       <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
       <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
       <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item>
       <config:config-item config:name="LegacySingleLineFontwork" config:type="boolean">false</config:config-item>
       <config:config-item config:name="ConnectorUseSnapRect" config:type="boolean">false</config:config-item>
       <config:config-item config:name="IgnoreBreakAfterMultilineField" config:type="boolean">false</config:config-item>
      </config:config-item-map-entry>
     </config:config-item-map-named>
     <config:config-item config:name="ActiveTable" config:type="string">LOOKUP_test</config:config-item>
     <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1386</config:config-item>
     <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
     <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item>
     <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
     <config:config-item config:name="ShowPageBreakPreview" config:type="boolean">false</config:config-item>
     <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item>
     <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item>
     <config:config-item config:name="ShowNoteAuthor" config:type="boolean">true</config:config-item>
     <config:config-item config:name="ShowFormulasMarks" config:type="boolean">false</config:config-item>
     <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
     <config:config-item config:name="GridColor" config:type="int">12632256</config:config-item>
     <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item>
     <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item>
     <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item>
     <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item>
     <config:config-item config:name="IsValueHighlightingEnabled" config:type="boolean">false</config:config-item>
     <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
     <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
     <config:config-item config:name="RasterResolutionX" config:type="int">1000</config:config-item>
     <config:config-item config:name="RasterResolutionY" config:type="int">1000</config:config-item>
     <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item>
     <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item>
     <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean">true</config:config-item>
     <config:config-item config:name="FormulaBarHeight" config:type="short">1</config:config-item>
     <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item>
     <config:config-item config:name="LegacySingleLineFontwork" config:type="boolean">false</config:config-item>
     <config:config-item config:name="ConnectorUseSnapRect" config:type="boolean">false</config:config-item>
     <config:config-item config:name="IgnoreBreakAfterMultilineField" config:type="boolean">false</config:config-item>
    </config:config-item-map-entry>
   </config:config-item-map-indexed>
  </config:config-item-set>
  <config:config-item-set config:name="ooo:configuration-settings">
   <config:config-item config:name="AllowPrintJobCancel" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ApplyUserData" config:type="boolean">true</config:config-item>
   <config:config-item config:name="AutoCalculate" config:type="boolean">true</config:config-item>
   <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item>
   <config:config-item config:name="EmbedAsianScriptFonts" config:type="boolean">true</config:config-item>
   <config:config-item config:name="EmbedComplexScriptFonts" config:type="boolean">true</config:config-item>
   <config:config-item config:name="EmbedFonts" config:type="boolean">false</config:config-item>
   <config:config-item config:name="EmbedLatinScriptFonts" config:type="boolean">true</config:config-item>
   <config:config-item config:name="EmbedOnlyUsedFonts" config:type="boolean">false</config:config-item>
   <config:config-item-map-indexed config:name="ForbiddenCharacters">
    <config:config-item-map-entry>
     <config:config-item config:name="Language" config:type="string">de</config:config-item>
     <config:config-item config:name="Country" config:type="string">DE</config:config-item>
     <config:config-item config:name="Variant" config:type="string"/>
     <config:config-item config:name="BeginLine" config:type="string"/>
     <config:config-item config:name="EndLine" config:type="string"/>
    </config:config-item-map-entry>
    <config:config-item-map-entry>
     <config:config-item config:name="Language" config:type="string">en</config:config-item>
     <config:config-item config:name="Country" config:type="string">US</config:config-item>
     <config:config-item config:name="Variant" config:type="string"/>
     <config:config-item config:name="BeginLine" config:type="string"/>
     <config:config-item config:name="EndLine" config:type="string"/>
    </config:config-item-map-entry>
   </config:config-item-map-indexed>
   <config:config-item config:name="GridColor" config:type="int">12632256</config:config-item>
   <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item>
   <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ImagePreferredDPI" config:type="int">0</config:config-item>
   <config:config-item config:name="IsDocumentShared" config:type="boolean">false</config:config-item>
   <config:config-item config:name="IsKernAsianPunctuation" config:type="boolean">false</config:config-item>
   <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item>
   <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean">true</config:config-item>
   <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
   <config:config-item config:name="LinkUpdateMode" config:type="short">3</config:config-item>
   <config:config-item config:name="LoadReadonly" config:type="boolean">false</config:config-item>
   <config:config-item config:name="PrinterPaperFromSetup" config:type="boolean">false</config:config-item>
   <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
   <config:config-item config:name="RasterResolutionX" config:type="int">1000</config:config-item>
   <config:config-item config:name="RasterResolutionY" config:type="int">1000</config:config-item>
   <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item>
   <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item>
   <config:config-item config:name="SaveThumbnail" config:type="boolean">true</config:config-item>
   <config:config-item config:name="SaveVersionOnClose" config:type="boolean">false</config:config-item>
   <config:config-item config:name="ShowFormulasMarks" config:type="boolean">false</config:config-item>
   <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ShowNoteAuthor" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item>
   <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item>
   <config:config-item config:name="SyntaxStringRef" config:type="short">7</config:config-item>
   <config:config-item config:name="UpdateFromTemplate" config:type="boolean">true</config:config-item>
   <config:config-item-map-named config:name="ScriptConfiguration">
    <config:config-item-map-entry config:name="LOOKUP_test">
     <config:config-item config:name="CodeName" config:type="string">Sheet1</config:config-item>
    </config:config-item-map-entry>
   </config:config-item-map-named>
  </config:config-item-set>
 </office:settings>
 <office:scripts>
  <office:script script:language="ooo:Basic">
   <ooo:libraries xmlns:ooo="http://openoffice.org/2004/office" xmlns:xlink="http://www.w3.org/1999/xlink">
    <ooo:library-embedded ooo:name="Standard"/>
   </ooo:libraries>
  </office:script>
 </office:scripts>
 <office:font-face-decls>
  <style:font-face style:name="Calibri" svg:font-family="Calibri" style:font-family-generic="swiss" style:font-pitch="variable"/>
  <style:font-face style:name="Droid Sans Devanagari" svg:font-family="'Droid Sans Devanagari'" style:font-family-generic="system" style:font-pitch="variable"/>
  <style:font-face style:name="Droid Sans Fallback" svg:font-family="'Droid Sans Fallback'" style:font-family-generic="system" style:font-pitch="variable"/>
  <style:font-face style:name="Liberation Sans" svg:font-family="'Liberation Sans'" style:font-family-generic="swiss" style:font-pitch="variable"/>
  <style:font-face style:name="Lucida Sans" svg:font-family="'Lucida Sans'" style:font-family-generic="system" style:font-pitch="variable"/>
  <style:font-face style:name="Microsoft YaHei" svg:font-family="'Microsoft YaHei'" style:font-family-generic="system" style:font-pitch="variable"/>
 </office:font-face-decls>
 <office:styles>
  <style:default-style style:family="table-cell">
   <style:paragraph-properties style:tab-stop-distance="1.25cm"/>
   <style:text-properties style:font-name="Liberation Sans" fo:font-size="10pt" fo:language="en" fo:country="US" style:font-name-asian="Microsoft YaHei" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="Lucida Sans" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN"/>
  </style:default-style>
  <style:default-style style:family="graphic">
   <style:graphic-properties svg:stroke-color="#3465a4" draw:fill-color="#729fcf" fo:wrap-option="no-wrap" draw:shadow-offset-x="0.3cm" draw:shadow-offset-y="0.3cm" style:writing-mode="page"/>
   <style:paragraph-properties style:text-autospace="ideograph-alpha" style:punctuation-wrap="simple" style:line-break="strict" loext:tab-stop-distance="0cm" style:writing-mode="page" style:font-independent-line-spacing="false">
    <style:tab-stops/>
   </style:paragraph-properties>
   <style:text-properties style:use-window-font-color="true" loext:opacity="0%" fo:font-family="'Liberation Serif'" style:font-family-generic="roman" style:font-pitch="variable" fo:font-size="12pt" fo:language="en" fo:country="US" style:letter-kerning="true" style:font-family-asian="'Segoe UI'" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-size-asian="12pt" style:language-asian="zh" style:country-asian="CN" style:font-family-complex="Tahoma" style:font-family-generic-complex="system" style:font-pitch-complex="variable" style:font-size-complex="12pt" style:language-complex="hi" style:country-complex="IN"/>
  </style:default-style>
  <style:style style:name="Default" style:family="graphic"/>
  <style:style style:name="Note" style:family="graphic" style:parent-style-name="Default">
   <style:graphic-properties draw:stroke="solid" draw:marker-start="Arrowheads_20_1" draw:marker-start-width="0.2cm" draw:marker-start-center="false" draw:fill="solid" draw:fill-color="#ffffc0" draw:auto-grow-height="true" draw:auto-grow-width="false" fo:padding-top="0.1cm" fo:padding-bottom="0.1cm" fo:padding-left="0.1cm" fo:padding-right="0.1cm" draw:shadow="visible" draw:shadow-offset-x="0.1cm" draw:shadow-offset-y="0.1cm"/>
   <style:text-properties style:font-name="Liberation Sans" fo:font-family="'Liberation Sans'" style:font-family-generic="swiss" style:font-pitch="variable" fo:font-size="10pt" style:font-name-asian="Microsoft YaHei" style:font-family-asian="'Microsoft YaHei'" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-size-asian="10pt" style:font-name-complex="Lucida Sans" style:font-family-complex="'Lucida Sans'" style:font-family-generic-complex="system" style:font-pitch-complex="variable" style:font-size-complex="10pt"/>
  </style:style>
  <number:number-style style:name="N0">
   <number:number number:min-integer-digits="1"/>
  </number:number-style>
  <number:currency-style style:name="N114P0" style:volatile="true">
   <number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
   <number:text> </number:text>
   <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol>
  </number:currency-style>
  <number:currency-style style:name="N114">
   <style:text-properties fo:color="#ff0000"/>
   <number:text>-</number:text>
   <number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
   <number:text> </number:text>
   <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol>
   <style:map style:condition="value()>=0" style:apply-style-name="N114P0"/>
  </number:currency-style>
  <style:style style:name="Default" style:family="table-cell"/>
  <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:font-size="24pt" fo:font-style="normal" fo:font-weight="bold" style:font-size-asian="24pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-size-complex="24pt" style:font-style-complex="normal" style:font-weight-complex="bold"/>
  </style:style>
  <style:style style:name="Heading_20_1" style:display-name="Heading 1" style:family="table-cell" style:parent-style-name="Heading">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:font-size="18pt" style:font-size-asian="18pt" style:font-size-complex="18pt"/>
  </style:style>
  <style:style style:name="Heading_20_2" style:display-name="Heading 2" style:family="table-cell" style:parent-style-name="Heading">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:font-size="12pt" style:font-size-asian="12pt" style:font-size-complex="12pt"/>
  </style:style>
  <style:style style:name="Text" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
  </style:style>
  <style:style style:name="Note" style:family="table-cell" style:parent-style-name="Text">
   <style:table-cell-properties fo:background-color="#ffffcc" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:wrap-option="no-wrap" fo:border="0.74pt solid #808080" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#333333"/>
  </style:style>
  <style:style style:name="Footnote" style:family="table-cell" style:parent-style-name="Text">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#808080" fo:font-style="italic" style:font-style-asian="italic" style:font-style-complex="italic"/>
  </style:style>
  <style:style style:name="Hyperlink" style:family="table-cell" style:parent-style-name="Text">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#0000ee" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="#0000ee"/>
  </style:style>
  <style:style style:name="Status" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
  </style:style>
  <style:style style:name="Good" style:family="table-cell" style:parent-style-name="Status">
   <style:table-cell-properties fo:background-color="#ccffcc" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#006600"/>
  </style:style>
  <style:style style:name="Neutral" style:family="table-cell" style:parent-style-name="Status">
   <style:table-cell-properties fo:background-color="#ffffcc" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#996600"/>
  </style:style>
  <style:style style:name="Bad" style:family="table-cell" style:parent-style-name="Status">
   <style:table-cell-properties fo:background-color="#ffcccc" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#cc0000"/>
  </style:style>
  <style:style style:name="Warning" style:family="table-cell" style:parent-style-name="Status">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#cc0000"/>
  </style:style>
  <style:style style:name="Error" style:family="table-cell" style:parent-style-name="Status">
   <style:table-cell-properties fo:background-color="#cc0000" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#ffffff" fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
  </style:style>
  <style:style style:name="Accent" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
  </style:style>
  <style:style style:name="Accent_20_1" style:display-name="Accent 1" style:family="table-cell" style:parent-style-name="Accent">
   <style:table-cell-properties fo:background-color="#000000" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#ffffff"/>
  </style:style>
  <style:style style:name="Accent_20_2" style:display-name="Accent 2" style:family="table-cell" style:parent-style-name="Accent">
   <style:table-cell-properties fo:background-color="#808080" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <style:text-properties fo:color="#ffffff"/>
  </style:style>
  <style:style style:name="Accent_20_3" style:display-name="Accent 3" style:family="table-cell" style:parent-style-name="Accent">
   <style:table-cell-properties fo:background-color="#dddddd" fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
  </style:style>
  <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="no-wrap" style:shrink-to-fit="false"/>
   <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" style:font-style-asian="italic" style:font-weight-asian="bold" style:font-style-complex="italic" style:font-weight-complex="bold"/>
  </style:style>
  <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:background-color="#ff3333"/>
  </style:style>
  <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:background-color="#99ff66"/>
  </style:style>
  <draw:marker draw:name="Arrowheads_20_1" draw:display-name="Arrowheads 1" svg:viewBox="0 0 20 30" svg:d="M10 0l-10 30h20z"/>
  <loext:theme loext:name="Office">
   <loext:theme-colors loext:name="LibreOffice">
    <loext:color loext:name="dark1" loext:color="#000000"/>
    <loext:color loext:name="light1" loext:color="#ffffff"/>
    <loext:color loext:name="dark2" loext:color="#000000"/>
    <loext:color loext:name="light2" loext:color="#ffffff"/>
    <loext:color loext:name="accent1" loext:color="#18a303"/>
    <loext:color loext:name="accent2" loext:color="#0369a3"/>
    <loext:color loext:name="accent3" loext:color="#a33e03"/>
    <loext:color loext:name="accent4" loext:color="#8e03a3"/>
    <loext:color loext:name="accent5" loext:color="#c99c00"/>
    <loext:color loext:name="accent6" loext:color="#c9211e"/>
    <loext:color loext:name="hyperlink" loext:color="#0000ee"/>
    <loext:color loext:name="followed-hyperlink" loext:color="#551a8b"/>
   </loext:theme-colors>
  </loext:theme>
 </office:styles>
 <office:automatic-styles>
  <style:style style:name="co1" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="4.972cm"/>
  </style:style>
  <style:style style:name="co2" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="3.544cm"/>
  </style:style>
  <style:style style:name="co3" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="2.618cm"/>
  </style:style>
  <style:style style:name="co4" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="8.024cm"/>
  </style:style>
  <style:style style:name="co5" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="12.028cm"/>
  </style:style>
  <style:style style:name="co6" style:family="table-column">
   <style:table-column-properties fo:break-before="auto" style:column-width="2.258cm"/>
  </style:style>
  <style:style style:name="ro1" style:family="table-row">
   <style:table-row-properties style:row-height="2.06cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ro2" style:family="table-row">
   <style:table-row-properties style:row-height="0.452cm" fo:break-before="auto" style:use-optimal-row-height="true"/>
  </style:style>
  <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
   <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
  </style:style>
  <number:number-style style:name="N2">
   <number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1"/>
  </number:number-style>
  <number:boolean-style style:name="N99">
   <number:boolean/>
  </number:boolean-style>
  <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
  <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:vertical-align="top"/>
   <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"/>
  </style:style>
  <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
  </style:style>
  <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default">
   <style:text-properties style:use-window-font-color="true" fo:font-size="10pt" style:font-size-asian="10pt" style:font-size-complex="10pt"/>
  </style:style>
  <style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default">
   <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Calibri" 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-name-asian="Droid Sans Fallback" 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-name-complex="Droid Sans Devanagari" 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"/>
  </style:style>
  <style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
   <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Calibri" 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-name-asian="Droid Sans Fallback" 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-name-complex="Droid Sans Devanagari" 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"/>
  </style:style>
  <style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
  </style:style>
  <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0"/>
  <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:vertical-align="middle"/>
   <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"/>
  </style:style>
  <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" style:text-align-source="fix" style:repeat-content="false" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" style:text-align-source="fix" style:repeat-content="false" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" style:text-align-source="fix" style:repeat-content="false" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce45" style:family="table-cell" style:parent-style-name="Default">
   <style:text-properties fo:language="en" fo:country="US"/>
  </style:style>
  <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
  </style:style>
  <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default">
   <style:table-cell-properties fo:wrap-option="wrap" fo:border="0.74pt solid #ff0000"/>
   <style:text-properties fo:color="#3333ff" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-weight="bold" style:font-size-asian="10pt" style:font-size-complex="10pt"/>
  </style:style>
  <style:style style:name="ce54" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0">
   <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
   <style:table-cell-properties fo:border-bottom="0.74pt solid #000000" style:text-align-source="fix" style:repeat-content="false" fo:border-left="none" fo:border-right="none" fo:border-top="none"/>
   <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
   <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="LOOKUP_test.C1"/>
   <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="LOOKUP_test.C1"/>
  </style:style>
  <style:style style:name="ta_extref" style:family="table">
   <style:table-properties table:display="false"/>
  </style:style>
  <style:page-layout style:name="pm1">
   <style:page-layout-properties style:writing-mode="lr-tb"/>
   <style:header-style>
    <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm" fo:margin-bottom="0.25cm"/>
   </style:header-style>
   <style:footer-style>
    <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm" fo:margin-top="0.25cm"/>
   </style:footer-style>
  </style:page-layout>
  <style:page-layout style:name="pm2">
   <style:page-layout-properties style:writing-mode="lr-tb"/>
   <style:header-style>
    <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm" fo:margin-bottom="0.25cm" fo:border="1.5pt solid #000000" fo:padding="0.018cm" fo:background-color="#c0c0c0">
     <style:background-image/>
    </style:header-footer-properties>
   </style:header-style>
   <style:footer-style>
    <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm" fo:margin-top="0.25cm" fo:border="1.5pt solid #000000" fo:padding="0.018cm" fo:background-color="#c0c0c0">
     <style:background-image/>
    </style:header-footer-properties>
   </style:footer-style>
  </style:page-layout>
 </office:automatic-styles>
 <office:master-styles>
  <style:master-page style:name="Default" style:page-layout-name="pm1">
   <style:header>
    <text:p><text:sheet-name>???</text:sheet-name></text:p>
   </style:header>
   <style:header-left style:display="false"/>
   <style:header-first style:display="false"/>
   <style:footer style:display="false">
    <text:p>Page <text:page-number>1</text:page-number></text:p>
   </style:footer>
   <style:footer-left style:display="false"/>
   <style:footer-first style:display="false"/>
  </style:master-page>
  <style:master-page style:name="Report" style:page-layout-name="pm2">
   <style:header>
    <style:region-left>
     <text:p><text:sheet-name>???</text:sheet-name><text:s/>(<text:title>???</text:title>)</text:p>
    </style:region-left>
    <style:region-right>
     <text:p><text:date style:data-style-name="N2" text:date-value="2025-08-04">00.00.0000</text:date>, <text:time style:data-style-name="N2" text:time-value="00:37:35.676817400">00:00:00</text:time></text:p>
    </style:region-right>
   </style:header>
   <style:header-left style:display="false"/>
   <style:header-first style:display="false"/>
   <style:footer>
    <text:p>Page <text:page-number>1</text:page-number><text:s/>/ <text:page-count>99</text:page-count></text:p>
   </style:footer>
   <style:footer-left style:display="false"/>
   <style:footer-first style:display="false"/>
  </style:master-page>
 </office:master-styles>
 <office:body>
  <office:spreadsheet>
   <table:calculation-settings table:automatic-find-labels="false" table:use-regular-expressions="false" table:use-wildcards="true"/>
   <table:table table:name="LOOKUP_test" table:style-name="ta1">
    <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
    <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
    <table:table-column table:style-name="co3" table:default-cell-style-name="ce25"/>
    <table:table-column table:style-name="co4" table:default-cell-style-name="ce25"/>
    <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
    <table:table-row table:style-name="ro1">
     <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
      <text:p>LOOKUP function</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce11" office:value-type="string" calcext:value-type="string">
      <text:p>test summary</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce17" table:formula="of:=AND([.C4:.C27])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string">
      <text:p>This test contains references to the sheet “Data” in file “lookup_source.fods”. Make sure the files “lookup_source.fods” and “lookup_target.fods” are placed in the same directory.</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.C1])" office:value-type="string" office:string-value="=AND(C4:C27)" calcext:value-type="string">
      <text:p>=AND(C4:C27)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce35" table:number-columns-repeated="5"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce35" office:value-type="string" calcext:value-type="string">
      <text:p>Function</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce35" office:value-type="string" calcext:value-type="string">
      <text:p>Expected</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce35" office:value-type="string" calcext:value-type="string">
      <text:p>Correct</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce35" office:value-type="string" calcext:value-type="string">
      <text:p>Comment</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce35" office:value-type="string" calcext:value-type="string">
      <text:p>FunctionString</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce37" table:formula="of:=LOOKUP(0;['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C8])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A4]);ISNA([.B4]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion smaller than smallest key</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=LOOKUP(0;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)" calcext:value-type="string">
      <text:p>=LOOKUP(0;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce38" table:formula="of:=LOOKUP(5;['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C8])" office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A5]=[.B5]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce54" office:value-type="string" calcext:value-type="string">
      <text:p>criterion between keys, take lower</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=LOOKUP(5;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)" calcext:value-type="string">
      <text:p>=LOOKUP(5;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce38" table:formula="of:=LOOKUP(10;['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C8])" office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A6]=[.B6]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>exact <text:s/>match</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=LOOKUP(10;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)" calcext:value-type="string">
      <text:p>=LOOKUP(10;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce38" table:formula="of:=LOOKUP("A";['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C8])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A7]);ISNA([.B7]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion text, but match is number</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=LOOKUP("A";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)" calcext:value-type="string">
      <text:p>=LOOKUP("A";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce38" table:formula="of:=LOOKUP("D";['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C8])" office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A8]=[.B8]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>two exact matches, take upper</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=LOOKUP("D";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)" calcext:value-type="string">
      <text:p>=LOOKUP("D";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce39" table:formula="of:=LOOKUP("W";['lookup_source.fods'#$Data.A3:.A8];['lookup_source.fods'#$Data.C3:.C4])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce40" table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce14" table:formula="of:=AND(ISERROR([.A9]);ISNA([.B9]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce42" office:value-type="string" calcext:value-type="string">
      <text:p>external result vector is not expanded</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce40" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=LOOKUP("W";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C4)" calcext:value-type="string">
      <text:p>=LOOKUP("W";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C4)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce38" table:formula="of:=LOOKUP(0;['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.G13])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A10]);ISNA([.A10]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion smaller than smallest key</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=LOOKUP(0;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)" calcext:value-type="string">
      <text:p>=LOOKUP(0;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP(5;['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.G13])" office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A11]=[.B11]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce54" office:value-type="string" calcext:value-type="string">
      <text:p>criterion between keys, take lower</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=LOOKUP(5;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)" calcext:value-type="string">
      <text:p>=LOOKUP(5;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP(10;['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.G13])" office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A12]=[.B12]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>exact <text:s/>match</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=LOOKUP(10;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)" calcext:value-type="string">
      <text:p>=LOOKUP(10;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP("A";['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.G13])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A13]);ISNA([.B13]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion text, but match is number</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=LOOKUP("A";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)" calcext:value-type="string">
      <text:p>=LOOKUP("A";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP("D";['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.G13])" office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A14]=[.B14]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>two exact matches, take upper</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=LOOKUP("D";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)" calcext:value-type="string">
      <text:p>=LOOKUP("D";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:style-name="ce40" table:formula="of:=LOOKUP("W";['lookup_source.fods'#$Data.B11:.G11];['lookup_source.fods'#$Data.B13:.C13])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce40" table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce14" table:formula="of:=AND(ISERROR([.A15]);ISNA([.B15]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce42" office:value-type="string" calcext:value-type="string">
      <text:p>external result vector is not expanded</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce40" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=LOOKUP("W";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:C13)" calcext:value-type="string">
      <text:p>=LOOKUP("W";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:C13)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP(0;['lookup_source.fods'#$Data.A17:.A22];['lookup_source.fods'#$Data.D16:.I16])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A16]);ISNA([.B16]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion smaller than smallest key</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=LOOKUP(0;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)" calcext:value-type="string">
      <text:p>=LOOKUP(0;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP(5;['lookup_source.fods'#$Data.A17:.A22];['lookup_source.fods'#$Data.D16:.I16])" office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="11" calcext:value-type="float">
      <text:p>11</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A17]=[.B17]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce54" office:value-type="string" calcext:value-type="string">
      <text:p>criterion between keys, take lower</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=LOOKUP(5;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)" calcext:value-type="string">
      <text:p>=LOOKUP(5;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP(10;['lookup_source.fods'#$Data.A17:.A22];['lookup_source.fods'#$Data.D16:.I16])" office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="22" calcext:value-type="float">
      <text:p>22</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A18]=[.B18]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>exact <text:s/>match</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=LOOKUP(10;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)" calcext:value-type="string">
      <text:p>=LOOKUP(10;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP("A";['lookup_source.fods'#$Data.A17:.A22];['lookup_source.fods'#$Data.D16:.H16])" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=NA()" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#N/A</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=AND(ISERROR([.A19]);ISNA([.B19]))" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>criterion text, but match is number</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=LOOKUP("A";'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:H16)" calcext:value-type="string">
      <text:p>=LOOKUP("A";'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:H16)</text:p>
     </table:table-cell>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=LOOKUP("D";['lookup_source.fods'#$Data.A17:.A22];['lookup_source.fods'#$Data.D16:.I16])" office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="44" calcext:value-type="float">
      <text:p>44</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" table:formula="of:=[.A20]=[.B20]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>WAHR</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
      <text:p>two exact matches, take upper</text:p>
     </table:table-cell>
--> --------------------

--> maximum size reached

--> --------------------