tdf#148843: sc_mathematical_functions: Add unittest
Change-Id: Iea71c3fd92a471814c27bebda74bbe8b30d706f5
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134040
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods b/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods
index e7042ae..19b9145 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods
@@ -2541,6 +2541,31 @@
<table:table-cell table:number-columns-repeated="8"/>
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:formula="of:=COM.MICROSOFT.AGGREGATE(9;6;[.M38];[.N38];[.O38])" office:value-type="float" office:value="18" calcext:value-type="float">
<text:p>18</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="18" calcext:value-type="float">
<text:p>18</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce25" table:formula="of:=[.A38]=[.B38]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=FORMULA([.A38])" office:value-type="string" office:string-value="=AGGREGATE(9;6;M38;N38;O38)" calcext:value-type="string">
<text:p>=AGGREGATE(9;6;M38;N38;O38)</text:p>
</table:table-cell>
<table:table-cell table:number-columns-repeated="8"/>
<table:table-cell office:value-type="float" office:value="13" calcext:value-type="float">
<text:p>13</text:p>
</table:table-cell>
<table:table-cell table:formula="of:=[.M38]/0" office:value-type="string" office:string-value="" calcext:value-type="error">
<text:p>#DIV/0!</text:p>
</table:table-cell>
<table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell table:number-columns-repeated="4"/>
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
<table:table-cell table:style-name="ce24"/>
<table:table-cell table:number-columns-repeated="16"/>
