[Libreoffice-commits] core.git: sc/qa

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/functions/statistical/fods/countif.fods |   48 ++++++++++++++++
 1 file changed, 48 insertions(+)

New commits:
commit 8bd91a40eae95f38c15d570d6af87b997c7eee39
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon May 9 10:55:53 2022 +0200
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon May 9 14:18:03 2022 +0200

    tdf#148948: sc_statistical_functions: Add unittest
    
    Change-Id: I9dd5010931991001215102a2764f7faa67412676
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134038
    Tested-by: Jenkins
    Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>

diff --git a/sc/qa/unit/data/functions/statistical/fods/countif.fods 
b/sc/qa/unit/data/functions/statistical/fods/countif.fods
index 1277ebcd9452..3e77a2ed49c8 100644
--- a/sc/qa/unit/data/functions/statistical/fods/countif.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/countif.fods
@@ -3999,6 +3999,54 @@
      <table:table-cell table:style-name="ce56"/>
      <table:table-cell table:style-name="ce58"/>
     </table:table-row>
+    <table:table-row table:style-name="ro2">
+     <table:table-cell table:formula="of:=COUNTIF([.I44:.L44];&quot;=&quot;)" 
office:value-type="float" office:value="4" calcext:value-type="float">
+      <text:p>4</text:p>
+     </table:table-cell>
+     <table:table-cell office:value-type="float" office:value="3" 
calcext:value-type="float">
+      <text:p>3</text:p>
+     </table:table-cell>
+     <table:table-cell table:style-name="ce65" 
table:formula="of:=ROUND([.A44];12)=ROUND([.B44];12)" 
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([.A44])" 
office:value-type="string" 
office:string-value="=COUNTIF(I44:L44;&quot;=&quot;)" 
calcext:value-type="string">
+      <text:p>=COUNTIF(I44:L44;&quot;=&quot;)</text:p>
+     </table:table-cell>
+     <table:table-cell office:value-type="string" calcext:value-type="string">
+      <text:p><text:s/>Tdf#148948</text:p>
+     </table:table-cell>
+     <table:table-cell table:number-columns-repeated="3"/>
+     <table:table-cell table:style-name="ce20" 
table:formula="of:=&quot;&quot;">
+      <text:p/>
+     </table:table-cell>
+     <table:table-cell table:number-columns-repeated="16"/>
+     <table:table-cell table:style-name="ce56"/>
+     <table:table-cell table:style-name="ce58"/>
+    </table:table-row>
+    <table:table-row table:style-name="ro2">
+     <table:table-cell 
table:formula="of:=COUNTIF([.I45:.L45];&quot;&lt;&gt;&quot;)" 
office:value-type="float" office:value="0" calcext:value-type="float">
+      <text:p>0</text:p>
+     </table:table-cell>
+     <table:table-cell office:value-type="float" office:value="1" 
calcext:value-type="float">
+      <text:p>1</text:p>
+     </table:table-cell>
+     <table:table-cell table:style-name="ce65" 
table:formula="of:=ROUND([.A45];12)=ROUND([.B45];12)" 
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([.A45])" 
office:value-type="string" 
office:string-value="=COUNTIF(I45:L45;&quot;&lt;&gt;&quot;)" 
calcext:value-type="string">
+      <text:p>=COUNTIF(I45:L45;&quot;&lt;&gt;&quot;)</text:p>
+     </table:table-cell>
+     <table:table-cell office:value-type="string" calcext:value-type="string">
+      <text:p><text:s/>Tdf#148948</text:p>
+     </table:table-cell>
+     <table:table-cell table:number-columns-repeated="3"/>
+     <table:table-cell table:style-name="ce20" 
table:formula="of:=&quot;&quot;">
+      <text:p/>
+     </table:table-cell>
+     <table:table-cell table:number-columns-repeated="16"/>
+     <table:table-cell table:style-name="ce56"/>
+     <table:table-cell table:style-name="ce58"/>
+    </table:table-row>
     <table:table-row table:style-name="ro2">
      <table:table-cell table:number-columns-repeated="2"/>
      <table:table-cell table:style-name="ce64"/>