doesn't already exist. */

ScLookupCache & GetLookupCache( const ScRange & rRange, ScInterpreterContext* pContext );

ScSortedRangeCache & GetSortedRangeCache( const ScRange & rRange, const ScQueryParam& param,

/** Only ScLookupCache dtor uses RemoveLookupCache(), do

not use elsewhere! */

void RemoveLookupCache( ScLookupCache & rCache );

protected:

ScQueryCellIteratorAccessSpecific( ScDocument& rDocument, ScInterpreterContext& rContext,

const ScQueryParam& rParam, bool bReverseSearch );

void InitPosFinish( SCROW beforeRow, SCROW lastRow, bool bFirstMatch );

void IncPos() { IncPosImpl<false>(); }

bool IncPosFast() { return IncPosImpl<true>(); }

public:

/// MUST be new'd because Notify() deletes.

ScSortedRangeCache(ScDocument* pDoc, const ScRange& rRange, const ScQueryParam& param,

/// Returns if the cache is usable.

bool isValid() const { return mValid; }

<?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.3" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">

<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="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="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="IgnoreBreakAfterMultilineField" config:type="boolean">false</config:config-item>

</config:config-item-map-entry>

<config:config-item-map-entry config:name="Sheet2">

<config:config-item config:name="CursorPositionY" config:type="int">133</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="ZoomType" config:type="short">0</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-map-entry>

</config:config-item-map-named>

<config:config-item config:name="ActiveTable" config:type="string">Sheet1</config:config-item>

<config:config-item config:name="ZoomType" config:type="short">0</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="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">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"/>

</office:script>

</office:scripts>

<office:font-face-decls>

<style:font-face style:name="FreeSans" svg:font-family="FreeSans" style:font-family-generic="system" style:font-pitch="variable"/>

<style:font-face style:name="Liberation Sans" svg:font-family="&apos;Liberation Sans&apos;" style:font-family-generic="swiss" style:font-pitch="variable"/>

<style:font-face style:name="Lucida Sans" svg:font-family="&apos;Lucida Sans&apos;" style:font-family-generic="system" style:font-pitch="variable"/>

<style:map style:condition="value()&lt;0" style:apply-style-name="N344P1"/>

<style:map style:condition="value()=0" style:apply-style-name="N344P2"/>

</number:text-style>

<number:number-style style:name="N348P0" style:volatile="true">

</number:number-style>

<number:number-style style:name="N348">

<number:text>-</number:text>

<style:map style:condition="value()&gt;=0" style:apply-style-name="N348P0"/>

</number:number-style>

<number:number-style style:name="N349P0" style:volatile="true">

<number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N349">

<number:text>-</number:text>

<number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>

<style:map style:condition="value()&gt;=0" style:apply-style-name="N349P0"/>

</number:number-style>

<number:number-style style:name="N350P0" style:volatile="true">

</number:number-style>

<number:number-style style:name="N350">

<number:text>-</number:text>

<style:map style:condition="value()&gt;=0" style:apply-style-name="N350P0"/>

</number:number-style>

<number:number-style style:name="N351P0" style:volatile="true">

<number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N351">

<number:text>-</number:text>

<number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>

<style:map style:condition="value()&gt;=0" style:apply-style-name="N351P0"/>

</number:number-style>

<number:number-style style:name="N352P0" style:volatile="true">

</number:number-style>

<number:text>-</number:text>

</number:number-style>

<number:number-style style:name="N353P0" style:volatile="true">

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

<number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N353P1" style:volatile="true">

<number:text>-</number:text>

<number:fill-character> </number:fill-character>

<number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N353P2" style:volatile="true">

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

</number:number-style>

<number:text-style style:name="N353">

<number:text loext:blank-width-char="-"> </number:text>

<number:number-style style:name="N354P0" style:volatile="true">

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

</number:number-style>

<number:number-style style:name="N354P1" style:volatile="true">

<number:text>-</number:text>

<number:fill-character> </number:fill-character>

</number:number-style>

<number:number-style style:name="N354P2" style:volatile="true">

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

</number:number-style>

<number:text-style style:name="N354">

<number:text loext:blank-width-char="-"> </number:text>

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

<number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N355P1" style:volatile="true">

<number:text>-</number:text>

<number:fill-character> </number:fill-character>

<number:number number:decimal-places="2" number:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>

</number:number-style>

<number:number-style style:name="N355P2" style:volatile="true">

<number:text loext:blank-width-char="-"> </number:text>

<number:fill-character> </number:fill-character>

<number:text>-</number:text>

<number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="2" loext:max-blank-integer-digits="2"/>

</number:number-style>

<number:text-style style:name="N355">

<number:text loext:blank-width-char="-"> </number:text>

<style:map style:condition="value()&lt;0" style:apply-style-name="N355P1"/>

<style:map style:condition="value()=0" style:apply-style-name="N355P2"/>

</number:text-style>

<number:date-style style:name="N10129" number:language="en" number:country="US">

<number:month/>

<number:text>/</number:text>

<number:boolean-style style:name="N99">

<number:boolean/>

</number:boolean-style>

<style:table-cell-properties fo:wrap-option="wrap"/>

<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"/>

</style:style>

<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-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: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-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: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()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>

<style:map style:condition="cell-content()=1" style:apply-style-name="true" style:base-cell-address="Sheet1.B3"/>

<style:map style:condition="cell-content()=0" style:apply-style-name="false" style:base-cell-address="Sheet1.B3"/>

</style:style>

<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:map style:condition="cell-content()=1" style:apply-style-name="true" style:base-cell-address="Sheet1.B3"/>

<style:map style:condition="cell-content()=0" style:apply-style-name="false" style:base-cell-address="Sheet1.B3"/>

</style:style>

<style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>

<style:map style:condition="cell-content()=1" style:apply-style-name="true" style:base-cell-address="Sheet1.B3"/>

<style:map style:condition="cell-content()=0" style:apply-style-name="false" style:base-cell-address="Sheet1.B3"/>

</style:style>

<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="ce10" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/>

<style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>

<style:map style:condition="cell-content()=1" style:apply-style-name="true" style:base-cell-address="Sheet2.C2"/>

<style:map style:condition="cell-content()=0" style:apply-style-name="false" style:base-cell-address="Sheet2.C2"/>

<style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:wrap-option="wrap"/>

</style:style>

<style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0cm" style:writing-mode="page"/>

</style:style>

<style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0"/>

<style:page-layout style:name="pm1">

<text:p><text:sheet-name>???</text:sheet-name><text:s/>(<text:title>???</text:title>)</text:p>

</style:region-left>

<style:region-right>

</style:region-right>

</style:header>

<style:header-left style:display="false"/>

<table:table-column table:style-name="co2" table:default-cell-style-name="ce5"/>

<table:table-column table:style-name="co3" table:default-cell-style-name="Default"/>

<table:table-row table:style-name="ro1">

<text:p>XLOOKUP Function</text:p>

</table:table-cell>

<table:table-cell table:style-name="Default"/>

<table:table-cell/>

</table:table-row>

<table:table-row table:style-name="ro3">

<text:p>Result</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell/>

<table:table-cell table:number-columns-repeated="3"/>

</table:table-row>

<table:table-row table:style-name="ro4">

<text:p>Sheet</text:p>

</table:table-cell>

<text:p>Result</text:p>

</table:table-cell>

<text:p>Description</text:p>

</table:table-cell>

</table:table-row>

<table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">

<text:p>2</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<text:p>Simple XLOOKUP formulas with local references and values</text:p>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2" table:number-rows-repeated="20">

<table:table-cell/>

<table:table-cell/>

</table:table-row>

<table:table-row table:style-name="ro2" table:number-rows-repeated="21">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>+55</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=XLOOKUP(G2;H2:H11;J2:J11)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>+91</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=XLOOKUP(&quot;India&quot;;H2:H11;J2:J11)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>+91</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=XLOOKUP(&quot;INDIA&quot;;H2:H11;J2:J11)" calcext:value-type="string">

<table:table-cell table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Ireland&quot;;H2:H11;J2:J11)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p/>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Ireland&quot;;H2:H11;J2:J11;&quot;&quot;)" calcext:value-type="string">

