Related: tdf#138360 Use approxFloor() in rtl_math_round()

Ditch mostly but not always working correction value and use
approxFloor() instead which yields better results. With this we
now have one single place approxValue() in case more fine grained
tuning is needed.

Unfortunately all numeric spreadsheet function tests use ROUND()
in a manner such that they mostly blindly do a ROUND(...;12)
regardless of magnitude, sometimes effectively rounding to the
14th significant digit that may fail in cases like for

14.2040730851385
^
where the constant (rounded) value is stored as is but the
calculated value is
14.204073085138471
and the old round() yielded
14.204073085139 for both but the new round() more correctly
results in
14.204073085139 and
14.204073085138
so the spreadsheet test case sources had to be changed to
ROUND(...;11) in such places.

Change-Id: I211bb868a4f4dc9e68f4c7dcc2a187b5e175416f
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/107135
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins

16 files changed, 44 insertions, 44 deletions

diff --git a/sc/qa/unit/data/functions/addin/fods/convert.fods b/sc/qa/unit/data/functions/addin/fods/convert.fods
index 12ba09dcd326..64eb2db5ff82 100644
--- a/sc/qa/unit/data/functions/addin/fods/convert.fods
+++ b/sc/qa/unit/data/functions/addin/fods/convert.fods
@@ -3409,7 +3409,7 @@
      <table:table-cell office:value-type="float" office:value="14.2857127610345" calcext:value-type="float">
       <text:p>14.2857127610345</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce60" table:formula="of:=ROUND([.A44];12)=ROUND([.B44];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce60" table:formula="of:=ROUND([.A44];11)=ROUND([.B44];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="ce14" table:formula="of:=FORMULA([.A44])" office:value-type="string" office:string-value="=CONVERT(10000000,H48,H49)" calcext:value-type="string">
@@ -4425,7 +4425,7 @@
      <table:table-cell office:value-type="float" office:value="11.1445349270435" calcext:value-type="float">
       <text:p>11.1445349270435</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce60" table:formula="of:=ROUND([.A86];12)=ROUND([.B86];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce60" table:formula="of:=ROUND([.A86];11)=ROUND([.B86];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="ce14" table:formula="of:=FORMULA([.A86])" office:value-type="string" office:string-value="=CONVERT(100000000000000,H93,H94)" calcext:value-type="string">
@@ -5867,4 +5867,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/financial/fods/nper.fods b/sc/qa/unit/data/functions/financial/fods/nper.fods
index 2eac9b8f339f..83dc438afa34 100644
--- a/sc/qa/unit/data/functions/financial/fods/nper.fods
+++ b/sc/qa/unit/data/functions/financial/fods/nper.fods
@@ -1293,7 +1293,7 @@
      <table:table-cell office:value-type="float" office:value="-12.0207780851555" calcext:value-type="float">
       <text:p>-12.0207780851555</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce24" table:formula="of:=ROUND([.A2];12)=ROUND([.B2];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce24" table:formula="of:=ROUND([.A2];11)=ROUND([.B2];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="ce31" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=NPER(0.06,153.75,2600)" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/fods/gammaln.precise.fods b/sc/qa/unit/data/functions/fods/gammaln.precise.fods
index 082f59f6af7a..fec21d9ceaee 100644
--- a/sc/qa/unit/data/functions/fods/gammaln.precise.fods
+++ b/sc/qa/unit/data/functions/fods/gammaln.precise.fods
@@ -4109,7 +4109,7 @@
      <table:table-cell office:value-type="float" office:value="12.8018274800815" calcext:value-type="float">
       <text:p>12.8018274800815</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];12)=ROUND([.B21];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];11)=ROUND([.B21];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="ce21" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=GAMMALN.PRECISE(I20)" calcext:value-type="string">
@@ -5093,4 +5093,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/mathematical/fods/convert_add.fods b/sc/qa/unit/data/functions/mathematical/fods/convert_add.fods
index a6f3cec90e5b..ef5e269fce26 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/convert_add.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/convert_add.fods
@@ -3354,7 +3354,7 @@
      <table:table-cell office:value-type="float" office:value="14.2857127610345" calcext:value-type="float">
       <text:p>14.2857127610345</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A44];12)=ROUND([.B44];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A44];11)=ROUND([.B44];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="ce14" table:formula="of:=FORMULA([.A44])" office:value-type="string" office:string-value="=CONVERT_ADD(10000000,H48,H49)" calcext:value-type="string">
@@ -4370,7 +4370,7 @@
      <table:table-cell office:value-type="float" office:value="11.1445349270435" calcext:value-type="float">
       <text:p>11.1445349270435</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A86];12)=ROUND([.B86];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A86];11)=ROUND([.B86];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="ce14" table:formula="of:=FORMULA([.A86])" office:value-type="string" office:string-value="=CONVERT_ADD(100000000000000,H93,H94)" calcext:value-type="string">
@@ -5812,4 +5812,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/chisq.inv.fods b/sc/qa/unit/data/functions/statistical/fods/chisq.inv.fods
index 84f03ae0c1cf..b3d6368b9819 100644
--- a/sc/qa/unit/data/functions/statistical/fods/chisq.inv.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/chisq.inv.fods
@@ -4443,7 +4443,7 @@
      <table:table-cell office:value-type="float" office:value="14.2040730851385" calcext:value-type="float">
       <text:p>14.2040730851385</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A14];12)=ROUND([.B14];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A14];11)=ROUND([.B14];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="ce32" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="{=CHISQ.INV(F1:F11,G1:G11)}" calcext:value-type="string">
@@ -4796,7 +4796,7 @@
      <table:table-cell office:value-type="float" office:value="15.2911628705065" calcext:value-type="float">
       <text:p>15.2911628705065</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A27];12)=ROUND([.B27];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A27];11)=ROUND([.B27];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="ce32" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="{=CHISQ.INV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4822,7 +4822,7 @@
      <table:table-cell office:value-type="float" office:value="20.4461298047275" calcext:value-type="float">
       <text:p>20.4461298047275</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A28];12)=ROUND([.B28];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A28];11)=ROUND([.B28];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="ce32" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="{=CHISQ.INV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -4926,7 +4926,7 @@
      <table:table-cell office:value-type="float" office:value="15.6557151216055" calcext:value-type="float">
       <text:p>15.6557151216055</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A32];12)=ROUND([.B32];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A32];11)=ROUND([.B32];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="ce32" table:formula="of:=FORMULA([.A32])" office:value-type="string" office:string-value="{=CHISQ.INV(T2:T14,U2:U14)}" calcext:value-type="string">
@@ -5373,7 +5373,7 @@
      <table:table-cell office:value-type="float" office:value="5.8218731997855" calcext:value-type="float">
       <text:p>5.8218731997855</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A49];12)=ROUND([.B49];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce48" table:formula="of:=ROUND([.A49];11)=ROUND([.B49];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="ce32" table:formula="of:=FORMULA([.A49])" office:value-type="string" office:string-value="{=CHISQ.INV(F1:F11,I1:I11)}" calcext:value-type="string">
@@ -5835,4 +5835,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
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 9741ba7dc9a2..0c45eb46cd8c 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
@@ -9953,7 +9953,7 @@
      <table:table-cell office:value-type="float" office:value="87.6933650074125" calcext:value-type="float">
       <text:p>87.6933650074125</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A120];12)=ROUND([.B120];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A120];11)=ROUND([.B120];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([.A120])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)}" calcext:value-type="string">
