core.git: sc/qa

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/functions/mathematical/fods/sumif.fods |   18 +++++++++++++++++
 1 file changed, 18 insertions(+)

New commits:
commit d804d6aff49054bad1719ec3c2d136b545bbc7e7
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Jun 3 12:49:58 2024 +0200
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon Jun 3 15:49:54 2024 +0200

    tdf#158789: sc_mathematical_functions: Add unittest
    
    Change-Id: Ia19dadffa511cb012e4d0271e1e3768e1e374be0
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/168365
    Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
    Tested-by: Jenkins

diff --git a/sc/qa/unit/data/functions/mathematical/fods/sumif.fods 
b/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
index d51a06ec3697..b23883520260 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/sumif.fods
@@ -2624,6 +2624,24 @@
      <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: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"/>