sc/qa/unit/data/functions/mathematical/fods/aggregate.fods | 25 +++++++++++++
1 file changed, 25 insertions(+)
New commits:
commit 7d0b19f3ea3932c9c9bd73604987373681440a1c
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon May 9 11:16:43 2022 +0200
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon May 9 16:01:24 2022 +0200
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 <xiscofa...@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 e7042ae9b6ea..19b91451330c 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/aggregate.fods
@@ -2540,6 +2540,31 @@
</table:table-cell>
<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"/>
