xlsx内部のxmlで小数第16位まで保持しているのは「1.225」だけではない

Excelの数式バーでは「1.225」と表示されるデータが、xlsxファイル内部のxmlファイルでは、「1.2250000000000001」と小数第16位まで保持されていることを記事にしました。

気になるのは、このようなデータが「1.225」だけなのかどうか、です。

結論。
「1.225」に限らず多くの小数が、小数点以下16桁の値を持った状態で格納されています。

xlsxファイルから生データを抜き出した結果

Excelに「1.001」から「1.999」までのデータを入力して、xlsxファイル内部のxmlファイルから生データを抜き出してみると、以下のような結果です。

1.0009999999999999
1.002
1.0029999999999999
1.004
1.0049999999999999
1.006
1.0069999999999999
1.008
1.0089999999999999
1.01
1.0109999999999999
1.012
1.0129999999999999
1.014
1.0149999999999999
1.016
1.0169999999999999
1.018
1.0189999999999999
1.02
1.0209999999999999
1.022
1.0229999999999999
1.024
1.0249999999999999
1.026
1.0269999999999999
1.028
1.0289999999999999
1.03
1.0309999999999999
1.032
1.0329999999999999
1.034
1.0349999999999999
1.036
1.0369999999999999
1.038
1.0389999999999999
1.04
1.0409999999999999
1.042
1.0429999999999999
1.044
1.0449999999999999
1.046
1.0469999999999999
1.048
1.0489999999999999
1.05
1.0509999999999999
1.052
1.0529999999999999
1.054
1.0549999999999999
1.056
1.0569999999999999
1.0580000000000001
1.0589999999999999
1.06
1.0609999999999999
1.0620000000000001
1.0629999999999999
1.0640000000000001
1.0649999999999999
1.0660000000000001
1.0669999999999999
1.0680000000000001
1.069
1.07
1.071
1.0720000000000001
1.073
1.0740000000000001
1.075
1.0760000000000001
1.077
1.0780000000000001
1.079
1.08
1.081
1.0820000000000001
1.083
1.0840000000000001
1.085
1.0860000000000001
1.087
1.0880000000000001
1.089
1.0900000000000001
1.091
1.0920000000000001
1.093
1.0940000000000001
1.095
1.0960000000000001
1.097
1.0980000000000001
1.099
1.1000000000000001
1.101
1.1020000000000001
1.103
1.1040000000000001
1.105
1.1060000000000001
1.107
1.1080000000000001
1.109
1.1100000000000001
1.111
1.1120000000000001
1.113
1.1140000000000001
1.115
1.1160000000000001
1.117
1.1180000000000001
1.119
1.1200000000000001
1.121
1.1220000000000001
1.123
1.1240000000000001
1.125
1.1259999999999999
1.127
1.1279999999999999
1.129
1.1299999999999999
1.131
1.1319999999999999
1.133
1.1339999999999999
1.135
1.1359999999999999
1.137
1.1379999999999999
1.139
1.1399999999999999
1.141
1.1419999999999999
1.143
1.1439999999999999
1.145
1.1459999999999999
1.147
1.1479999999999999
1.149
1.1499999999999999
1.151
1.1519999999999999
1.153
1.1539999999999999
1.155
1.1559999999999999
1.157
1.1579999999999999
1.159
1.1599999999999999
1.161
1.1619999999999999
1.163
1.1639999999999999
1.165
1.1659999999999999
1.167
1.1679999999999999
1.169
1.17
1.171
1.1719999999999999
1.173
1.1739999999999999
1.175
1.1759999999999999
1.177
1.1779999999999999
1.179
1.18
1.181
1.1819999999999999
1.1830000000000001
1.1839999999999999
1.1850000000000001
1.1859999999999999
1.1870000000000001
1.1879999999999999
1.1890000000000001
1.19
1.1910000000000001
1.1919999999999999
1.1930000000000001
1.194
1.1950000000000001
1.196
1.1970000000000001
1.198
1.1990000000000001
1.2
1.2010000000000001
1.202
1.2030000000000001
1.204
1.2050000000000001
1.206
1.2070000000000001
1.208
1.2090000000000001
1.21
1.2110000000000001
1.212
1.2130000000000001
1.214
1.2150000000000001
1.216
1.2170000000000001
1.218
1.2190000000000001
1.22
1.2210000000000001
1.222
1.2230000000000001
1.224
1.2250000000000001
1.226
1.2270000000000001
1.228
1.2290000000000001
1.23
1.2310000000000001
1.232
1.2330000000000001
1.234
1.2350000000000001
1.236
1.2370000000000001
1.238
1.2390000000000001
1.24
1.2410000000000001
1.242
1.2430000000000001
1.244
1.2450000000000001
1.246
1.2470000000000001
1.248
1.2490000000000001
1.25
1.2509999999999999
1.252
1.2529999999999999
1.254
1.2549999999999999
1.256
1.2569999999999999
1.258
1.2589999999999999
1.26
1.2609999999999999
1.262
1.2629999999999999
1.264
1.2649999999999999
1.266
1.2669999999999999
1.268
1.2689999999999999
1.27
1.2709999999999999
1.272
1.2729999999999999
1.274
1.2749999999999999
1.276
1.2769999999999999
1.278
1.2789999999999999
1.28
1.2809999999999999
1.282
1.2829999999999999
1.284
1.2849999999999999
1.286
1.2869999999999999
1.288
1.2889999999999999
1.29
1.2909999999999999
1.292
1.2929999999999999
1.294
1.2949999999999999
1.296
1.2969999999999999
1.298
1.2989999999999999
1.3
1.3009999999999999
1.302
1.3029999999999999
1.304
1.3049999999999999
1.306
1.3069999999999999
1.3080000000000001
1.3089999999999999
1.31
1.3109999999999999
1.3120000000000001
1.3129999999999999
1.3140000000000001
1.3149999999999999
1.3160000000000001
1.3169999999999999
1.3180000000000001
1.319
1.32
1.321
1.3220000000000001
1.323
1.3240000000000001
1.325
1.3260000000000001
1.327
1.3280000000000001
1.329
1.33
1.331
1.3320000000000001
1.333
1.3340000000000001
1.335
1.3360000000000001
1.337
1.3380000000000001
1.339
1.34
1.341
1.3420000000000001
1.343
1.3440000000000001
1.345
1.3460000000000001
1.347
1.3480000000000001
1.349
1.35
1.351
1.3520000000000001
1.353
1.3540000000000001
1.355
1.3560000000000001
1.357
1.3580000000000001
1.359
1.36
1.361
1.3620000000000001
1.363
1.3640000000000001
1.365
1.3660000000000001
1.367
1.3680000000000001
1.369
1.37
1.371
1.3720000000000001
1.373
1.3740000000000001
1.375
1.3759999999999999
1.377
1.3779999999999999
1.379
1.38
1.381
1.3819999999999999
1.383
1.3839999999999999
1.385
1.3859999999999999
1.387
1.3879999999999999
1.389
1.39
1.391
1.3919999999999999
1.393
1.3939999999999999
1.395
1.3959999999999999
1.397
1.3979999999999999
1.399
1.4
1.401
1.4019999999999999
1.403
1.4039999999999999
1.405
1.4059999999999999
1.407
1.4079999999999999
1.409
1.41
1.411
1.4119999999999999
1.413
1.4139999999999999
1.415
1.4159999999999999
1.417
1.4179999999999999
1.419
1.42
1.421
1.4219999999999999
1.423
1.4239999999999999
1.425
1.4259999999999999
1.427
1.4279999999999999
1.429
1.43
1.431
1.4319999999999999
1.4330000000000001
1.4339999999999999
1.4350000000000001
1.4359999999999999
1.4370000000000001
1.4379999999999999
1.4390000000000001
1.44
1.4410000000000001
1.4419999999999999
1.4430000000000001
1.444
1.4450000000000001
1.446
1.4470000000000001
1.448
1.4490000000000001
1.45
1.4510000000000001
1.452
1.4530000000000001
1.454
1.4550000000000001
1.456
1.4570000000000001
1.458
1.4590000000000001
1.46
1.4610000000000001
1.462
1.4630000000000001
1.464
1.4650000000000001
1.466
1.4670000000000001
1.468
1.4690000000000001
1.47
1.4710000000000001
1.472
1.4730000000000001
1.474
1.4750000000000001
1.476
1.4770000000000001
1.478
1.4790000000000001
1.48
1.4810000000000001
1.482
1.4830000000000001
1.484
1.4850000000000001
1.486
1.4870000000000001
1.488
1.4890000000000001
1.49
1.4910000000000001
1.492
1.4930000000000001
1.494
1.4950000000000001
1.496
1.4970000000000001
1.498
1.4990000000000001
1.5
1.5009999999999999
1.502
1.5029999999999999
1.504
1.5049999999999999
1.506
1.5069999999999999
1.508
1.5089999999999999
1.51
1.5109999999999999
1.512
1.5129999999999999
1.514
1.5149999999999999
1.516
1.5169999999999999
1.518
1.5189999999999999
1.52
1.5209999999999999
1.522
1.5229999999999999
1.524
1.5249999999999999
1.526
1.5269999999999999
1.528
1.5289999999999999
1.53
1.5309999999999999
1.532
1.5329999999999999
1.534
1.5349999999999999
1.536
1.5369999999999999
1.538
1.5389999999999999
1.54
1.5409999999999999
1.542
1.5429999999999999
1.544
1.5449999999999999
1.546
1.5469999999999999
1.548
1.5489999999999999
1.55
1.5509999999999999
1.552
1.5529999999999999
1.554
1.5549999999999999
1.556
1.5569999999999999
1.5580000000000001
1.5589999999999999
1.56
1.5609999999999999
1.5620000000000001
1.5629999999999999
1.5640000000000001
1.5649999999999999
1.5660000000000001
1.5669999999999999
1.5680000000000001
1.569
1.57
1.571
1.5720000000000001
1.573
1.5740000000000001
1.575
1.5760000000000001
1.577
1.5780000000000001
1.579
1.58
1.581
1.5820000000000001
1.583
1.5840000000000001
1.585
1.5860000000000001
1.587
1.5880000000000001
1.589
1.59
1.591
1.5920000000000001
1.593
1.5940000000000001
1.595
1.5960000000000001
1.597
1.5980000000000001
1.599
1.6
1.601
1.6020000000000001
1.603
1.6040000000000001
1.605
1.6060000000000001
1.607
1.6080000000000001
1.609
1.61
1.611
1.6120000000000001
1.613
1.6140000000000001
1.615
1.6160000000000001
1.617
1.6180000000000001
1.619
1.62
1.621
1.6220000000000001
1.623
1.6240000000000001
1.625
1.6259999999999999
1.627
1.6279999999999999
1.629
1.63
1.631
1.6319999999999999
1.633
1.6339999999999999
1.635
1.6359999999999999
1.637
1.6379999999999999
1.639
1.64
1.641
1.6419999999999999
1.643
1.6439999999999999
1.645
1.6459999999999999
1.647
1.6479999999999999
1.649
1.65
1.651
1.6519999999999999
1.653
1.6539999999999999
1.655
1.6559999999999999
1.657
1.6579999999999999
1.659
1.66
1.661
1.6619999999999999
1.663
1.6639999999999999
1.665
1.6659999999999999
1.667
1.6679999999999999
1.669
1.67
1.671
1.6719999999999999
1.673
1.6739999999999999
1.675
1.6759999999999999
1.677
1.6779999999999999
1.679
1.68
1.681
1.6819999999999999
1.6830000000000001
1.6839999999999999
1.6850000000000001
1.6859999999999999
1.6870000000000001
1.6879999999999999
1.6890000000000001
1.69
1.6910000000000001
1.6919999999999999
1.6930000000000001
1.694
1.6950000000000001
1.696
1.6970000000000001
1.698
1.6990000000000001
1.7
1.7010000000000001
1.702
1.7030000000000001
1.704
1.7050000000000001
1.706
1.7070000000000001
1.708
1.7090000000000001
1.71
1.7110000000000001
1.712
1.7130000000000001
1.714
1.7150000000000001
1.716
1.7170000000000001
1.718
1.7190000000000001
1.72
1.7210000000000001
1.722
1.7230000000000001
1.724
1.7250000000000001
1.726
1.7270000000000001
1.728
1.7290000000000001
1.73
1.7310000000000001
1.732
1.7330000000000001
1.734
1.7350000000000001
1.736
1.7370000000000001
1.738
1.7390000000000001
1.74
1.7410000000000001
1.742
1.7430000000000001
1.744
1.7450000000000001
1.746
1.7470000000000001
1.748
1.7490000000000001
1.75
1.7509999999999999
1.752
1.7529999999999999
1.754
1.7549999999999999
1.756
1.7569999999999999
1.758
1.7589999999999999
1.76
1.7609999999999999
1.762
1.7629999999999999
1.764
1.7649999999999999
1.766
1.7669999999999999
1.768
1.7689999999999999
1.77
1.7709999999999999
1.772
1.7729999999999999
1.774
1.7749999999999999
1.776
1.7769999999999999
1.778
1.7789999999999999
1.78
1.7809999999999999
1.782
1.7829999999999999
1.784
1.7849999999999999
1.786
1.7869999999999999
1.788
1.7889999999999999
1.79
1.7909999999999999
1.792
1.7929999999999999
1.794
1.7949999999999999
1.796
1.7969999999999999
1.798
1.7989999999999999
1.8
1.8009999999999999
1.802
1.8029999999999999
1.804
1.8049999999999999
1.806
1.8069999999999999
1.8080000000000001
1.8089999999999999
1.81
1.8109999999999999
1.8120000000000001
1.8129999999999999
1.8140000000000001
1.8149999999999999
1.8160000000000001
1.8169999999999999
1.8180000000000001
1.819
1.82
1.821
1.8220000000000001
1.823
1.8240000000000001
1.825
1.8260000000000001
1.827
1.8280000000000001
1.829
1.83
1.831
1.8320000000000001
1.833
1.8340000000000001
1.835
1.8360000000000001
1.837
1.8380000000000001
1.839
1.84
1.841
1.8420000000000001
1.843
1.8440000000000001
1.845
1.8460000000000001
1.847
1.8480000000000001
1.849
1.85
1.851
1.8520000000000001
1.853
1.8540000000000001
1.855
1.8560000000000001
1.857
1.8580000000000001
1.859
1.86
1.861
1.8620000000000001
1.863
1.8640000000000001
1.865
1.8660000000000001
1.867
1.8680000000000001
1.869
1.87
1.871
1.8720000000000001
1.873
1.8740000000000001
1.875
1.8759999999999999
1.877
1.8779999999999999
1.879
1.88
1.881
1.8819999999999999
1.883
1.8839999999999999
1.885
1.8859999999999999
1.887
1.8879999999999999
1.889
1.89
1.891
1.8919999999999999
1.893
1.8939999999999999
1.895
1.8959999999999999
1.897
1.8979999999999999
1.899
1.9
1.901
1.9019999999999999
1.903
1.9039999999999999
1.905
1.9059999999999999
1.907
1.9079999999999999
1.909
1.91
1.911
1.9119999999999999
1.913
1.9139999999999999
1.915
1.9159999999999999
1.917
1.9179999999999999
1.919
1.92
1.921
1.9219999999999999
1.923
1.9239999999999999
1.925
1.9259999999999999
1.927
1.9279999999999999
1.929
1.93
1.931
1.9319999999999999
1.9330000000000001
1.9339999999999999
1.9350000000000001
1.9359999999999999
1.9370000000000001
1.9379999999999999
1.9390000000000001
1.94
1.9410000000000001
1.9419999999999999
1.9430000000000001
1.944
1.9450000000000001
1.946
1.9470000000000001
1.948
1.9490000000000001
1.95
1.9510000000000001
1.952
1.9530000000000001
1.954
1.9550000000000001
1.956
1.9570000000000001
1.958
1.9590000000000001
1.96
1.9610000000000001
1.962
1.9630000000000001
1.964
1.9650000000000001
1.966
1.9670000000000001
1.968
1.9690000000000001
1.97
1.9710000000000001
1.972
1.9730000000000001
1.974
1.9750000000000001
1.976
1.9770000000000001
1.978
1.9790000000000001
1.98
1.9810000000000001
1.982
1.9830000000000001
1.984
1.9850000000000001
1.986
1.9870000000000001
1.988
1.9890000000000001
1.99
1.9910000000000001
1.992
1.9930000000000001
1.994
1.9950000000000001
1.996
1.9970000000000001
1.998
1.9990000000000001

ざっくり、半分は小数第16位まで保持していると言えそうな印象です。

念のためExcel 2007で作成したxlsxファイルでも確認してみましたが、同じでした。

最終更新日時：2024-01-18 10:23