sc/inc/document.hxx | 2
sc/inc/queryiter.hxx | 2
sc/inc/rangecache.hxx | 3
sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods | 678 +++++++---------
sc/source/core/data/documen2.cxx | 4
sc/source/core/data/queryiter.cxx | 79 -
sc/source/core/tool/interpr1.cxx | 9
sc/source/core/tool/rangecache.cxx | 43 -
8 files changed, 384 insertions(+), 436 deletions(-)
New commits:
commit e2c9d38d95a1a0b5cf754fb04f2fd73c6ddb8004
Author: Balazs Varga <balazs.varga.ext...@allotropia.de>
AuthorDate: Sun Apr 21 13:39:58 2024 +0200
Commit: Balazs Varga <balazs.varga.ext...@allotropia.de>
CommitDate: Tue Apr 30 23:32:49 2024 +0200
tdf#160725 - Fix XLOOKUP has different result for approximate
search than Excel.
Some rework for xlookup binary search in rows to get the correct results
when we are searching with binary mode in rows.
Change-Id: I7ef710c4ae638e2cf5d4bee45810cec7057f5d4b
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/166451
Reviewed-by: Balazs Varga <balazs.varga.ext...@allotropia.de>
Tested-by: Jenkins
diff --git a/sc/inc/document.hxx b/sc/inc/document.hxx
index d9c3f1866947..4dbce67d2928 100644
--- a/sc/inc/document.hxx
+++ b/sc/inc/document.hxx
@@ -1413,7 +1413,7 @@ public:
doesn't already exist. */
ScLookupCache & GetLookupCache( const ScRange & rRange,
ScInterpreterContext* pContext );
ScSortedRangeCache & GetSortedRangeCache( const ScRange & rRange, const
ScQueryParam& param,
- ScInterpreterContext* pContext );
+ ScInterpreterContext* pContext,
sal_uInt8 nSortedBinarySearch = 0x00 );
/** Only ScLookupCache dtor uses RemoveLookupCache(), do
not use elsewhere! */
void RemoveLookupCache( ScLookupCache & rCache );
diff --git a/sc/inc/queryiter.hxx b/sc/inc/queryiter.hxx
index 2d54b40c469c..c6cd1906a4fb 100644
--- a/sc/inc/queryiter.hxx
+++ b/sc/inc/queryiter.hxx
@@ -103,7 +103,7 @@ public:
protected:
ScQueryCellIteratorAccessSpecific( ScDocument& rDocument,
ScInterpreterContext& rContext,
const ScQueryParam& rParam, bool bReverseSearch );
- void InitPosStart();
+ void InitPosStart(sal_uInt8 nSortedBinarySearch = 0x00);
void InitPosFinish( SCROW beforeRow, SCROW lastRow, bool bFirstMatch );
void IncPos() { IncPosImpl<false>(); }
bool IncPosFast() { return IncPosImpl<true>(); }
diff --git a/sc/inc/rangecache.hxx b/sc/inc/rangecache.hxx
index c65e8653a458..bca9554a5e6a 100644
--- a/sc/inc/rangecache.hxx
+++ b/sc/inc/rangecache.hxx
@@ -46,7 +46,8 @@ class ScSortedRangeCache final : public SvtListener
public:
/// MUST be new'd because Notify() deletes.
ScSortedRangeCache(ScDocument* pDoc, const ScRange& rRange, const
ScQueryParam& param,
- ScInterpreterContext* context, bool invalid = false);
+ ScInterpreterContext* context, bool invalid = false,
+ sal_uInt8 nSortedBinarySearch = 0x00);
/// Returns if the cache is usable.
bool isValid() const { return mValid; }
diff --git a/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
b/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
index 8da1a44240bd..41a5789f73a1 100644
--- a/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
+++ b/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
@@ -1,7 +1,7 @@
<?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/200
4/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:meta><meta:creation-date>2024-01-16T18:30:06.278000000</meta:creation-date><meta:editing-duration>PT1H51M16S</meta:editing-duration><meta:editing-cycles>29</meta:editing-cycles><meta:generator>LibreOfficeDev/24.8.0.0.alpha0$Windows_X86_64
LibreOffice_project/24914caa6013b41b6614710322a3084cf4a2aa10</meta:generator><dc:date>2024-04-18T19:16:45.855000000</dc:date><meta:document-statistic
meta:table-count="2" meta:cell-count="924"
meta:object-count="0"/></office:meta>
+
<office:meta><meta:creation-date>2024-01-16T18:30:06.278000000</meta:creation-date><meta:editing-duration>PT1H29M57S</meta:editing-duration><meta:editing-cycles>29</meta:editing-cycles><meta:generator>LibreOfficeDev/24.8.0.0.alpha0$Windows_X86_64
LibreOffice_project/417ff8b00401b1b61dc87a73b053a58e6d63ecc7</meta:generator><dc:date>2024-04-22T15:10:20.637000000</dc:date><meta:document-statistic
meta:table-count="2" meta:cell-count="908"
meta:object-count="0"/></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>
@@ -21,7 +21,7 @@
<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">65</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>
@@ -30,15 +30,15 @@
<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="CursorPositionX"
config:type="int">0</config:config-item>
+ <config:config-item config:name="CursorPositionX"
config:type="int">3</config:config-item>
<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="PositionBottom"
config:type="int">90</config:config-item>
+ <config:config-item config:name="PositionBottom"
config:type="int">108</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">65</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>
@@ -48,9 +48,9 @@
</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="HorizontalScrollbarWidth"
config:type="int">1677</config:config-item>
+ <config:config-item config:name="HorizontalScrollbarWidth"
config:type="int">1851</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">65</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>
@@ -88,6 +88,13 @@
<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>
@@ -140,6 +147,7 @@
</office:script>
</office:scripts>
<office:font-face-decls>
+ <style:font-face style:name="Arial" svg:font-family="Arial"
style:font-family-generic="swiss"/>
<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="'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"/>
@@ -1353,106 +1361,106 @@
<style:map style:condition="value()<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="N345P0" style:volatile="true">
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
- </number:number-style>
- <number:number-style style:name="N345">
- <number:text>-</number:text>
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
- <style:map style:condition="value()>=0" style:apply-style-name="N345P0"/>
- </number:number-style>
- <number:number-style style:name="N346P0" style:volatile="true">
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
- </number:number-style>
- <number:number-style style:name="N346">
- <style:text-properties fo:color="#ff0000"/>
- <number:text>-</number:text>
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
- <style:map style:condition="value()>=0" style:apply-style-name="N346P0"/>
- </number:number-style>
- <number:number-style style:name="N347P0" style:volatile="true">
- <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
- </number:number-style>
- <number:number-style style:name="N347">
- <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> Ft</number:text>
- <style:map style:condition="value()>=0" style:apply-style-name="N347P0"/>
- </number:number-style>
+ <number:date-style style:name="N345">
+ <number:day number:style="long"/>
+ <number:text>. </number:text>
+ <number:month number:textual="true"/>
+ <number:text> </number:text>
+ <number:year/>
+ </number:date-style>
+ <number:date-style style:name="N346">
+ <number:day number:style="long"/>
+ <number:text>. </number:text>
+ <number:month number:textual="true"/>
+ </number:date-style>
+ <number:date-style style:name="N347">
+ <number:month number:textual="true"/>
+ <number:text> </number:text>
+ <number:year/>
+ </number:date-style>
<number:number-style style:name="N348P0" style:volatile="true">
- <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text> Ft</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1"> </number:text>
</number:number-style>
<number:number-style style:name="N348">
- <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> Ft</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1"> </number:text>
<style:map style:condition="value()>=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:text loext:blank-width-char="F1_t3"> </number:text>
+ <number:text loext:blank-width-char="€1"> </number:text>
</number:number-style>
<number:number-style style:name="N349">
+ <style:text-properties fo:color="#ff0000"/>
<number:text>-</number:text>
<number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text loext:blank-width-char="F1_t3"> </number:text>
+ <number:text loext:blank-width-char="€1"> </number:text>
<style:map style:condition="value()>=0" style:apply-style-name="N349P0"/>
</number:number-style>
<number:number-style style:name="N350P0" style:volatile="true">
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text loext:blank-width-char="F1_t3"> </number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1"> </number:text>
</number:number-style>
<number:number-style style:name="N350">
- <style:text-properties fo:color="#ff0000"/>
<number:text>-</number:text>
- <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text loext:blank-width-char="F1_t3"> </number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1"> </number:text>
<style:map style:condition="value()>=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:text loext:blank-width-char="F1_t3"> </number:text>
+ <number:text loext:blank-width-char="€1"> </number:text>
</number:number-style>
<number:number-style style:name="N351">
+ <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 loext:blank-width-char="F1_t3"> </number:text>
+ <number:text loext:blank-width-char="€1"> </number:text>
<style:map style:condition="value()>=0" style:apply-style-name="N351P0"/>
</number:number-style>
<number:number-style style:name="N352P0" style:volatile="true">
- <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text loext:blank-width-char="F1_t3"> </number:text>
+ <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:text loext:blank-width-char="€1_-3"> </number:text>
</number:number-style>
- <number:number-style style:name="N352">
- <style:text-properties fo:color="#ff0000"/>
+ <number:number-style style:name="N352P1" style:volatile="true">
<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 loext:blank-width-char="F1_t3"> </number:text>
- <style:map style:condition="value()>=0" style:apply-style-name="N352P0"/>
+ <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:text loext:blank-width-char="€1_-3"> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N352P2" style:volatile="true">
+ <number:text loext:blank-width-char="-"> </number:text>
+ <number:fill-character> </number:fill-character>
+ <number:text loext:blank-width-char="€2_-4">- </number:text>
</number:number-style>
+ <number:text-style style:name="N352">
+ <number:text loext:blank-width-char="-"> </number:text>
+ <number:text-content/>
+ <number:text loext:blank-width-char="-"> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N352P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N352P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N352P2"/>
+ </number:text-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:text loext:blank-width-char="F1_t3_-4"> </number:text>
+ <number:text loext:blank-width-char="-2"> € </number:text>
</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:text loext:blank-width-char="F1_t3_-4"> </number:text>
+ <number:text loext:blank-width-char="-2"> € </number:text>
</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:text loext:blank-width-char="F2_t4_-5">- </number:text>
+ <number:text loext:blank-width-char="-3">- € </number:text>
</number:number-style>
<number:text-style style:name="N353">
<number:text loext:blank-width-char="-"> </number:text>
@@ -1465,19 +1473,21 @@
<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 number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
- <number:text loext:blank-width-char="-3"> Ft </number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1_-3"> </number:text>
</number:number-style>
<number:number-style style:name="N354P1" 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:text loext:blank-width-char="-3"> Ft </number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text loext:blank-width-char="€1_-3"> </number:text>
</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:text loext:blank-width-char="-4">- Ft </number:text>
+ <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:text loext:blank-width-char="€1_-3"> </number:text>
</number:number-style>
<number:text-style style:name="N354">
<number:text loext:blank-width-char="-"> </number:text>
@@ -1491,20 +1501,20 @@
<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:text loext:blank-width-char="F1_t3_-4"> </number:text>
+ <number:text loext:blank-width-char="-2"> € </number:text>
</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:text loext:blank-width-char="F1_t3_-4"> </number:text>
+ <number:text loext:blank-width-char="-2"> € </number:text>
</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:text loext:blank-width-char="F1_t3_-4"> </number:text>
+ <number:text loext:blank-width-char="-2"> € </number:text>
</number:number-style>
<number:text-style style:name="N355">
<number:text loext:blank-width-char="-"> </number:text>
@@ -1514,33 +1524,6 @@
<style:map style:condition="value()<0" style:apply-style-name="N355P1"/>
<style:map style:condition="value()=0" style:apply-style-name="N355P2"/>
</number:text-style>
- <number:number-style style:name="N356P0" style:volatile="true">
- <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:text loext:blank-width-char="-3"> Ft </number:text>
- </number:number-style>
- <number:number-style style:name="N356P1" 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:text loext:blank-width-char="-3"> Ft </number:text>
- </number:number-style>
- <number:number-style style:name="N356P2" 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:text loext:blank-width-char="-3"> Ft </number:text>
- </number:number-style>
- <number:text-style style:name="N356">
- <number:text loext:blank-width-char="-"> </number:text>
- <number:text-content/>
- <number:text loext:blank-width-char="-"> </number:text>
- <style:map style:condition="value()>0" style:apply-style-name="N356P0"/>
- <style:map style:condition="value()<0" style:apply-style-name="N356P1"/>
- <style:map style:condition="value()=0" style:apply-style-name="N356P2"/>
- </number:text-style>
<number:date-style style:name="N10129" number:language="en"
number:country="US">
<number:month/>
<number:text>/</number:text>
@@ -2048,21 +2031,24 @@
<number:boolean-style style:name="N99">
<number:boolean/>
</number:boolean-style>
- <style:style style:name="ce9" style:family="table-cell"
style:parent-style-name="Default">
+ <number:text-style style:name="N100">
+ <number:text-content/>
+ </number:text-style>
+ <style:style style:name="ce15" style:family="table-cell"
style:parent-style-name="Default">
<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:style style:name="ce11" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce18" 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-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="ce13" style:family="table-cell"
style:parent-style-name="Default">
+ <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: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="ce14" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:style style:name="ce21" 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="Sheet1.B3"/>
@@ -2074,7 +2060,7 @@
<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:style style:name="ce16" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce24" 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"/>
@@ -2082,17 +2068,17 @@
<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:style style:name="ce17" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:style style:name="ce25" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
<style:map style:condition="cell-content()="""
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:style style:name="ce22" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce26" 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="ce10" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99"/>
- <style:style style:name="ce18" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:style style:name="ce11" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
<style:map style:condition="cell-content()="""
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"/>
@@ -2100,9 +2086,15 @@
<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:style style:name="ce21" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N0">
- <style:table-cell-properties style:cell-protect="protected"
style:print-content="true" style:text-align-source="value-type"
style:repeat-content="false" fo:wrap-option="no-wrap" style:direction="ltr"
style:rotation-angle="0" style:rotation-align="none"
style:shrink-to-fit="false" style:vertical-align="bottom"
loext:vertical-justify="auto"/>
+ <style:style style:name="ce14" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="value-type"
style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr"
style:rotation-angle="0" style:rotation-align="none"
style:shrink-to-fit="false" style:vertical-align="bottom"
loext:vertical-justify="auto"/>
<style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0cm"
style:writing-mode="page"/>
+ <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="Arial" fo:font-size="10pt" fo:font-style="normal"
fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold"
style:font-size-asian="10pt" style:font-style-asian="normal"
style:font-weight-asian="bold" style:font-name-complex="Arial"
style:font-size-complex="10pt" style:font-style-complex="normal"
style:font-weight-complex="bold">
+ <loext:char-complex-color loext:theme-type="dark1"
loext:color-type="theme"/>
+ </style:text-properties>
+ </style:style>
+ <style:style style:name="ce16" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N100">
+ <style:table-cell-properties style:rotation-align="none"/>
</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">
@@ -2147,7 +2139,7 @@
<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="2024-04-18">0000.00.00</text:date>, <text:time
style:data-style-name="N2"
text:time-value="18:47:40">00:00:00</text:time></text:p>
+ <text:p><text:date style:data-style-name="N2"
text:date-value="2024-04-22">0000.00.00</text:date>, <text:time
style:data-style-name="N2"
text:time-value="15:04:55.201000000">00:00:00</text:time></text:p>
</style:region-right>
</style:header>
<style:header-left style:display="false"/>
@@ -2167,7 +2159,7 @@
<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">
- <table:table-cell table:style-name="ce9" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce15" office:value-type="string"
calcext:value-type="string">
<text:p>XLOOKUP Function</text:p>
</table:table-cell>
<table:table-cell table:style-name="Default"/>
@@ -2179,10 +2171,10 @@
<table:table-cell/>
</table:table-row>
<table:table-row table:style-name="ro3">
- <table:table-cell table:style-name="ce11" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce18" office:value-type="string"
calcext:value-type="string">
<text:p>Result</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce14"
table:formula="of:=AND([.B8:.B95])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce21"
table:formula="of:=AND([.B8:.B95])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell/>
@@ -2191,13 +2183,13 @@
<table:table-cell table:number-columns-repeated="3"/>
</table:table-row>
<table:table-row table:style-name="ro4">
- <table:table-cell table:style-name="ce13" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce19" office:value-type="string"
calcext:value-type="string">
<text:p>Sheet</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce16" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce24" office:value-type="string"
calcext:value-type="string">
<text:p>Result</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce13" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce19" office:value-type="string"
calcext:value-type="string">
<text:p>Description</text:p>
</table:table-cell>
</table:table-row>
@@ -2205,16 +2197,16 @@
<table:table-cell office:value-type="float" office:value="2"
calcext:value-type="float">
<text:p>2</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce14"
table:formula="of:=AND([Sheet2.C2:.C202])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce21"
table:formula="of:=AND([Sheet2.C2:.C202])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce22" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce26" office:value-type="string"
calcext:value-type="string">
<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:style-name="ce17"/>
+ <table:table-cell table:style-name="ce25"/>
<table:table-cell/>
</table:table-row>
<table:table-row table:style-name="ro2" table:number-rows-repeated="21">
@@ -2305,7 +2297,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>+55</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A2]=[.B2]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A2]=[.B2]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<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">
@@ -2348,7 +2340,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>+91</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A3]=[.B3]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A3]=[.B3]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A3])"
office:value-type="string"
office:string-value="=XLOOKUP("India";H2:H11;J2:J11)"
calcext:value-type="string">
@@ -2388,7 +2380,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>+91</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A4]=[.B4]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A4]=[.B4]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A4])"
office:value-type="string"
office:string-value="=XLOOKUP("INDIA";H2:H11;J2:J11)"
calcext:value-type="string">
@@ -2431,7 +2423,7 @@
<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>
- <table:table-cell table:style-name="ce18" table:formula="of:=ISNA([.A5])"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=ISNA([.A5])"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A5])"
office:value-type="string"
office:string-value="=XLOOKUP("Ireland";H2:H11;J2:J11)"
calcext:value-type="string">
@@ -2474,7 +2466,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p/>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A6]=[.B6]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A6]=[.B6]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A6])"
office:value-type="string"
office:string-value="=XLOOKUP("Ireland";H2:H11;J2:J11;"")"
calcext:value-type="string">
@@ -2514,7 +2506,7 @@
<table:table-cell office:value-type="float" office:value="-99"
calcext:value-type="float">
<text:p>-99</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A7]=[.B7]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A7]=[.B7]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A7])"
office:value-type="string"
office:string-value="=XLOOKUP("Ireland";H2:H11;J2:J11;-99)"
calcext:value-type="string">
@@ -2551,7 +2543,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Not here</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.A8]=[.B8]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=[.A8]=[.B8]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A8])"
office:value-type="string"
office:string-value="=XLOOKUP("Ireland";H2:H11;J2:J11;"Not
here")" calcext:value-type="string">
@@ -2594,7 +2586,7 @@
<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>
- <table:table-cell table:style-name="ce18" table:formula="of:=ISNA([.A9])"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11" table:formula="of:=ISNA([.A9])"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A9])"
office:value-type="string"
office:string-value="=XLOOKUP("";H2:H11;J2:J11)"
calcext:value-type="string">
@@ -2637,7 +2629,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>00234</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A10]=[.B10]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A10]=[.B10]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A10])"
office:value-type="string"
office:string-value="=XLOOKUP("Nigeria";H2:H11;J2:J11;;;1)"
calcext:value-type="string">
@@ -2677,7 +2669,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>+234</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A11]=[.B11]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A11]=[.B11]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A11])"
office:value-type="string"
office:string-value="=XLOOKUP("Nigeria";H2:H11;J2:J11;;;-1)"
calcext:value-type="string">
@@ -2712,7 +2704,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Mexico</text:p>
@@ -2733,7 +2725,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -2743,7 +2735,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Ned Lanning</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A14]=[.B14]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A14]=[.B14]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -2795,7 +2787,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Marketing</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A15]=[.B15]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A15]=[.B15]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -2844,7 +2836,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Mia Arnold</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A16]=[.B16]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A16]=[.B16]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -2893,7 +2885,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Operations</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A17]=[.B17]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A17]=[.B17]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -2908,7 +2900,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>ID not found</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A18]=[.B18]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A18]=[.B18]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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;"ID not found")}"
calcext:value-type="string">
@@ -2927,7 +2919,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>ID not found</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A19]=[.B19]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A19]=[.B19]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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;"ID not found")}"
calcext:value-type="string">
@@ -2942,7 +2934,7 @@
<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>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISNA([.A20])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISNA([.A20])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A20])"
office:value-type="string"
office:string-value="{=XLOOKUP("";I14:R14;I15:R16)}"
calcext:value-type="string">
@@ -2957,7 +2949,7 @@
<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>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISNA([.A21])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISNA([.A21])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A21])"
office:value-type="string"
office:string-value="{=XLOOKUP("";I14:R14;I15:R16)}"
calcext:value-type="string">
@@ -2972,7 +2964,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Earlene McCartney</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A22]=[.B22]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A22]=[.B22]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3004,7 +2996,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Accounting</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A23]=[.B23]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A23]=[.B23]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3036,7 +3028,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Earlene McCartney</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A24]=[.B24]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A24]=[.B24]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3065,7 +3057,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Accounting</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A25]=[.B25]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A25]=[.B25]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3098,7 +3090,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Earlene McCartney</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A26]=[.B26]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A26]=[.B26]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3131,7 +3123,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Accounting</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A27]=[.B27]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A27]=[.B27]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3141,7 +3133,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3151,7 +3143,7 @@
<table:table-cell office:value-type="float" office:value="0.24"
calcext:value-type="float">
<text:p>0,24</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A29]=[.B29]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A29]=[.B29]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3176,7 +3168,7 @@
<table:table-cell office:value-type="float" office:value="0.24"
calcext:value-type="float">
<text:p>0,24</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A30]=[.B30]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A30]=[.B30]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3198,7 +3190,7 @@
<table:table-cell office:value-type="float" office:value="0.22"
calcext:value-type="float">
<text:p>0,22</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A31]=[.B31]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A31]=[.B31]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3223,7 +3215,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>#N/A</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A32])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A32])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3240,7 +3232,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<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>
@@ -3252,7 +3244,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<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>
@@ -3264,7 +3256,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<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>
@@ -3276,7 +3268,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3286,7 +3278,7 @@
<table:table-cell office:value-type="float" office:value="25000"
calcext:value-type="float">
<text:p>25000</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A37]=[.B37]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A37]=[.B37]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3337,7 +3329,7 @@
<table:table-cell office:value-type="float" office:value="19342"
calcext:value-type="float">
<text:p>19342</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A38]=[.B38]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A38]=[.B38]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3385,7 +3377,7 @@
<table:table-cell office:value-type="float" office:value="0.293"
calcext:value-type="float">
<text:p>0,293</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A39]=[.B39]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A39]=[.B39]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3428,7 +3420,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Q3</text:p>
@@ -3471,7 +3463,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Mia Arnold</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A41]=[.B41]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A41]=[.B41]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3519,7 +3511,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Operations</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A42]=[.B42]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A42]=[.B42]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3562,7 +3554,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3572,7 +3564,7 @@
<table:table-cell office:value-type="float" office:value="110.56"
calcext:value-type="float">
<text:p>110,56</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A44]=[.B44]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A44]=[.B44]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3599,7 +3591,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="3"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Banana</text:p>
@@ -3620,7 +3612,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Grape</text:p>
@@ -3638,7 +3630,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Pear</text:p>
@@ -3656,7 +3648,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Banana</text:p>
@@ -3674,7 +3666,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Cherry</text:p>
@@ -3692,7 +3684,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3702,7 +3694,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>err:504</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A51])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A51])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A51])"
office:value-type="string"
office:string-value="=XLOOKUP("B";H51:H53;K51:K52)"
calcext:value-type="string">
@@ -3735,7 +3727,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>err:504</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A52])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A52])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A52])"
office:value-type="string"
office:string-value="=XLOOKUP("C";H51:H53;K51:K52)"
calcext:value-type="string">
@@ -3768,7 +3760,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>err:504</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A53])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A53])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A53])"
office:value-type="string"
office:string-value="=XLOOKUP("E";H51:I53;K51:L53)"
calcext:value-type="string">
@@ -3801,7 +3793,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>err:504</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A54])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A54])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A54])"
office:value-type="string"
office:string-value="=XLOOKUP("E";H51:I53;K51:K53)"
calcext:value-type="string">
@@ -3820,7 +3812,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>err:504</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=ISERROR([.A55])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=ISERROR([.A55])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A55])"
office:value-type="string"
office:string-value="=XLOOKUP("C";H51:I53;K51:K53)"
calcext:value-type="string">
@@ -3834,7 +3826,7 @@
</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:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3844,7 +3836,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A58]=[.B58]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A58]=[.B58]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3882,7 +3874,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A59]=[.B59]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A59]=[.B59]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3920,7 +3912,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>a5</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A60]=[.B60]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A60]=[.B60]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3958,7 +3950,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A61]=[.B61]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A61]=[.B61]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -3992,7 +3984,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A62]=[.B62]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A62]=[.B62]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4030,7 +4022,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A63]=[.B63]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A63]=[.B63]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4049,7 +4041,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>a5</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A64]=[.B64]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A64]=[.B64]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4068,7 +4060,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A65]=[.B65]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A65]=[.B65]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4083,7 +4075,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A66]=[.B66]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A66]=[.B66]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4102,7 +4094,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A67]=[.B67]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A67]=[.B67]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4121,7 +4113,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>D5.2</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A68]=[.B68]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A68]=[.B68]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4140,7 +4132,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A69]=[.B69]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A69]=[.B69]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4155,7 +4147,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A70]=[.B70]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A70]=[.B70]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4174,7 +4166,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A71]=[.B71]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A71]=[.B71]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4193,7 +4185,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b5</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A72]=[.B72]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A72]=[.B72]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4212,7 +4204,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>c3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A73]=[.B73]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A73]=[.B73]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4227,7 +4219,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A74]=[.B74]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A74]=[.B74]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4262,7 +4254,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A75]=[.B75]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A75]=[.B75]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4297,7 +4289,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>a5</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A76]=[.B76]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A76]=[.B76]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4316,7 +4308,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>b3</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A77]=[.B77]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A77]=[.B77]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<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">
@@ -4330,7 +4322,7 @@
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
- <table:table-cell table:style-name="ce18"/>
+ <table:table-cell table:style-name="ce11"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -4340,7 +4332,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>bC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A79]=[.B79]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A79]=[.B79]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A79])"
office:value-type="string"
office:string-value="=XLOOKUP("C";I$79:I$83;L$79:L$83;;0;1)"
calcext:value-type="string">
@@ -4378,7 +4370,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>bC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A80]=[.B80]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A80]=[.B80]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A80])"
office:value-type="string"
office:string-value="=XLOOKUP("D";I$79:I$83;L$79:L$83;;-1;1)"
calcext:value-type="string">
@@ -4416,7 +4408,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>aE</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A81]=[.B81]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A81]=[.B81]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A81])"
office:value-type="string"
office:string-value="=XLOOKUP("D";I$79:I$83;L$79:L$83;;1;1)"
calcext:value-type="string">
@@ -4454,7 +4446,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>eB</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A82]=[.B82]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A82]=[.B82]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A82])"
office:value-type="string"
office:string-value="=XLOOKUP("b?b";I$84:I$88;L$79:L$83;;2;1)"
calcext:value-type="string">
@@ -4488,7 +4480,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>bC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A83]=[.B83]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A83]=[.B83]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A83])"
office:value-type="string"
office:string-value="=XLOOKUP("C";I$79:I$83;L$79:L$83;;0;-1)"
calcext:value-type="string">
@@ -4526,7 +4518,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>bC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A84]=[.B84]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A84]=[.B84]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A84])"
office:value-type="string"
office:string-value="=XLOOKUP("D";I$79:I$83;L$79:L$83;;-1;-1)"
calcext:value-type="string">
@@ -4549,7 +4541,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>aE</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A85]=[.B85]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A85]=[.B85]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A85])"
office:value-type="string"
office:string-value="=XLOOKUP("D";I$79:I$83;L$79:L$83;;1;-1)"
calcext:value-type="string">
@@ -4572,7 +4564,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>bC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A86]=[.B86]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A86]=[.B86]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A86])"
office:value-type="string"
office:string-value="=XLOOKUP("C";I$79:I$83;L$79:L$83;;2;-1)"
calcext:value-type="string">
@@ -4591,7 +4583,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A87]=[.B87]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A87]=[.B87]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A87])"
office:value-type="string"
office:string-value="=XLOOKUP("C";H$79:H$83;K$79:K$83;;0;2)"
calcext:value-type="string">
@@ -4614,7 +4606,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A88]=[.B88]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A88]=[.B88]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A88])"
office:value-type="string"
office:string-value="=XLOOKUP("D";H$79:H$83;K$79:K$83;;-1;2)"
calcext:value-type="string">
@@ -4637,7 +4629,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>eE</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A89]=[.B89]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A89]=[.B89]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A89])"
office:value-type="string"
office:string-value="=XLOOKUP("D";H$79:H$83;K$79:K$83;;1;2)"
calcext:value-type="string">
@@ -4656,7 +4648,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A90]=[.B90]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A90]=[.B90]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A90])"
office:value-type="string"
office:string-value="=XLOOKUP("C";H$79:H$83;K$79:K$83;;2;2)"
calcext:value-type="string">
@@ -4671,7 +4663,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A91]=[.B91]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A91]=[.B91]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A91])"
office:value-type="string"
office:string-value="=XLOOKUP("C";J$79:J$83;M$79:M$83;;0;-2)"
calcext:value-type="string">
@@ -4690,7 +4682,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A92]=[.B92]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A92]=[.B92]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A92])"
office:value-type="string"
office:string-value="=XLOOKUP("D";J$79:J$83;M$79:M$83;;-1;-2)"
calcext:value-type="string">
@@ -4709,7 +4701,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>eE</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A93]=[.B93]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce11"
table:formula="of:=[.A93]=[.B93]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A93])"
office:value-type="string"
office:string-value="=XLOOKUP("D";J$79:J$83;M$79:M$83;;1;-2)"
calcext:value-type="string">
@@ -4728,7 +4720,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>cC</text:p>
</table:table-cell>
-e
... etc. - the rest is truncated
