summaryrefslogtreecommitdiff
path: root/sc/qa
diff options
context:
space:
mode:
authordante <dante19031999@gmail.com>2021-04-27 13:20:59 +0200
committerMike Kaganski <mike.kaganski@collabora.com>2021-04-29 07:47:22 +0200
commitbd944fe3812fd9fa5a90e98cdac4a77f1a4e6865 (patch)
tree363bb662aeed81a038b50b742437a7d1fc4563c1 /sc/qa
parent4bc0af27204f099f14cb4c97611089643cbe271c (diff)
tdf#137679 Use Kahan summation for interpr2.cxx
The changes in the text files are in the latest decimals. Those should be more accurate now. Change-Id: I3814e1939f71debd5ddde9408a025af7a0a2cac5 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/114737 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'sc/qa')
-rw-r--r--sc/qa/unit/data/functions/financial/fods/vdb.fods40
1 files changed, 20 insertions, 20 deletions
diff --git a/sc/qa/unit/data/functions/financial/fods/vdb.fods b/sc/qa/unit/data/functions/financial/fods/vdb.fods
index aee00996327e..38ace9085ec7 100644
--- a/sc/qa/unit/data/functions/financial/fods/vdb.fods
+++ b/sc/qa/unit/data/functions/financial/fods/vdb.fods
@@ -2535,11 +2535,11 @@
<table:table-cell table:number-columns-repeated="6"/>
</table:table-row>
<table:table-row table:style-name="ro7">
- <table:table-cell table:style-name="ce11" table:formula="of:=VDB(100000;20000;10;7;8)" office:value-type="currency" office:currency="USD" office:value="971.519999999989" calcext:value-type="currency">
+ <table:table-cell table:style-name="ce11" table:formula="of:=VDB(100000;20000;10;7;8)" office:value-type="currency" office:currency="USD" office:value="971.520000000004" calcext:value-type="currency">
<text:p>$971.52</text:p>
</table:table-cell>
- <table:table-cell office:value-type="float" office:value="971.519999999989" calcext:value-type="float">
- <text:p>971.519999999989</text:p>
+ <table:table-cell office:value-type="float" office:value="971.520000000004" calcext:value-type="float">
+ <text:p>971.520000000004</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A11];12)=ROUND([.B11];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
<text:p>TRUE</text:p>
@@ -2948,11 +2948,11 @@
<table:table-cell table:number-columns-repeated="12"/>
</table:table-row>
<table:table-row table:style-name="ro6">
- <table:table-cell table:formula="of:=VDB(100000;20000;10;7.25;7.75)" office:value-type="float" office:value="485.759999999995" calcext:value-type="float">
- <text:p>485.759999999995</text:p>
+ <table:table-cell table:formula="of:=VDB(100000;20000;10;7.25;7.75)" office:value-type="float" office:value="485.760000000002" calcext:value-type="float">
+ <text:p>$485.76</text:p>
</table:table-cell>
- <table:table-cell office:value-type="float" office:value="485.759999999995" calcext:value-type="float">
- <text:p>485.759999999995</text:p>
+ <table:table-cell office:value-type="float" office:value="485.760000000002" calcext:value-type="float">
+ <text:p>485.760000000002</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A33];12)=ROUND([.B33];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
<text:p>TRUE</text:p>
@@ -3118,11 +3118,11 @@
<table:table-cell table:number-columns-repeated="2"/>
</table:table-row>
<table:table-row table:style-name="ro6">
- <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G41];[.$G42])" office:value-type="float" office:value="971.519999999989" calcext:value-type="float">
- <text:p>971.519999999989</text:p>
+ <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G41];[.$G42])" office:value-type="float" office:value="971.520000000004" calcext:value-type="float">
+ <text:p>$971.52</text:p>
</table:table-cell>
- <table:table-cell office:value-type="float" office:value="971.519999999989" calcext:value-type="float">
- <text:p>971.519999999989</text:p>
+ <table:table-cell office:value-type="float" office:value="971.520000000004" calcext:value-type="float">
+ <text:p>971.520000000004</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A41];12)=ROUND([.B41];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
<text:p>TRUE</text:p>
@@ -3536,10 +3536,10 @@
<table:table-cell table:number-columns-repeated="16"/>
</table:table-row>
<table:table-row table:style-name="ro6">
- <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G50])" office:value-type="float" office:value="242.879999999997" calcext:value-type="float">
- <text:p>242.879999999997</text:p>
+ <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G50])" office:value-type="float" office:value="242.880000000001" calcext:value-type="float">
+ <text:p>$242.88</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce15" office:value-type="float" office:value="242.879999999997" calcext:value-type="float">
+ <table:table-cell table:style-name="ce15" office:value-type="float" office:value="242.880000000001" calcext:value-type="float">
<text:p>242.880000</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A64];12)=ROUND([.B64];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
@@ -3551,10 +3551,10 @@
<table:table-cell table:number-columns-repeated="16"/>
</table:table-row>
<table:table-row table:style-name="ro6">
- <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G50];[.G51])" office:value-type="float" office:value="485.759999999995" calcext:value-type="float">
- <text:p>485.759999999995</text:p>
+ <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G50];[.G51])" office:value-type="float" office:value="485.760000000002" calcext:value-type="float">
+ <text:p>$485.76</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce15" office:value-type="float" office:value="485.759999999995" calcext:value-type="float">
+ <table:table-cell table:style-name="ce15" office:value-type="float" office:value="485.760000000002" calcext:value-type="float">
<text:p>485.760000</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A65];12)=ROUND([.B65];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
@@ -3566,10 +3566,10 @@
<table:table-cell table:number-columns-repeated="16"/>
</table:table-row>
<table:table-row table:style-name="ro6">
- <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G51])" office:value-type="float" office:value="728.639999999992" calcext:value-type="float">
- <text:p>728.639999999992</text:p>
+ <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G51])" office:value-type="float" office:value="728.640000000003" calcext:value-type="float">
+ <text:p>$728.64</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce15" office:value-type="float" office:value="728.639999999992" calcext:value-type="float">
+ <table:table-cell table:style-name="ce15" office:value-type="float" office:value="728.640000000003" calcext:value-type="float">
<text:p>728.640000</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A66];12)=ROUND([.B66];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">