<table:table-cell office:value-type="float" office:value="-99" calcext:value-type="float">

<text:p>-99</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Ireland&quot;;H2:H11;J2:J11;-99)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Not here</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Ireland&quot;;H2:H11;J2:J11;&quot;Not here&quot;)" calcext:value-type="string">

<table:table-cell table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=XLOOKUP(&quot;&quot;;H2:H11;J2:J11)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>00234</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Nigeria&quot;;H2:H11;J2:J11;;;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>+234</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=XLOOKUP(&quot;Nigeria&quot;;H2:H11;J2:J11;;;-1)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Mexico</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Ned Lanning</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="{=XLOOKUP(4390;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Marketing</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="{=XLOOKUP(4390;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Mia Arnold</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="{=XLOOKUP(G14;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Operations</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="{=XLOOKUP(G14;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>ID not found</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="{=XLOOKUP(G18;I14:R14;I15:R16;&quot;ID not found&quot;)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>ID not found</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="{=XLOOKUP(G18;I14:R14;I15:R16;&quot;ID not found&quot;)}" calcext:value-type="string">

<table:table-cell table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="{=XLOOKUP(&quot;&quot;;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="{=XLOOKUP(&quot;&quot;;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Earlene McCartney</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A22])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16;;1)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Accounting</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16;;1)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Earlene McCartney</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16;;-1)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Accounting</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16;;-1)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Earlene McCartney</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Accounting</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="{=XLOOKUP(4937;I14:R14;I15:R16)}" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="float" office:value="0.24" calcext:value-type="float">

