diff options
author | Xisco Fauli <xiscofauli@libreoffice.org> | 2022-05-09 11:16:43 +0200 |
---|---|---|
committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2022-05-09 16:01:24 +0200 |
commit | 7d0b19f3ea3932c9c9bd73604987373681440a1c (patch) | |
tree | fff4b48cbe7a937ebf7c97ad42fb7979b888fb41 /sc/qa/unit/data | |
parent | 8bd91a40eae95f38c15d570d6af87b997c7eee39 (diff) |
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>
Diffstat (limited to 'sc/qa/unit/data')
-rw-r--r-- | sc/qa/unit/data/functions/mathematical/fods/aggregate.fods | 25 |
1 files changed, 25 insertions, 0 deletions
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 @@ -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"/> |