一个WPS表格自动计算填充错误的BUG.
版本号：11.8.2.8506-Release
1，新建一工作簿表格
2，填充：A1 ：3.89
A2：389.389
3,然后选中A1:A2,下拉自动填充至A195，数值出现错误变为74790.6960000001
至第A616，数值为237085.774999999
B列 验证自动填充的差值 B2=A2-A1
至B23=385.498999999999
也就是说，至A23的时候，自动填充的数值已经出现了错误，可能单无格属性的原因或都四舍五入的原因没有显示出来
截图如下：A1-A31，B1-B31
3.89000000000000000000 | |
389.38900000000000000000 | 385.49900000000000000000 |
774.88800000000000000000 | 385.49900000000000000000 |
1160.38700000000000000000 | 385.49900000000000000000 |
1545.88600000000000000000 | 385.49900000000000000000 |
1931.38500000000000000000 | 385.49900000000000000000 |
2316.88400000000000000000 | 385.49900000000000000000 |
2702.38300000000000000000 | 385.49900000000000000000 |
3087.88200000000000000000 | 385.49900000000000000000 |
3473.38100000000000000000 | 385.49900000000000000000 |
3858.88000000000000000000 | 385.49900000000000000000 |
4244.37900000000000000000 | 385.49900000000000000000 |
4629.87800000000000000000 | 385.49900000000100000000 |
5015.37700000000000000000 | 385.49900000000000000000 |
5400.87600000000000000000 | 385.49900000000100000000 |
5786.37500000000000000000 | 385.49900000000000000000 |
6171.87400000000000000000 | 385.49900000000000000000 |
6557.37300000000000000000 | 385.49900000000000000000 |
6942.87200000000000000000 | 385.49900000000000000000 |
7328.37100000000000000000 | 385.49900000000000000000 |
7713.87000000000000000000 | 385.49900000000000000000 |
8099.36900000000000000000 | 385.49900000000000000000 |
8484.86800000000000000000 | 385.49899999999900000000 |
8870.36700000000000000000 | 385.49900000000000000000 |
9255.86600000000000000000 | 385.49900000000000000000 |
9641.36500000000000000000 | 385.49900000000000000000 |
10026.86400000000000000000 | 385.49900000000000000000 |
10412.36300000000000000000 | 385.49900000000000000000 |
10797.86200000000000000000 | 385.49900000000000000000 |
11183.36100000000000000000 | 385.49900000000300000000 |
11568.86000000000000000000 | 385.49899999999600000000 |
A194，B194
74405.19700000000000000000 | 385.49899999999600000000 |
A616，B616
237085.77499999900000000000 | 385.49899999899200000000 |
至此，后面的数就没法看了。
这两个数字并不特殊，小数点后的三位数自动填充都会出现这样的问题。不知这算不算一个BUG
WPS寻令官 | WPS产品体验官