<text:p>0,24</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="=XLOOKUP(G29;I30:I35;H30:H35;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="float" office:value="0.24" calcext:value-type="float">

<text:p>0,24</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A30])" office:value-type="string" office:string-value="=XLOOKUP(G29;I30:I35;H30:H35;;1;2)" calcext:value-type="string">

<table:table-cell office:value-type="float" office:value="0.22" calcext:value-type="float">

<text:p>0,22</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A31])" office:value-type="string" office:string-value="=XLOOKUP(G29;I30:I35;H30:H35;;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A32])" office:value-type="string" office:string-value="=XLOOKUP(G29;I30:I35;H30:H35;;2;2)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="float" office:value="0.32" calcext:value-type="float">

<text:p>0,32</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="float" office:value="0.35" calcext:value-type="float">

<text:p>0,35</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="float" office:value="0.37" calcext:value-type="float">

<text:p>0,37</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="float" office:value="25000" calcext:value-type="float">

<text:p>25000</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A37])" office:value-type="string" office:string-value="=XLOOKUP(K37;$I37:$T37;XLOOKUP($G37;$H38:$H42;$I38:$T42))" calcext:value-type="string">

<table:table-cell office:value-type="float" office:value="19342" calcext:value-type="float">

<text:p>19342</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A38])" office:value-type="string" office:string-value="=XLOOKUP(S37;$I37:$T37;XLOOKUP($G37;$H38:$H42;$I38:$T42))" calcext:value-type="string">

<table:table-cell office:value-type="float" office:value="0.293" calcext:value-type="float">

