sc/qa/unit/data/functions/logical/fods/ifs.fods | 48 ++++++++++++++++++++-
sc/qa/unit/data/functions/logical/fods/switch.fods | 31 +++++++++++++
2 files changed, 77 insertions(+), 2 deletions(-)
New commits:
commit 9d5ec2c9d0bf8765fc75c17a0e6fdcb2583335d0
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Mar 14 14:15:42 2022 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon Mar 14 15:25:42 2022 +0100
tdf#111675: sc_logical_functions: Add unittest
Change-Id: I72f158007f456fd70149fcfd6029a0157e47837c
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/131539
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/logical/fods/ifs.fods
b/sc/qa/unit/data/functions/logical/fods/ifs.fods
index 5e881dfeb641..23a98aa78480 100644
--- a/sc/qa/unit/data/functions/logical/fods/ifs.fods
+++ b/sc/qa/unit/data/functions/logical/fods/ifs.fods
@@ -3821,6 +3821,52 @@
<table:table-cell table:style-name="ce11"
table:number-columns-repeated="4"/>
<table:table-cell table:number-columns-repeated="2"/>
</table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:formula="of:=COM.MICROSOFT.IFS(0;1/0;1;TRUE())"
office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce69" table:formula="of:TRUE()"
office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce73"
table:formula="of:=[.A16]=[.B16]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce76"
table:formula="of:=FORMULA([.A16])" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce71"/>
+ <table:table-cell table:style-name="ce81"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce84"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce81"/>
+ <table:table-cell table:style-name="ce86"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce11"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce86"/>
+ <table:table-cell table:style-name="ce11"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5" table:number-rows-repeated="4">
+ <table:table-cell table:style-name="science"/>
+ <table:table-cell table:style-name="ce69"/>
+ <table:table-cell table:style-name="ce73"/>
+ <table:table-cell table:style-name="ce76"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce71"/>
+ <table:table-cell table:style-name="ce81"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce84"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce81"/>
+ <table:table-cell table:style-name="ce86"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce11"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce86"/>
+ <table:table-cell table:style-name="ce11"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
<table:table-row table:style-name="ro5" table:number-rows-repeated="4">
<table:table-cell table:style-name="science"/>
<table:table-cell table:style-name="ce69"/>
@@ -5649,4 +5695,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/logical/fods/switch.fods
b/sc/qa/unit/data/functions/logical/fods/switch.fods
index c29ee2e5e74b..4a34f34345a7 100644
--- a/sc/qa/unit/data/functions/logical/fods/switch.fods
+++ b/sc/qa/unit/data/functions/logical/fods/switch.fods
@@ -3657,6 +3657,35 @@
<table:table-cell table:style-name="ce18"
table:number-columns-repeated="4"/>
<table:table-cell table:number-columns-repeated="2"/>
</table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce13"
table:formula="of:=COM.MICROSOFT.SWITCH(1;0;1/0;1;TRUE())"
office:value-type="string" office:string-value="" calcext:value-type="string">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce69" table:formula="of:TRUE()"
office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce23"
table:formula="of:=[.A11]=[.B11]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce32"
table:formula="of:=FORMULA([.A11])" office:value-type="string"
office:string-value="" calcext:value-type="string">
+ <text:p></text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce13"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce42"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce11"/>
+ <table:table-cell table:style-name="ce18"
table:number-columns-repeated="2"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce38"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce18"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
<table:table-row table:style-name="ro5">
<table:table-cell/>
<table:table-cell table:style-name="ce37"/>
@@ -5543,4 +5572,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
-</office:document>
\ No newline at end of file
+</office:document>
