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 <xiscofauli@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 5e881df..23a98aa 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 c29ee2e..4a34f34 100644
--- a/sc/qa/unit/data/functions/logical/fods/switch.fods
+++ b/sc/qa/unit/data/functions/logical/fods/switch.fods
@@ -3658,6 +3658,35 @@
<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"/>
<table:table-cell table:style-name="ce23"/>
@@ -5543,4 +5572,4 @@
</table:named-expressions>
</office:spreadsheet>
</office:body>
</office:document>
\ No newline at end of file
</office:document>