<text:p>0,293</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A39])" office:value-type="string" office:string-value="=XLOOKUP(T37;$I37:$T37;XLOOKUP($G37;$H38:$H42;$I38:$T42))" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Q3</text:p>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Mia Arnold</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A41])" office:value-type="string" office:string-value="{=XLOOKUP(G14;$H14:$R14;$H$15:$R$16)}" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Operations</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A42])" office:value-type="string" office:string-value="{=XLOOKUP(G14;$H14:$R14;$H$15:$R$16)}" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="float" office:value="110.56" calcext:value-type="float">

<text:p>110,56</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A44])" office:value-type="string" office:string-value="=SUM(XLOOKUP(G44;H45:H49;K45:K49):XLOOKUP(G45;H45:H49;K45:K49))" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="3"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Banana</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Grape</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Pear</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Banana</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>Cherry</text:p>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>err:504</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A51])" office:value-type="string" office:string-value="=XLOOKUP(&quot;B&quot;;H51:H53;K51:K52)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>err:504</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A52])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;H51:H53;K51:K52)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>err:504</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A53])" office:value-type="string" office:string-value="=XLOOKUP(&quot;E&quot;;H51:I53;K51:L53)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>err:504</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A54])" office:value-type="string" office:string-value="=XLOOKUP(&quot;E&quot;;H51:I53;K51:K53)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>err:504</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A55])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;H51:I53;K51:K53)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2" table:number-rows-repeated="2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A58])" office:value-type="string" office:string-value="=XLOOKUP(3;I$58:I$62;L$58:L$62;;0;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A59])" office:value-type="string" office:string-value="=XLOOKUP(4;I$58:I$62;L$58:L$62;;-1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>a5</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A60])" office:value-type="string" office:string-value="=XLOOKUP(4;I$58:I$62;L$58:L$62;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A61])" office:value-type="string" office:string-value="=XLOOKUP(3;I$58:I$62;L$58:L$62;;2;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A62])" office:value-type="string" office:string-value="=XLOOKUP(3;I$58:I$62;L$58:L$62;;0;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A63])" office:value-type="string" office:string-value="=XLOOKUP(4;I$58:I$62;L$58:L$62;;-1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>a5</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A64])" office:value-type="string" office:string-value="=XLOOKUP(4;I$58:I$62;L$58:L$62;;1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A65])" office:value-type="string" office:string-value="=XLOOKUP(3;I$58:I$62;L$58:L$62;;2;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A66])" office:value-type="string" office:string-value="=XLOOKUP(3;H$58:H$62;K$58:K$62;;0;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A67])" office:value-type="string" office:string-value="=XLOOKUP(4;H$58:H$62;K$58:K$62;;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>D5.2</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A68])" office:value-type="string" office:string-value="=XLOOKUP(4;H$58:H$62;K$58:K$62;;1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A69])" office:value-type="string" office:string-value="=XLOOKUP(3;H$58:H$62;K$58:K$62;;2;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A70])" office:value-type="string" office:string-value="=XLOOKUP(3;J$58:J$62;M$58:M$62;;0;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A71])" office:value-type="string" office:string-value="=XLOOKUP(4;J$58:J$62;M$58:M$62;;-1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b5</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A72])" office:value-type="string" office:string-value="=XLOOKUP(4;J$58:J$62;M$58:M$62;;1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A73])" office:value-type="string" office:string-value="=XLOOKUP(3;J$58:J$62;M$58:M$62;;2;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A74])" office:value-type="string" office:string-value="=XLOOKUP(3;H$74:L$74;H$75:L$75;;0;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A75])" office:value-type="string" office:string-value="=XLOOKUP(4;H$74:L$74;H$75:L$75;;-1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>a5</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A76])" office:value-type="string" office:string-value="=XLOOKUP(4;H$74:L$74;H$75:L$75;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>b3</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A77])" office:value-type="string" office:string-value="=XLOOKUP(3;H$74:L$74;H$75:L$75;;2;1)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A79])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;I$79:I$83;L$79:L$83;;0;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A80])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;I$79:I$83;L$79:L$83;;-1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>aE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A81])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;I$79:I$83;L$79:L$83;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>eB</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A82])" office:value-type="string" office:string-value="=XLOOKUP(&quot;b?b&quot;;I$84:I$88;L$79:L$83;;2;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A83])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;I$79:I$83;L$79:L$83;;0;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A84])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;I$79:I$83;L$79:L$83;;-1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>aE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A85])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;I$79:I$83;L$79:L$83;;1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A86])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;I$79:I$83;L$79:L$83;;2;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A87])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;H$79:H$83;K$79:K$83;;0;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A88])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;H$79:H$83;K$79:K$83;;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>eE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A89])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;H$79:H$83;K$79:K$83;;1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A90])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;H$79:H$83;K$79:K$83;;2;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A91])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;J$79:J$83;M$79:M$83;;0;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A92])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;J$79:J$83;M$79:M$83;;-1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>eE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A93])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;J$79:J$83;M$79:M$83;;1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>cC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A94])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;J$79:J$83;M$79:M$83;;2;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A95])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C&quot;;H$95:L$95;H$96:L$96;;0;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A96])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;H$95:L$95;H$96:L$96;;-1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>aE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A97])" office:value-type="string" office:string-value="=XLOOKUP(&quot;D&quot;;H$95:L$95;H$96:L$96;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A98])" office:value-type="string" office:string-value="=XLOOKUP(&quot;C?&quot;;H$95:L$95;H$96:L$96;;2;1)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="4"/>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>LookCol</text:p>

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A100])" office:value-type="string" office:string-value="=XLOOKUP(&quot;c&quot;;I$79:I$83;L$79:L$83;;0;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>bC</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A101])" office:value-type="string" office:string-value="=XLOOKUP(&quot;d&quot;;I$79:I$83;L$79:L$83;;-1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>aE</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A102])" office:value-type="string" office:string-value="=XLOOKUP(&quot;d&quot;;I$79:I$83;L$79:L$83;;1;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A103])" office:value-type="string" office:string-value="=XLOOKUP(&quot;f?&quot;;I$79:I$83;L$79:L$83;;2;1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>g</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A104])" office:value-type="string" office:string-value="=XLOOKUP(K99;H$99:H$109;I$99:I$109;;-1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>a</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A105])" office:value-type="string" office:string-value="=XLOOKUP(K99;N$99:R$99;N$100:R$100;;-1;-1)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>BR</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A106])" office:value-type="string" office:string-value="=XLOOKUP($M$1;K$1:K$12;I$1:I$12;0;1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>BR</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A107])" office:value-type="string" office:string-value="=XLOOKUP($M$1;L$1:L$12;I$1:I$12;0;1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>ID</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A108])" office:value-type="string" office:string-value="=XLOOKUP($M$1;K$1:K$12;I$1:I$12;0;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>PK</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A109])" office:value-type="string" office:string-value="=XLOOKUP(M1;L$1:L$12;I$1:I$12;0;-1;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>PK</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A110])" office:value-type="string" office:string-value="=XLOOKUP(N1;L$1:L$12;I$1:I$12;0;0;-2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A111])" office:value-type="string" office:string-value="=XLOOKUP(M1;K$1:K$12;I$1:I$12;;0;2)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A113])" office:value-type="string" office:string-value="=XLOOKUP($O$1;P$1:P$11;T$1:T$11;;0;2)" calcext:value-type="string">