@@ -9991,7 +9991,7 @@
      <table:table-cell office:value-type="float" office:value="99.6314373472625" calcext:value-type="float">
       <text:p>99.6314373472625</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A122];12)=ROUND([.B122];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A122];11)=ROUND([.B122];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([.A122])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)}" calcext:value-type="string">
@@ -10536,7 +10536,7 @@
      <table:table-cell office:value-type="float" office:value="69.5445898754795" calcext:value-type="float">
       <text:p>69.5445898754795</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A151];12)=ROUND([.B151];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A151];11)=ROUND([.B151];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([.A151])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)}" calcext:value-type="string">
@@ -11658,7 +11658,7 @@
      <table:table-cell table:style-name="ce14" office:value-type="float" office:value="87.6933650074125" calcext:value-type="float">
       <text:p>87.693365</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A217];12)=ROUND([.B217];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A217];11)=ROUND([.B217];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([.A217])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)}" calcext:value-type="string">
@@ -11692,7 +11692,7 @@
      <table:table-cell table:style-name="ce14" office:value-type="float" office:value="99.6314373472625" calcext:value-type="float">
       <text:p>99.631437</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A219];12)=ROUND([.B219];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A219];11)=ROUND([.B219];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([.A219])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)}" calcext:value-type="string">
@@ -12185,7 +12185,7 @@
      <table:table-cell office:value-type="float" office:value="69.5445898754795" calcext:value-type="float">
       <text:p>69.5445898754795</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A248];12)=ROUND([.B248];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A248];11)=ROUND([.B248];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([.A248])" office:value-type="string" office:string-value="{=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)}" calcext:value-type="string">
