To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65030 Issue #:|65030 Summary:|critical import error Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|ahmetalperparker
------- Additional comments from [EMAIL PROTECTED] Wed May 3 04:09:05 -0700 2006 ------- when importing a datafile in csv format in some of the rows and columns the calc does not recognize the comma and assign a greater value for that number. In ex the imported value is 1.345 but it recognizes as 1345 . also it imports almost most of the document correctly however this occurs in some cells only. I have supplied the csv file as attachment and one of the problemed cells are b178 and b191. I am importing the file as seperated by tab, comma, space and merge delimeters up to the default import options. please copy the entire code to a new txt file and rename it as csv if the attachment does not work Regards... 5000 -1.1957 10000 -1.41013 15000 -1.52505 20000 -1.58821 25000 -1.62788 30000 -1.65713 35000 -1.68147 40000 -1.70313 45000 -1.72307 50000 -1.74173 55000 -1.75936 60000 -1.77611 65000 -1.79211 70000 -1.80744 75000 -1.82218 80000 -1.83637 85000 -1.85008 90000 -1.86335 95000 -1.87621 100000 -1.8887 105000 -1.90084 110000 -1.91267 115000 -1.9242 120000 -1.93546 125000 -1.94646 130000 -1.95721 135000 -1.96775 140000 -1.97807 145000 -1.9882 150000 -1.99813 155000 -2.00789 160000 -2.01748 165000 -2.02691 170000 -2.03618 175000 -2.04532 180000 -2.05431 185000 -2.06318 190000 -2.07192 195000 -2.08053 200000 -2.08904 205000 -2.09743 210000 -2.10572 215000 -2.1139 220000 -2.12199 225000 -2.12998 230000 -2.13788 235000 -2.14569 240000 -2.15342 245000 -2.16106 250000 -2.16863 255000 -2.17611 260000 -2.18353 265000 -2.19087 270000 -2.19813 275000 -2.20533 280000 -2.21247 285000 -2.21954 290000 -2.22654 295000 -2.23349 300000 -2.24037 305000 -2.24719 310000 -2.25396 315000 -2.26067 320000 -2.26733 325000 -2.27394 330000 -2.28049 335000 -2.28699 340000 -2.29344 345000 -2.29984 350000 -2.3062 355000 -2.31251 360000 -2.31877 365000 -2.32499 370000 -2.33116 375000 -2.33729 380000 -2.34338 385000 -2.34942 390000 -2.35543 395000 -2.36139 400000 -2.36732 405000 -2.3732 410000 -2.37905 415000 -2.38486 420000 -2.39064 425000 -2.39637 430000 -2.40208 435000 -2.40774 440000 -2.41337 445000 -2.41897 450000 -2.42454 455000 -2.43007 460000 -2.43556 465000 -2.44103 470000 -2.44646 475000 -2.45187 480000 -2.45724 485000 -2.46258 490000 -2.46789 495000 -2.47317 500000 -2.47843 505000 -2.48365 510000 -4.22016 515000 -4.40211 520000 -4.47629 525000 -4.52931 530000 -4.56894 535000 -4.60197 540000 -4.63132 545000 -4.65753 550000 -4.68101 555000 -4.70271 560000 -4.72286 565000 -4.74181 570000 -4.75966 575000 -4.77676 580000 -4.79297 585000 -4.8087 590000 -4.82392 595000 -4.83849 600000 -4.85292 605000 -4.86675 610000 -4.88032 615000 -4.89363 620000 -4.90657 625000 -4.91934 630000 -4.93192 635000 -4.9442 640000 -4.95625 645000 -4.96832 650000 -4.98014 655000 -4.99159 660000 -5.00314 665000 -5.01457 670000 -5.02568 675000 -5.03682 680000 -5.04774 685000 -5.05865 690000 -5.06953 695000 -5.07997 700000 -5.09058 705000 -5.10106 710000 -5.11144 715000 -5.1218 720000 -5.13183 725000 -5.14196 730000 -5.15202 735000 -5.16197 740000 -5.17187 745000 -5.18161 750000 -5.19131 755000 -5.20105 760000 -5.21066 765000 -5.22014 770000 -5.22966 775000 -5.23891 780000 -5.24827 785000 -5.25773 790000 -5.2669 795000 -5.27603 800000 -5.28518 805000 -5.29425 810000 -5.30316 815000 -5.31226 820000 -5.32116 825000 -5.33005 830000 -5.33886 835000 -5.3476 840000 -5.35627 845000 -5.36493 850000 -5.37366 855000 -5.38211 860000 -5.39064 865000 -5.39912 870000 -5.40765 875000 -5.41612 880000 -5.42435 885000 -5.43268 890000 -5.441 895000 -5.44926 900000 -5.4575 905000 -5.46559 910000 -5.47369 915000 -5.4818 920000 -5.48986 925000 -5.4978 930000 -5.50573 935000 -5.51383 940000 -5.52164 945000 -5.52951 950000 -5.53727 955000 -5.545 960000 -5.55285 965000 -5.56048 970000 -5.56819 975000 -5.57585 980000 -5.58346 985000 -5.59099 990000 -5.59865 995000 -5.6061 1e+006 -5.61352 1.005e+006 -5.62095 1.01e+006 -5.62841 1.015e+006 -5.63585 1.02e+006 -5.64313 1.025e+006 -5.65043 1.03e+006 -5.65775 1.035e+006 -5.66502 1.04e+006 -5.67229 1.045e+006 -5.67941 1.05e+006 -5.68655 1.055e+006 -5.69369 1.06e+006 -5.70081 1.065e+006 -5.70787 1.07e+006 -5.7149 1.075e+006 -5.72198 1.08e+006 -5.7289 1.085e+006 -5.73589 1.09e+006 -5.74284 1.095e+006 -5.7497 1.1e+006 -5.75658 1.105e+006 -5.76343 1.11e+006 -5.77028 1.115e+006 -5.77701 1.12e+006 -5.78375 1.125e+006 -5.79053 1.13e+006 -5.79723 1.135e+006 -5.80403 1.14e+006 -5.81064 1.145e+006 -5.8172 1.15e+006 -5.8238 1.155e+006 -5.83032 1.16e+006 -5.837 1.165e+006 -5.84349 1.17e+006 -5.84994 1.175e+006 -5.8565 1.18e+006 -5.86291 1.185e+006 -5.86931 1.19e+006 -5.87569 1.195e+006 -5.88217 1.2e+006 -5.88843 1.205e+006 -5.8948 1.21e+006 -5.90102 1.215e+006 -5.90727 1.22e+006 -5.91361 1.225e+006 -5.91984 1.23e+006 -5.92603 1.235e+006 -5.93219 1.24e+006 -5.93838 1.245e+006 -5.94449 1.25e+006 -5.95069 1.255e+006 -5.95671 1.26e+006 -5.96277 1.265e+006 -5.96882 1.27e+006 -5.97489 1.275e+006 -5.98083 1.28e+006 -5.98678 1.285e+006 -5.99278 1.29e+006 -5.99862 1.295e+006 -6.00461 1.3e+006 -6.01051 1.305e+006 -6.0163 1.31e+006 -6.02218 1.315e+006 -6.02802 1.32e+006 -6.03382 1.325e+006 -6.03967 1.33e+006 -6.04534 1.335e+006 -6.05111 1.34e+006 -6.05684 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
