diff options
| author | Xisco Fauli <xiscofauli@libreoffice.org> | 2022-05-09 10:55:53 +0200 |
|---|---|---|
| committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2022-05-09 14:18:03 +0200 |
| commit | 8bd91a40eae95f38c15d570d6af87b997c7eee39 (patch) | |
| tree | a1abfcd9924ad300114d4fa203e834c2ca5cab02 /sc/qa/unit | |
| parent | 247f4aefb9879dd465e34a2072218a0f1748de53 (diff) | |
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 <xiscofauli@libreoffice.org>
Diffstat (limited to 'sc/qa/unit')
| -rw-r--r-- | sc/qa/unit/data/functions/statistical/fods/countif.fods | 48 |
1 files changed, 48 insertions, 0 deletions
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 @@ -4000,6 +4000,54 @@ <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];"=")" 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;"=")" calcext:value-type="string"> + <text:p>=COUNTIF(I44:L44;"=")</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:="""> + <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];"<>")" 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;"<>")" calcext:value-type="string"> + <text:p>=COUNTIF(I45:L45;"<>")</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:="""> + <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"/> <table:table-cell table:style-name="ce34"/> |