commit d804d6aff49054bad1719ec3c2d136b545bbc7e7
author Xisco Fauli <xiscofauli@libreoffice.org> Mon Jun 03 12:49:58 2024 +0200
committer Xisco Fauli <xiscofauli@libreoffice.org> Mon Jun 03 15:49:54 2024 +0200
tree d65c1a365c7050c71eeca2a71de4c967e2223007
parent d5c5732ada2f9f616e26ef514676adee2245c5e5

tdf#158789: sc_mathematical_functions: Add unittest

Change-Id: Ia19dadffa511cb012e4d0271e1e3768e1e374be0
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/168365
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
Tested-by: Jenkins

sc/qa/unit/data/functions/mathematical/fods/sumif.fods

diff --git a/sc/qa/unit/data/functions/mathematical/fods/sumif.fods b/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
index d51a06e..b238835 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
@@ -2625,6 +2625,24 @@
     <table:table-cell table:number-columns-repeated="17"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=SUMIF({-10|10|20|30};&quot;&gt;0&quot;)" office:value-type="float" office:value="60" calcext:value-type="float">
      <text:p>60</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="60" calcext:value-type="float">
      <text:p>60</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce15" table:formula="of:=[.A31]=[.B31]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>TRUE</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce58" table:formula="of:=FORMULA([.A31])" office:value-type="string" office:string-value="=SUMIF({-10;10;20;30};&quot;&gt;0&quot;)" calcext:value-type="string">
      <text:p>=SUMIF({-10;10;20;30};&quot;&gt;0&quot;)</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce45"/>
     <table:table-cell table:number-columns-repeated="4"/>
     <table:table-cell table:style-name="ce62"/>
     <table:table-cell table:number-columns-repeated="17"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:number-columns-repeated="2"/>
     <table:table-cell table:style-name="ce16"/>
     <table:table-cell table:number-columns-repeated="24"/>