@@ -12336,4 +12336,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/gammaln.fods b/sc/qa/unit/data/functions/statistical/fods/gammaln.fods
index 61b0a44eec41..66f1f473482b 100644
--- a/sc/qa/unit/data/functions/statistical/fods/gammaln.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/gammaln.fods
@@ -4067,7 +4067,7 @@
      <table:table-cell office:value-type="float" office:value="12.8018274800815" calcext:value-type="float">
       <text:p>12.8018274800815</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];12)=ROUND([.B21];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];11)=ROUND([.B21];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="ce21" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=GAMMALN(I20)" calcext:value-type="string">
@@ -5051,4 +5051,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/gammaln.precise.fods b/sc/qa/unit/data/functions/statistical/fods/gammaln.precise.fods
index 92ffe8e3e763..89365b2ab887 100644
--- a/sc/qa/unit/data/functions/statistical/fods/gammaln.precise.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/gammaln.precise.fods
@@ -4201,7 +4201,7 @@
      <table:table-cell office:value-type="float" office:value="12.8018274800815" calcext:value-type="float">
       <text:p>12.8018274800815</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];12)=ROUND([.B21];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A21];11)=ROUND([.B21];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="ce21" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=GAMMALN.PRECISE(I20)" calcext:value-type="string">
@@ -5185,4 +5185,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/geomean.fods b/sc/qa/unit/data/functions/statistical/fods/geomean.fods
index 2a8fdf3fdf1e..b04e2464628e 100644
--- a/sc/qa/unit/data/functions/statistical/fods/geomean.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/geomean.fods
@@ -4109,7 +4109,7 @@
      <table:table-cell office:value-type="float" office:value="10.4400868170485" calcext:value-type="float">
       <text:p>10.4400868170485</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A20];12)=ROUND([.B20];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A20];11)=ROUND([.B20];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="ce21" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=GEOMEAN(I19:I22)" calcext:value-type="string">
diff --git a/sc/qa/unit/data/functions/statistical/fods/harmean.fods b/sc/qa/unit/data/functions/statistical/fods/harmean.fods
index 01023adf9b7f..d1cc626ea92d 100644
--- a/sc/qa/unit/data/functions/statistical/fods/harmean.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/harmean.fods
@@ -4298,7 +4298,7 @@
      <table:table-cell office:value-type="float" office:value="17.4283840749415" calcext:value-type="float">
       <text:p>17.4283840749415</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A27];12)=ROUND([.B27];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A27];11)=ROUND([.B27];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="ce21" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="=HARMEAN(I26:I29)" calcext:value-type="string">
@@ -4352,7 +4352,7 @@
      <table:table-cell office:value-type="float" office:value="18.4864864864865" calcext:value-type="float">
       <text:p>18.4864864864865</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A29];12)=ROUND([.B29];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A29];11)=ROUND([.B29];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="ce21" table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="=HARMEAN(I28:I31)" calcext:value-type="string">
@@ -5189,4 +5189,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/lognorm.inv.fods b/sc/qa/unit/data/functions/statistical/fods/lognorm.inv.fods
index c37347291963..df8095b670b5 100644
--- a/sc/qa/unit/data/functions/statistical/fods/lognorm.inv.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/lognorm.inv.fods
@@ -3937,7 +3937,7 @@
      <table:table-cell table:style-name="ce15" office:value-type="float" office:value="98.1601932437975" calcext:value-type="float">
       <text:p>98.1601932437975000000</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A8];12)=ROUND([.B8];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce16" table:formula="of:=ROUND([.A8];11)=ROUND([.B8];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="ce22" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="{=LOGNORM.INV(K1:K8,L1:L8,M1:M8)}" calcext:value-type="string">
@@ -5044,4 +5044,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/stdev.fods b/sc/qa/unit/data/functions/statistical/fods/stdev.fods
index a55bf203c1ea..315307de78c1 100644
--- a/sc/qa/unit/data/functions/statistical/fods/stdev.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/stdev.fods
@@ -4266,7 +4266,7 @@
      <table:table-cell table:style-name="ce19" office:value-type="float" office:value="27.4639157198435" calcext:value-type="float">
       <text:p>27.4639157198435</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce41" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce41" table:formula="of:=ROUND([.A10];11)=ROUND([.B10];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="ce32" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=STDEV(P3:P12)" calcext:value-type="string">
@@ -6722,4 +6722,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/stdev.p.fods b/sc/qa/unit/data/functions/statistical/fods/stdev.p.fods
index 42d12467fb4f..2de9f7bfaeb7 100644
--- a/sc/qa/unit/data/functions/statistical/fods/stdev.p.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/stdev.p.fods
@@ -4266,7 +4266,7 @@
      <table:table-cell table:style-name="ce19" office:value-type="float" office:value="26.0545581424825" calcext:value-type="float">
       <text:p>26.0545581424825</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];11)=ROUND([.B10];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="ce32" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=STDEV.P(P3:P12)" calcext:value-type="string">
@@ -4360,7 +4360,7 @@
      <table:table-cell office:value-type="float" office:value="14.6711451495785" calcext:value-type="float">
       <text:p>14.6711451495785</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A12];12)=ROUND([.B12];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A12];11)=ROUND([.B12];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="ce32" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=STDEV.P(34.5, 2, 8.9, -4)" calcext:value-type="string">
@@ -6731,4 +6731,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/stdev.s.fods b/sc/qa/unit/data/functions/statistical/fods/stdev.s.fods
index a880adbac276..802bd1720ea6 100644
--- a/sc/qa/unit/data/functions/statistical/fods/stdev.s.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/stdev.s.fods
@@ -4266,7 +4266,7 @@
      <table:table-cell table:style-name="ce19" office:value-type="float" office:value="27.4639157198435" calcext:value-type="float">
       <text:p>27.4639157198435</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];11)=ROUND([.B10];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="ce32" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=STDEV.S(P3:P12)" calcext:value-type="string">
@@ -6731,4 +6731,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/stdeva.fods b/sc/qa/unit/data/functions/statistical/fods/stdeva.fods
index 6c9739ac7bd3..51c81231aa0a 100644
--- a/sc/qa/unit/data/functions/statistical/fods/stdeva.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/stdeva.fods
@@ -4267,7 +4267,7 @@
      <table:table-cell table:style-name="ce19" office:value-type="float" office:value="27.4639157198435" calcext:value-type="float">
       <text:p>27.4639157198435</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];11)=ROUND([.B10];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="ce32" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=STDEVA(P3:P12)" calcext:value-type="string">
@@ -6745,4 +6745,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>
diff --git a/sc/qa/unit/data/functions/statistical/fods/stdevp.fods b/sc/qa/unit/data/functions/statistical/fods/stdevp.fods
index ed72ca8d1b42..09d05409e306 100644
--- a/sc/qa/unit/data/functions/statistical/fods/stdevp.fods
+++ b/sc/qa/unit/data/functions/statistical/fods/stdevp.fods
@@ -4223,7 +4223,7 @@
      <table:table-cell table:style-name="ce19" office:value-type="float" office:value="26.0545581424825" calcext:value-type="float">
       <text:p>26.0545581424825</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce25" table:formula="of:=ROUND([.A10];11)=ROUND([.B10];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="ce32" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=STDEVP(P3:P12)" calcext:value-type="string">
@@ -4317,7 +4317,7 @@
      <table:table-cell office:value-type="float" office:value="14.6711451495785" calcext:value-type="float">
       <text:p>14.6711451495785</text:p>
      </table:table-cell>
-     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A12];12)=ROUND([.B12];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
+     <table:table-cell table:style-name="ce28" table:formula="of:=ROUND([.A12];11)=ROUND([.B12];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="ce32" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=STDEVP(34.5, 2, 8.9, -4)" calcext:value-type="string">
@@ -6701,4 +6701,4 @@
    </table:named-expressions>
   </office:spreadsheet>
  </office:body>
-</office:document>
\ No newline at end of file
+</office:document>