sc/qa/unit/data/functions/logical/fods/iferror.fods | 50 ++++++++++++++++++--
1 file changed, 45 insertions(+), 5 deletions(-)
New commits:
commit 2a5b87316625d3f5cd735f01376c263dc40e7c81
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Dec 27 11:02:52 2021 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon Dec 27 14:55:08 2021 +0100
tdf#146377: sc_logical_functions_test: Add unittest
Change-Id: Ia844ad53ec460abeb1ef7874ad88eeac9c6bf5a7
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/127550
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/logical/fods/iferror.fods
b/sc/qa/unit/data/functions/logical/fods/iferror.fods
index ee03a86d3e94..ed66dcabd71a 100644
--- a/sc/qa/unit/data/functions/logical/fods/iferror.fods
+++ b/sc/qa/unit/data/functions/logical/fods/iferror.fods
@@ -2054,6 +2054,46 @@
<table:table-cell table:style-name="ce51"
table:number-columns-repeated="3"/>
<table:table-cell/>
</table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce28"
table:formula="of:=IF(NA();1;IFERROR(NA();2))" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p>#N/A</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce34" office:value-type="string"
calcext:value-type="string">
+ <text:p>#N/A</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce41"
table:formula="of:=ISNA([.A22])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>PRAVDA</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce43"
table:formula="of:=FORMULA([.A22])" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p>=IF(NA();1;IFERROR(NA();2))</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce25"/>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce51"
table:number-columns-repeated="3"/>
+ <table:table-cell/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce28"
table:formula="of:=AND(NA();IFERROR(NA();1))" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p>#N/A</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce34" office:value-type="string"
calcext:value-type="string">
+ <text:p>#N/A</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce41"
table:formula="of:=ISNA([.A23])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>PRAVDA</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce43"
table:formula="of:=FORMULA([.A23])" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p>=AND(NA();IFERROR(NA();1))</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce25"/>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce51"
table:number-columns-repeated="3"/>
+ <table:table-cell/>
+ </table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell/>
<table:table-cell table:style-name="ce33"/>
@@ -2198,12 +2238,12 @@
<table:table-cell table:number-columns-repeated="15"/>
</table:table-row>
<calcext:conditional-formats>
- <calcext:conditional-format
calcext:target-range-address="Sheet2.C2:Sheet2.C4 Sheet2.C14:Sheet2.C19">
+ <calcext:conditional-format
calcext:target-range-address="Sheet2.C2:Sheet2.C4 Sheet2.C14:Sheet2.C50">
<calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet2.C2"/>
<calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
<calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
</calcext:conditional-format>
- <calcext:conditional-format
calcext:target-range-address="Sheet2.C4:Sheet2.C4 Sheet2.C14:Sheet2.C19">
+ <calcext:conditional-format
calcext:target-range-address="Sheet2.C4:Sheet2.C4 Sheet2.C14:Sheet2.C50">
<calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet2.C4"/>
<calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet2.C4"/>
<calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet2.C4"/>
@@ -2218,12 +2258,12 @@
<calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet2.C5"/>
<calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet2.C5"/>
</calcext:conditional-format>
- <calcext:conditional-format
calcext:target-range-address="Sheet2.C7:Sheet2.C19">
+ <calcext:conditional-format
calcext:target-range-address="Sheet2.C7:Sheet2.C50">
<calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet2.C7"/>
<calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet2.C7"/>
<calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet2.C7"/>
</calcext:conditional-format>
- <calcext:conditional-format
calcext:target-range-address="Sheet2.C7:Sheet2.C19">
+ <calcext:conditional-format
calcext:target-range-address="Sheet2.C7:Sheet2.C50">
<calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet2.C7"/>
<calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet2.C7"/>
<calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet2.C7"/>
@@ -2261,4 +2301,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