<table:table-cell table:number-columns-repeated="16"/>

</table:table-row>

<table:table-row table:style-name="ro2">

</table:table-cell>

<table:table-cell office:value-type="string" calcext:value-type="string">

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A114])" office:value-type="string" office:string-value="=XLOOKUP($O$1;P$1:P$11;T$1:T$11;;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>d</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A115])" office:value-type="string" office:string-value="=XLOOKUP($O$1;P$1:P$11;T$1:T$11;;1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A116])" office:value-type="string" office:string-value="=XLOOKUP($O$1;Q$1:Q$11;T$1:T$11;;0;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A117])" office:value-type="string" office:string-value="=XLOOKUP($O$1;Q$1:Q$11;T$1:T$11;;-1;2)" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>c</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A118])" office:value-type="string" office:string-value="=XLOOKUP($O$1;Q$1:Q$11;T$1:T$11;;1;2)" calcext:value-type="string">

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>#N/A</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A120])" office:value-type="string" office:string-value="=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;0;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;0;-2)</text:p>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

</table:table-cell>

<table:table-cell office:value-type="string" calcext:value-type="string">

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A121])" office:value-type="string" office:string-value="=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;-1;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;-1;-2)</text:p>

</table:table-cell>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.$O$1];[.R$1:.R$11];[.T$1:.T$11];;1;-2)" office:value-type="string" office:string-value="g" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>g</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A122])" office:value-type="string" office:string-value="=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;1;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;R$1:R$11;T$1:T$11;;1;-2)</text:p>

