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

[Libreoffice Gerrit user]

 sc/qa/unit/data/functions/statistical/fods/ztest.fods |   20 ++++++++++++++----
 1 file changed, 16 insertions(+), 4 deletions(-)

New commits:
commit 65b1990687ec261d10a96e58b9d476d4b23e11a0
Author:     Takeshi Abe <tabe at fixedpoint.jp>
AuthorDate: Wed Jun 13 18:51:13 2018 +0900
Commit:     Markus Mohrhard <markus.mohrhard at googlemail.com>
CommitDate: Fri Jul 13 21:59:19 2018 +0200

    sc: Add a test case for ZTEST() raising #DIV/0!
    
    ... when the sample stddev is 0.
    
    This follows up d17e8faa13b1f8d943b602aa6ea754c1b22fdd76.
    
    Change-Id: I4ce718f60f1dbcf58fdcbbb553c345c9c8907a2b
    Reviewed-on: https://gerrit.libreoffice.org/55741
    Tested-by: Jenkins
    Reviewed-by: Markus Mohrhard <markus.mohrhard at googlemail.com>

diff --git a/sc/qa/unit/data/functions/statistical/fods/ztest.fods b/sc/qa/unit/data/functions/statistical/fods/ztest.fods
index db8294fb98c1..94bb0a552958 100644
--- a/sc/qa/unit/data/functions/statistical/fods/ztest.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/ztest.fods
@@ -4462,10 +4462,22 @@
      <table:table-cell table:number-columns-repeated="5"/>
     </table:table-row>
     <table:table-row table:style-name="ro6">
-     <table:table-cell table:number-columns-repeated="2"/>
-     <table:table-cell table:style-name="ce28"/>
-     <table:table-cell table:style-name="ce32"/>
-     <table:table-cell table:number-columns-repeated="3"/>
+     <table:table-cell table:formula="of:=ZTEST([.F18:.G18]; 42)" office:value-type="string" office:string-value="" calcext:value-type="error">
+      <text:p>#DIV/0!</text:p>
+     </table:table-cell>
+     <table:table-cell table:formula="of:#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error">
+      <text:p>#DIV/0!</text:p>
+     </table:table-cell>
+     <table:table-cell table:style-name="ce28" table:formula="of:=ERROR.TYPE([.A18])=2" 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="ce32" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=ZTEST(F18:G18, 42)" calcext:value-type="string">
+      <text:p>=ZTEST(F18:G18, 42)</text:p>
+     </table:table-cell>
+     <table:table-cell/>
+     <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="42" calcext:value-type="float">
+      <text:p>42</text:p>
+     </table:table-cell>
      <table:table-cell table:style-name="ce58"/>
      <table:table-cell table:number-columns-repeated="3"/>
      <table:table-cell table:style-name="ce46"/>