sc/qa/unit/data/functions/financial/fods/rate.fods | 2 +- sc/qa/unit/data/functions/statistical/fods/chisq.test.fods | 2 +- sc/qa/unit/data/functions/statistical/fods/chisqinv.fods | 2 +- sc/qa/unit/data/functions/statistical/fods/chitest.fods | 2 +- sc/qa/unit/data/functions/statistical/fods/forecast.ets.mult.fods | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-)
New commits: commit 04215f03492f6fce83d6bc64491749bf803c389a Author: Stephan Bergmann <[email protected]> AuthorDate: Fri Dec 10 15:50:55 2021 +0100 Commit: Stephan Bergmann <[email protected]> CommitDate: Fri Dec 10 21:04:08 2021 +0100 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 <[email protected]> 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">