</table:table-cell>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.$O$1];[.S$1:.S$11];[.T$1:.T$11];;0;-2)" office:value-type="string" office:string-value="h" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>h</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A123])" office:value-type="string" office:string-value="=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;0;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;0;-2)</text:p>

</table:table-cell>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.$O$1];[.S$1:.S$11];[.T$1:.T$11];;-1;-2)" office:value-type="string" office:string-value="h" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>h</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A124])" office:value-type="string" office:string-value="=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;-1;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;-1;-2)</text:p>

</table:table-cell>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.$O$1];[.S$1:.S$11];[.T$1:.T$11];;1;-2)" office:value-type="string" office:string-value="h" calcext:value-type="string">

<table:table-cell office:value-type="string" calcext:value-type="string">

<text:p>h</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A125])" office:value-type="string" office:string-value="=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;1;-2)" calcext:value-type="string">

<text:p>=XLOOKUP($O$1;S$1:S$11;T$1:T$11;;1;-2)</text:p>

</table:table-cell>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:number-columns-repeated="2"/>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.N25];[.K22:.K26];[.L22:.L26];COM.MICROSOFT.XLOOKUP([.N25];[.P22:.P26];[.Q22:.Q26]))" office:value-type="float" office:value="16" calcext:value-type="float">

<table:table-cell office:value-type="float" office:value="16" calcext:value-type="float">

<text:p>16</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A127])" office:value-type="string" office:string-value="=XLOOKUP(N25;K22:K26;L22:L26;XLOOKUP(N25;P22:P26;Q22:Q26))" calcext:value-type="string">

<text:p>=XLOOKUP(N25;K22:K26;L22:L26;XLOOKUP(N25;P22:P26;Q22:Q26))</text:p>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

<table:table-cell table:formula="of:=COM.MICROSOFT.XLOOKUP([.N26];[.K22:.K26];[.L22:.L26];COM.MICROSOFT.XLOOKUP([.N26];[.P22:.P26];[.Q22:.Q26]))" office:value-type="float" office:value="86" calcext:value-type="float">

<table:table-cell office:value-type="float" office:value="86" calcext:value-type="float">

<text:p>86</text:p>

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

<table:table-cell table:formula="of:=FORMULA([.A128])" office:value-type="string" office:string-value="=XLOOKUP(N26;K22:K26;L22:L26;XLOOKUP(N26;P22:P26;Q22:Q26))" calcext:value-type="string">

<text:p>=XLOOKUP(N26;K22:K26;L22:L26;XLOOKUP(N26;P22:P26;Q22:Q26))</text:p>

</table:table-cell>

<table:table-cell table:number-columns-repeated="2"/>

</table:table-cell>

</table:table-cell>

</table:table-row>

<table:table-row table:style-name="ro2">

</table:table-row>

<table:table-row table:style-name="ro2">

</table:table-cell>

