Allow for presumably more precices results of some more Calc function calls

...similar to 19559ebbee160d1625d06feec7e6566772dad231 "Allow for a presumably
more precise result of BESSELY(80,9)", where at least on macOS ARM64 Clang 14
trunk (defaulting to -ffp-contract=on now) started to produce values that caused
various CppunitTests to fail (and only one of which had been addressed in
19559ebbee160d1625d06feec7e6566772dad231, for starters).  The discrepancies
addressed by this commit are:

* CppunitTest_sc_financial_functions_test:
** sc/qa/unit/data/functions/financial/fods/rate.fods:
*** row 23: actual 0.250000095659014 vs. expected 0.250000092908987

* CppunitTest_sc_statistical_functions_test
** sc/qa/unit/data/functions/statistical/fods/chisq.test.fods:
*** row 10: actual 1.66789802691648E-016 vs. expected 1.66789802691649E-16
** sc/qa/unit/data/functions/statistical/fods/chisqinv.fods:
*** row 58: actual 3.00000000000001E-001 vs. expected 0.299999999999999
** sc/qa/unit/data/functions/statistical/fods/chitest.fods:
*** row 10: actual 1.66789802691648E-016 vs. expected 1.66789802691649E-16
** sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods:
*** row 79: actual 268.59802115122 vs. expected 268.598021151221

Change-Id: I4439f59394feadd2d6406dc4c4f985f479cd8fe0
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/126640
Tested-by: Jenkins
Reviewed-by: Stephan Bergmann <sbergman@redhat.com>

5 files changed, 5 insertions, 5 deletions

diff --git a/sc/qa/unit/data/functions/financial/fods/rate.fods b/sc/qa/unit/data/functions/financial/fods/rate.fods
index 87080a647c5e..1d854638c09d 100644
--- a/sc/qa/unit/data/functions/financial/fods/rate.fods
+++ b/sc/qa/unit/data/functions/financial/fods/rate.fods
@@ -2770,7 +2770,7 @@
      <table:table-cell office:value-type="float" office:value="0.250000092908987" calcext:value-type="float">
       <text:p>0.250000092908987</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce22" table:formula="of:=ROUND([.A23];12)=ROUND([.B23];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce22" table:formula="of:=ROUND([.A23];7)=ROUND([.B23];7)" 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="ce23" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="=RATE(L19,L21,L20,L22,L23,L24)" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods b/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
index aaffa4a02a5e..7fb37b620a3c 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisq.test.fods
@@ -4306,7 +4306,7 @@
      <table:table-cell office:value-type="float" office:value="1.66789802691649E-016" calcext:value-type="float">
       <text:p>1.66789802691649E-16</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce54" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];15)=ORG.LIBREOFFICE.ROUNDSIG([.B10];15)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce54" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];14)=ORG.LIBREOFFICE.ROUNDSIG([.B10];14)" 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([.A10])" office:value-type="string" office:string-value="=CHISQ.TEST(T1:T14,U1:U14)" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods b/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
index 4bb9cc65d9df..31eed0ec486e 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisqinv.fods
@@ -5585,7 +5585,7 @@
      <table:table-cell table:style-name="ce79" office:value-type="float" office:value="0.299999999999999" calcext:value-type="float">
       <text:p>0.300000</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce80" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A58];15)=ORG.LIBREOFFICE.ROUNDSIG([.B58];15)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce80" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A58];14)=ORG.LIBREOFFICE.ROUNDSIG([.B58];14)" 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="ce83" table:formula="of:=FORMULA([.A58])" office:value-type="string" office:string-value="=CHISQDIST(CHISQINV(0.3,20),20,TRUE())" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/statistical/fods/chitest.fods b/sc/qa/unit/data/functions/statistical/fods/chitest.fods
index f72361ae35f8..03a1a53b13b8 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chitest.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chitest.fods
@@ -4306,7 +4306,7 @@
      <table:table-cell office:value-type="float" office:value="1.66789802691649E-016" calcext:value-type="float">
       <text:p>1.66789802691649E-16</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce54" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];15)=ORG.LIBREOFFICE.ROUNDSIG([.B10];15)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce54" table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.A10];14)=ORG.LIBREOFFICE.ROUNDSIG([.B10];14)" 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([.A10])" office:value-type="string" office:string-value="=CHITEST(T1:T14,U1:U14)" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods b/sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods
index 150ec6b68115..9654571a2828 100644
--- a/sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods
@@ -9020,7 +9020,7 @@
      <table:table-cell office:value-type="float" office:value="268.598021151221" calcext:value-type="float">
       <text:p>268.598021151221</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A79];12)=ROUND([.B79];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A79];11)=ROUND([.B79];11)" 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="ce18" table:formula="of:=FORMULA([.A79])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)}" calcext:value-type="string">