| Author |
 Topic  |
|
|
70WorkRoom
China
Posts |
 Posted - 07/14/2007 : 09:46:02 AM
|
Origin Version (Select Help-->About Origin): Origin pro 7.5
Operating System:windows 2000
I find something wonderful.
When I copy some data from excel to the origin worksheet,something change.This is the excel data:
0.003315371 -12.68602888
0.003288059 -12.53321066
0.003261194 -12.39201454
0.003234764 -12.26424946
0.003208759 -12.12346726
0.003183169 -11.96750037
0.003157984 -11.82056202
0.003133194 -11.67324142
0.00310879 -11.52320555
0.003084764 -11.3942158
0.003061106 -11.28117447
0.003037808 -11.18196835
0.003014862 -11.10304506
0.00299226 -11.02593425
0.002969995 -10.95195242
0.002948058 -10.88429521
0.002926444 -10.82641531
0.002905143 -10.78780699
0.002884151 -10.7298827
0.00286346 -10.72491137
0.002843063 -10.69233941
0.002822955 -10.66050596
0.00280313 -10.62291881
0.002783581 -10.6093007
0.002764303 -10.58900318
0.00274529 -10.58250456
0.002726537 -10.55662577
0.002708038 -10.56110962
0.002689789 -10.49915844
0.002671784 -10.57417969
0.002654018 -10.54662203
0.002636487 -10.5415281
0.002619186 -10.49944763
0.002602111 -10.50621636
0.002585257 -10.53643058
0.002568619 -10.50988523
0.002552195 -10.55342326
0.002535979 -10.48581673
0.002519968 -10.45200254
0.002504158 -10.45654188
0.002488545 -10.4357636
0.002473126 -10.51505106
0.002457897 -10.47342052
0.002442853 -10.38305173
0.002427993 -10.38144573
0.002413313 -10.40620018
0.002398809 -10.34436921
0.002384478 -10.36643771
0.002370318 -10.31842752
0.002356325 -10.26479878
0.002342496 -10.12262405
0.002328828 -10.23016684
0.002315319 -10.24601574
0.002301966 -10.24963563
0.002288766 -10.32214976
0.002275716 -10.16118057
0.002262815 -10.24395934
When copy to origin worksheet,it is:
0.00332 -12.68603
0.00329 -12.53321
0.00326 -12.39201
0.00323 -12.26425
0.00321 -12.12347
0.00318 -11.9675
0.00316 -11.82056
0.00313 -11.67324
0.00311 -11.52321
0.00308 -11.39422
0.00306 -11.28117
0.00304 -11.18197
0.00301 -11.10305
0.00299 -11.02593
0.00297 -10.95195
0.00295 -10.8843
0.00293 -10.82642
0.00291 -10.78781
0.00288 -10.72988
0.00286 -10.72491
0.00284 -10.69234
0.00282 -10.66051
0.0028 -10.62292
0.00278 -10.6093
0.00276 -10.589
0.00275 -10.5825
0.00273 -10.55663
0.00271 -10.56111
0.00269 -10.49916
0.00267 -10.57418
0.00265 -10.54662
0.00264 -10.54153
0.00262 -10.49945
0.0026 -10.50622
0.00259 -10.53643
0.00257 -10.50989
0.00255 -10.55342
0.00254 -10.48582
0.00252 -10.452
0.0025 -10.45654
0.00249 -10.43576
0.00247 -10.51505
0.00246 -10.47342
0.00244 -10.38305
0.00243 -10.38145
0.00241 -10.4062
0.0024 -10.34437
0.00238 -10.36644
0.00237 -10.31843
0.00236 -10.2648
0.00234 -10.12262
0.00233 -10.23017
0.00232 -10.24602
0.0023 -10.24964
0.00229 -10.32215
0.00228 -10.16118
0.00226 -10.24396
the problem is,sometime 0.003315371 change to 0.00332,but 0.002905143 change to 0.00290,what is the orderliness?Will it make the fit linear inaccurate.
And when it use "tempB = oExcelWksh.Cells(i + 1, 5).Text;" to get the second column value,it can only return,for example -10.161,can't be full,why??
I hope you can help me.thanks very much.
|
|
|
Mike Buess
USA
3037 Posts |
Posted - 07/14/2007 : 10:03:09 AM
|
The numbers are stored to worksheet in full precision but Origin hides some digits for display purposes. To show all digits open Tools> Options, go to the Numeric Format tab and increase the Number of Decimal Digits. Then click OK and refresh the worksheet. You'll have to increase the column widths in order to see all digits...
Number of Decimal Digits: 5
Number of Decimal Digits: 8
Mike Buess
Origin WebRing Member |
 |
|
|
70WorkRoom
China
Posts |
Posted - 07/14/2007 : 10:58:23 AM
|
| I really appreciate your help. |
|
|
| |
Topic |
|
|
|
About copy data from excel to worksheet