sc/inc/document.hxx | 3
sc/inc/queryevaluator.hxx | 3
sc/inc/queryiter.hxx | 2
sc/inc/rangecache.hxx | 2
sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods | 375 ++++++++--------
sc/qa/unit/data/functions/spreadsheet/fods/xmatch.fods | 38 +
sc/source/core/data/documen2.cxx | 5
sc/source/core/data/queryevaluator.cxx | 4
sc/source/core/data/queryiter.cxx | 20
sc/source/core/tool/rangecache.cxx | 10
10 files changed, 267 insertions(+), 195 deletions(-)
New commits:
commit f5f5ff719f30fccd207e36627f2e42b34d0a6fb1
Author: Balazs Varga <balazs.varga.ext...@allotropia.de>
AuthorDate: Wed Jun 26 19:12:07 2024 +0200
Commit: Balazs Varga <balazs.varga.ext...@allotropia.de>
CommitDate: Thu Jun 27 18:06:21 2024 +0200
Related: tdf#127293 Ignore 'search-criteria-must-apply-to-whole-cell'
dependency for XLOOKUP and XMATCH because of better compatibility.
The idea is to specify, that the global setting
'search-criteria-must-apply-to-whole-cell'
is ignored and XMATCH and XLOOKUP always behaves as if
'search-criteria-must-apply-to-whole-cell'=true.
That would affect exact search in Match_mode value 0. Users would need to
use wildcard or regex
to get a match to part of the content. But removing dependency to the
global setting increases
interoperability with MS Excel.
Also the ODF TC will follow that in the final specification of these
functions:
https://issues.oasis-open.org/browse/OFFICE-4154
Follow-up commit: 17d578ba91f9c78a0e41d19b58183d2214c0b7a4
(Related: tdf#127293 Add new Match_mode option for XLOOKUP and XMATCH
functions.)
Change-Id: I1317865631d2925eaff72e9c1425d93386c3d016
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/169582
Reviewed-by: Balazs Varga <balazs.varga.ext...@allotropia.de>
Reviewed-by: Regina Henschel <rb.hensc...@t-online.de>
Tested-by: Jenkins
diff --git a/sc/inc/document.hxx b/sc/inc/document.hxx
index d0e825721740..2f67225bf8ec 100644
--- a/sc/inc/document.hxx
+++ b/sc/inc/document.hxx
@@ -1425,7 +1425,8 @@ public:
doesn't already exist. */
ScLookupCache & GetLookupCache( const ScRange & rRange,
ScInterpreterContext* pContext );
ScSortedRangeCache & GetSortedRangeCache( const ScRange & rRange, const
ScQueryParam& param,
- ScInterpreterContext* pContext,
sal_uInt8 nSortedBinarySearch = 0x00 );
+ ScInterpreterContext* pContext,
bool bNewSearchFunction,
+ sal_uInt8 nSortedBinarySearch =
0x00 );
/** Only ScLookupCache dtor uses RemoveLookupCache(), do
not use elsewhere! */
void RemoveLookupCache( ScLookupCache & rCache );
diff --git a/sc/inc/queryevaluator.hxx b/sc/inc/queryevaluator.hxx
index 351531b9731c..6d3012141db8 100644
--- a/sc/inc/queryevaluator.hxx
+++ b/sc/inc/queryevaluator.hxx
@@ -108,7 +108,8 @@ class ScQueryEvaluator
public:
ScQueryEvaluator(ScDocument& rDoc, const ScTable& rTab, const
ScQueryParam& rParam,
- ScInterpreterContext* pContext = nullptr, bool*
pTestEqualCondition = nullptr);
+ ScInterpreterContext* pContext = nullptr, bool*
pTestEqualCondition = nullptr,
+ bool bNewSearchFunction = false);
bool ValidQuery(SCROW nRow, const ScRefCellValue* pCell = nullptr,
sc::TableColumnBlockPositionSet* pBlockPos = nullptr);
diff --git a/sc/inc/queryiter.hxx b/sc/inc/queryiter.hxx
index 9d0ab1cc6aea..67f0e16fc0b5 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(sal_uInt8 nSortedBinarySearch = 0x00);
+ void InitPosStart(bool bNewSearchFunction, sal_uInt8 nSortedBinarySearch =
0x00);
void InitPosFinish( SCROW beforeRow, SCROW lastRow, bool bFirstMatch );
void InitPosColFinish( SCCOL beforeCol, SCCOL lastCol, bool bFirstMatch );
void IncPos() { IncPosImpl<false>(); }
diff --git a/sc/inc/rangecache.hxx b/sc/inc/rangecache.hxx
index 5a9553e764ff..4f0e810db0a8 100644
--- a/sc/inc/rangecache.hxx
+++ b/sc/inc/rangecache.hxx
@@ -47,7 +47,7 @@ public:
/// MUST be new'd because Notify() deletes.
ScSortedRangeCache(ScDocument* pDoc, const ScRange& rRange, const
ScQueryParam& param,
ScInterpreterContext* context, bool invalid = false,
- sal_uInt8 nSortedBinarySearch = 0x00);
+ bool bNewSearchFunction = 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 633153fd5b40..593054bf4682 100644
--- a/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
+++ b/sc/qa/unit/data/functions/spreadsheet/fods/xlookup.fods
@@ -1,13 +1,13 @@
<?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>PT1H51M31S</meta:editing-duration><meta:editing-cycles>33</meta:editing-cycles><meta:generator>LibreOfficeDev/24.8.0.0.alpha1$Windows_X86_64
LibreOffice_project/d3ae30f41573c7cb5b4cd6244c1ccd8010f966d7</meta:generator><dc:date>2024-06-03T13:56:08.658000000</dc:date><meta:document-statistic
meta:table-count="2" meta:cell-count="962"
meta:object-count="0"/></office:meta>
+
<office:meta><meta:creation-date>2024-01-16T18:30:06.278000000</meta:creation-date><meta:editing-duration>PT1H56M5S</meta:editing-duration><meta:editing-cycles>34</meta:editing-cycles><meta:generator>LibreOfficeDev/25.2.0.0.alpha0$Windows_X86_64
LibreOffice_project/449050477173ff56b3f3d94406913b261f541b0f</meta:generator><dc:date>2024-06-26T18:39:33.496000000</dc:date><meta:document-statistic
meta:table-count="2" meta:cell-count="962"
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>
<config:config-item config:name="VisibleAreaLeft"
config:type="int">0</config:config-item>
- <config:config-item config:name="VisibleAreaWidth"
config:type="int">60486</config:config-item>
- <config:config-item config:name="VisibleAreaHeight"
config:type="int">61863</config:config-item>
+ <config:config-item config:name="VisibleAreaWidth"
config:type="int">15882</config:config-item>
+ <config:config-item config:name="VisibleAreaHeight"
config:type="int">5013</config:config-item>
<config:config-item-map-indexed config:name="Views">
<config:config-item-map-entry>
<config:config-item config:name="ViewId"
config:type="string">view1</config:config-item>
@@ -30,13 +30,13 @@
<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">4</config:config-item>
- <config:config-item config:name="CursorPositionY"
config:type="int">85</config:config-item>
+ <config:config-item config:name="CursorPositionX"
config:type="int">2</config:config-item>
+ <config:config-item config:name="CursorPositionY"
config:type="int">32</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">30</config:config-item>
+ <config:config-item config:name="PositionBottom"
config:type="int">99</config:config-item>
<config:config-item config:name="ZoomType"
config:type="short">0</config:config-item>
<config:config-item config:name="ZoomValue"
config:type="int">100</config:config-item>
<config:config-item config:name="PageViewZoomValue"
config:type="int">60</config:config-item>
@@ -48,7 +48,7 @@
</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">2495</config:config-item>
+ <config:config-item config:name="HorizontalScrollbarWidth"
config:type="int">1539</config:config-item>
<config:config-item config:name="ZoomType"
config:type="short">0</config:config-item>
<config:config-item config:name="ZoomValue"
config:type="int">100</config:config-item>
<config:config-item config:name="PageViewZoomValue"
config:type="int">60</config:config-item>
@@ -2001,7 +2001,7 @@
<style:table-column-properties fo:break-before="auto"
style:column-width="3.341cm"/>
</style:style>
<style:style style:name="co6" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="1.473cm"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="1.727cm"/>
</style:style>
<style:style style:name="co7" style:family="table-column">
<style:table-column-properties fo:break-before="auto"
style:column-width="13.19cm"/>
@@ -2036,10 +2036,6 @@
<number:text-style style:name="N100">
<number:text-content/>
</number:text-style>
- <style:style style:name="ce9" 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:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
<style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
@@ -2057,12 +2053,59 @@
<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="ce23" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm"/>
+ <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold"
style:font-weight-complex="bold"/>
+ <style: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="ce27" 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="ce28" 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="ce5" style:family="table-cell"
style:parent-style-name="Default">
<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="ce23" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce9" 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="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="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="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="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"/>
+ <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: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="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"/>
@@ -2070,17 +2113,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="ce27" 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="ce28" 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="ce30" 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"/>
@@ -2141,7 +2184,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-06-03">0000.00.00</text:date>, <text:time
style:data-style-name="N2"
text:time-value="13:50:06.397000000">00:00:00</text:time></text:p>
+ <text:p><text:date style:data-style-name="N2"
text:date-value="2024-06-26">0000.00.00</text:date>, <text:time
style:data-style-name="N2"
text:time-value="18:35:00.500000000">00:00:00</text:time></text:p>
</style:region-right>
</style:header>
<style:header-left style:display="false"/>
@@ -2155,13 +2198,13 @@
</office:master-styles>
<office:body>
<office:spreadsheet>
- <table:calculation-settings table:automatic-find-labels="false"
table:use-regular-expressions="false" table:use-wildcards="true"/>
+ <table:calculation-settings
table:search-criteria-must-apply-to-whole-cell="false"
table:automatic-find-labels="false" table:use-regular-expressions="false"
table:use-wildcards="true"/>
<table:table table:name="Sheet1" table:style-name="ta1">
<table:table-column table:style-name="co1"
table:default-cell-style-name="Default"/>
- <table:table-column table:style-name="co2"
table:default-cell-style-name="ce5"/>
+ <table:table-column table:style-name="co2"
table:default-cell-style-name="ce22"/>
<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"/>
@@ -2173,10 +2216,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="ce17"
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/>
@@ -2185,13 +2228,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="ce23" 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>
@@ -2199,16 +2242,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="ce17"
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="ce28" 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="ce27"/>
+ <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">
@@ -2299,7 +2342,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="ce30" 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">
@@ -2342,7 +2385,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="ce30" 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">
@@ -2382,7 +2425,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="ce30" 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">
@@ -2425,7 +2468,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="ce30" 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">
@@ -2468,7 +2511,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="ce30" 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">
@@ -2508,7 +2551,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="ce30" 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">
@@ -2545,7 +2588,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="ce30" 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">
@@ -2588,7 +2631,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="ce30" 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">
@@ -2631,7 +2674,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="ce30"
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">
@@ -2671,7 +2714,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="ce30"
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">
@@ -2706,7 +2749,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Mexico</text:p>
@@ -2727,7 +2770,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -2737,7 +2780,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="ce30"
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">
@@ -2789,7 +2832,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="ce30"
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">
@@ -2838,7 +2881,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="ce30"
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">
@@ -2887,7 +2930,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="ce30"
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">
@@ -2902,7 +2945,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="ce30"
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">
@@ -2921,7 +2964,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="ce30"
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">
@@ -2936,7 +2979,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="ce30"
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">
@@ -2951,7 +2994,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="ce30"
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">
@@ -2966,7 +3009,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="ce30"
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">
@@ -2998,7 +3041,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="ce30"
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">
@@ -3030,7 +3073,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="ce30"
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">
@@ -3059,7 +3102,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="ce30"
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">
@@ -3092,7 +3135,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="ce30"
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">
@@ -3125,7 +3168,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="ce30"
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">
@@ -3135,7 +3178,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3145,7 +3188,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="ce30"
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">
@@ -3170,7 +3213,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="ce30"
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">
@@ -3192,7 +3235,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="ce30"
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">
@@ -3214,10 +3257,10 @@
<table:table-cell
table:formula="of:=COM.MICROSOFT.XLOOKUP([.G29];[.I30:.I35];[.H30:.H35];;2;2)"
office:value-type="string" office:string-value="" calcext:value-type="error">
<text:p>#VALUE!</text:p>
</table:table-cell>
- <table:table-cell office:value-type="string" calcext:value-type="string">
- <text:p>#N/A</text:p>
+ <table:table-cell table:formula="of:=ORG.OPENOFFICE.ERRORTYPE([.A32])"
office:value-type="float" office:value="519" calcext:value-type="float">
+ <text:p>519</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="ce30" table:formula="of:=[.B32]=519"
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">
@@ -3234,7 +3277,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="ce30"/>
<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>
@@ -3246,7 +3289,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="ce30"/>
<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>
@@ -3258,7 +3301,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="ce30"/>
<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>
@@ -3270,7 +3313,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3280,7 +3323,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="ce30"
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">
@@ -3331,7 +3374,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="ce30"
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">
@@ -3379,7 +3422,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="ce30"
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">
@@ -3422,7 +3465,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Q3</text:p>
@@ -3465,7 +3508,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="ce30"
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">
@@ -3513,7 +3556,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="ce30"
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">
@@ -3556,7 +3599,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3566,7 +3609,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="ce30"
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">
@@ -3593,7 +3636,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="ce30"/>
<table:table-cell table:number-columns-repeated="3"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Banana</text:p>
@@ -3614,7 +3657,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Grape</text:p>
@@ -3632,7 +3675,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Pear</text:p>
@@ -3650,7 +3693,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Banana</text:p>
@@ -3668,7 +3711,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Cherry</text:p>
@@ -3686,7 +3729,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3696,7 +3739,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="ce30"
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">
@@ -3729,7 +3772,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="ce30"
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">
@@ -3762,7 +3805,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="ce30"
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">
@@ -3795,7 +3838,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="ce30"
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">
@@ -3814,7 +3857,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="ce30"
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">
@@ -3828,7 +3871,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -3838,7 +3881,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="ce30"
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">
@@ -3876,7 +3919,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="ce30"
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">
@@ -3914,7 +3957,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="ce30"
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">
@@ -3952,7 +3995,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="ce30"
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">
@@ -3986,7 +4029,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="ce30"
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">
@@ -4024,7 +4067,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="ce30"
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">
@@ -4043,7 +4086,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="ce30"
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">
@@ -4062,7 +4105,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="ce30"
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">
@@ -4077,7 +4120,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="ce30"
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">
@@ -4096,7 +4139,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="ce30"
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">
@@ -4115,7 +4158,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="ce30"
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">
@@ -4134,7 +4177,7 @@
<table:table-cell table:formula="of:=ORG.OPENOFFICE.ERRORTYPE([.A69])"
office:value-type="float" office:value="519" calcext:value-type="float">
<text:p>519</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.B69]=519"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30" table:formula="of:=[.B69]=519"
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">
@@ -4152,7 +4195,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="ce30"
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">
@@ -4171,7 +4214,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="ce30"
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">
@@ -4190,7 +4233,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="ce30"
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">
@@ -4209,7 +4252,7 @@
<table:table-cell table:formula="of:=ORG.OPENOFFICE.ERRORTYPE([.A73])"
office:value-type="float" office:value="519" calcext:value-type="float">
<text:p>519</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18" table:formula="of:=[.B73]=519"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30" table:formula="of:=[.B73]=519"
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 +4270,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="ce30"
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 +4305,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="ce30"
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 +4340,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="ce30"
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 +4359,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="ce30"
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 +4373,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -4340,7 +4383,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="ce30"
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 +4421,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="ce30"
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 +4459,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="ce30"
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 +4497,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="ce30"
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 +4531,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="ce30"
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 +4569,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="ce30"
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 +4592,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="ce30"
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 +4615,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="ce30"
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 +4634,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="ce30"
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 +4657,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="ce30"
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 +4680,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="ce30"
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">
@@ -4651,7 +4694,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -4661,7 +4704,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="ce30"
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">
@@ -4680,7 +4723,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="ce30"
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">
@@ -4699,7 +4742,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="ce30"
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">
@@ -4713,7 +4756,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -4723,7 +4766,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:=[.A95]=[.B95]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A95]=[.B95]" 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([.A95])"
office:value-type="string"
office:string-value="=XLOOKUP("C";H$95:L$95;H$96:L$96;;0;1)"
calcext:value-type="string">
@@ -4758,7 +4801,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:=[.A96]=[.B96]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A96]=[.B96]" 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([.A96])"
office:value-type="string"
office:string-value="=XLOOKUP("D";H$95:L$95;H$96:L$96;;-1;1)"
calcext:value-type="string">
@@ -4793,7 +4836,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:=[.A97]=[.B97]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A97]=[.B97]" 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([.A97])"
office:value-type="string"
office:string-value="=XLOOKUP("D";H$95:L$95;H$96:L$96;;1;1)"
calcext:value-type="string">
@@ -4812,7 +4855,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([.A98])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=ISERROR([.A98])" 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([.A98])"
office:value-type="string"
office:string-value="=XLOOKUP("C?";H$95:L$95;H$96:L$96;;2;1)"
calcext:value-type="string">
@@ -4822,7 +4865,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="ce30"/>
<table:table-cell table:number-columns-repeated="4"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>LookCol</text:p>
@@ -4864,7 +4907,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:=[.A100]=[.B100]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A100]=[.B100]" 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([.A100])"
office:value-type="string"
office:string-value="=XLOOKUP("c";I$79:I$83;L$79:L$83;;0;1)"
calcext:value-type="string">
@@ -4909,7 +4952,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:=[.A101]=[.B101]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A101]=[.B101]" 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([.A101])"
office:value-type="string"
office:string-value="=XLOOKUP("d";I$79:I$83;L$79:L$83;;-1;1)"
calcext:value-type="string">
@@ -4935,7 +4978,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:=[.A102]=[.B102]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A102]=[.B102]" 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([.A102])"
office:value-type="string"
office:string-value="=XLOOKUP("d";I$79:I$83;L$79:L$83;;1;1)"
calcext:value-type="string">
@@ -4961,7 +5004,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([.A103])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=ISERROR([.A103])" 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([.A103])"
office:value-type="string"
office:string-value="=XLOOKUP("f?";I$79:I$83;L$79:L$83;;2;1)"
calcext:value-type="string">
@@ -4983,7 +5026,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>g</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A104]=[.B104]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A104]=[.B104]" 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([.A104])"
office:value-type="string"
office:string-value="=XLOOKUP(K99;H$99:H$109;I$99:I$109;;-1;-1)"
calcext:value-type="string">
@@ -5005,7 +5048,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>a</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A105]=[.B105]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A105]=[.B105]" 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([.A105])"
office:value-type="string"
office:string-value="=XLOOKUP(K99;N$99:R$99;N$100:R$100;;-1;-1)"
calcext:value-type="string">
@@ -5027,7 +5070,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>BR</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A106]=[.B106]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A106]=[.B106]" 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([.A106])"
office:value-type="string"
office:string-value="=XLOOKUP($M$1;K$1:K$12;I$1:I$12;0;1;2)"
calcext:value-type="string">
@@ -5049,7 +5092,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>BR</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A107]=[.B107]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A107]=[.B107]" 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([.A107])"
office:value-type="string"
office:string-value="=XLOOKUP($M$1;L$1:L$12;I$1:I$12;0;1;-2)"
calcext:value-type="string">
@@ -5071,7 +5114,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>ID</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A108]=[.B108]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A108]=[.B108]" 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([.A108])"
office:value-type="string"
office:string-value="=XLOOKUP($M$1;K$1:K$12;I$1:I$12;0;-1;2)"
calcext:value-type="string">
@@ -5093,7 +5136,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>PK</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A109]=[.B109]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A109]=[.B109]" 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([.A109])"
office:value-type="string"
office:string-value="=XLOOKUP(M1;L$1:L$12;I$1:I$12;0;-1;-2)"
calcext:value-type="string">
@@ -5115,7 +5158,7 @@
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>PK</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce18"
table:formula="of:=[.A110]=[.B110]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=[.A110]=[.B110]" 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([.A110])"
office:value-type="string"
office:string-value="=XLOOKUP(N1;L$1:L$12;I$1:I$12;0;0;-2)"
calcext:value-type="string">
@@ -5130,7 +5173,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([.A111])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=ISERROR([.A111])" 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([.A111])"
office:value-type="string"
office:string-value="=XLOOKUP(M1;K$1:K$12;I$1:I$12;;0;2)"
calcext:value-type="string">
@@ -5140,7 +5183,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="ce30"/>
<table:table-cell table:number-columns-repeated="17"/>
</table:table-row>
<table:table-row table:style-name="ro2">
@@ -5150,7 +5193,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([.A113])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce30"
table:formula="of:=ISERROR([.A113])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>IGAZ</text:p>
</table:table-cell>
-e
... etc. - the rest is truncated