<table:table-cell office:value-type="string" calcext:value-type="string">

</table:table-cell>

<text:p>IGAZ</text:p>

</table:table-cell>

</table:table-cell>

<table:table-cell table:number-columns-repeated="16"/>

</table:table-row>

<table:table-cell table:number-columns-repeated="2"/>

<table:table-cell table:number-columns-repeated="17"/>

</table:table-row>

<table:table-row table:style-name="ro2" table:number-rows-repeated="1048373">

}

ScSortedRangeCache& ScDocument::GetSortedRangeCache( const ScRange & rRange, const ScQueryParam& param,

{

assert(mxScSortedRangeCache);

ScSortedRangeCache::HashKey key = ScSortedRangeCache::makeHashKey(rRange, param);

auto [findIt, bInserted] = mxScSortedRangeCache->aCacheMap.emplace(key, nullptr);

if (bInserted)

{

StartListeningArea(rRange, false, findIt->second.get());

}

return *findIt->second;

{

// This should be all in AccessBase::InitPos(), but that one can't call

// BinarySearch(), so do it this way instead.

ScQueryOp& op = maParam.GetEntry(0).eOp;

SCROW beforeRow = -1;

SCROW lastRow = -1;

// non-matching position using SC_LESS and the start position

// is the one after it.

lastRow = nRow;

}

else if( maParam.GetEntry(0).GetQueryItem().mbMatchEmpty

&& rDoc.IsEmptyData(nCol, maParam.nRow1, nCol, maParam.nRow2, nTab))

beforeRow = -1;

lastRow = maParam.nRow2;

}

}

else

{ // The range is from the start up to and including the last matching.

lastRow = nRow;

}

}

}

{

if (fLastInRangeValue <= nCellVal)

{

}

else if (fLastInRangeValue >= nCellVal)

{

aCellStr);

if (nTmp <= 0)

{

}

else if (nTmp > 0)

{

{

found = i;

nLastInRange = i;

}

else if (bAscending)

{

// over indexes of the sorted cache (which is a stable sort of the cell contents) in the range

// that fits the query condition and then that is mapped to rows. This will result in iterating

// over only matching rows in their sorted order (and for equal rows in their row order).

{

ScRange aSortedRangeRange( nCol, maParam.nRow1, nTab, nCol, maParam.nRow2, nTab );

// We want all matching values first in the sort order,

// InitPosFinish() needs to be called after this, ScQueryCellIteratorBase::InitPos()

// will handle that

}

// range lookup <= or >=

SCCOL nCol;

SCROW nRow;

ScQueryCellIteratorSortedCache::CanBeUsed(rDoc, rParam, rParam.nTab, cell, refData, rContext))

{

ScQueryCellIteratorSortedCache aCellIter(rDoc, rContext, rParam.nTab, rParam, false, false);

aCellIter.SetSortedBinarySearchMode(nSearchMode);

aCellIter.SetLookupMode(nOpCode);

}

else

{

bool bReverse = (static_cast<SearchMode>(nSearchMode) == searchrev);

ScQueryCellIteratorDirect aCellIter(rDoc, rContext, rParam.nTab, rParam, false, bReverse);

ScSortedRangeCache::ScSortedRangeCache(ScDocument* pDoc, const ScRange& rRange,

const ScQueryParam& param, ScInterpreterContext* context,

: maRange(rRange)

, mpDoc(pDoc)

, mValid(false)

return;

}

}

if (needsDescending(entry.eOp))

for (auto it = rowData.rbegin(); it != rowData.rend(); ++it)

mSortedRows.emplace_back(it->row);

}

CollatorWrapper& collator

= ScGlobal::GetCollator(mValueType == ValueType::StringsCaseSensitive);

if (needsDescending(entry.eOp))

for (auto it = rowData.rbegin(); it != rowData.rend(); ++it)

mSortedRows.emplace_back(it->row);