Bug 137569 - Import text file; large numbers appears as -2,147,483,648
Summary: Import text file; large numbers appears as -2,147,483,648
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (other bugs)
Version First Reported In: 1.6
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-11-19 14:11 UTC by Nick Warne
Modified: 2007-08-01 17:46 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Case study example file (63 bytes, text/plain)
2006-11-19 14:13 UTC, Nick Warne 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Nick Warne 2006-11-19 14:11:37 UTC 
Version:            (using KDE KDE 3.5.5)
Installed from:    Compiled From Sources
Compiler:          GCC 3.4.6 -march=athlon-tbird
OS:                Linux

Importing a "text" comma delimited text file with large numbers that are to be treated as text, the 'large' numbers (always) appear as -2,147,483,648.

I will attach example file as case study.

Nick
Comment 1 Nick Warne 2006-11-19 14:13:33 UTC 
Created attachment 18614 [details]
Case study example file

.
Start Kspread and open this file - ensure all import fields are selected as
'text', delimiter is ','.
Comment 2 Nick Warne 2006-11-19 14:14:23 UTC 
.
Forgot - I am on KOffice 1.6.0 built from source.

Nick
Comment 3 Tais P. Hansen 2007-04-19 11:23:13 UTC 
The problem seems to be that csv import field formats doesn't change cell format in spreadsheet (bug #144415), causing all cells to be "Generic" and all values treated as numbers which in turn is affected by an apparent toInt/toLong bug according to bug #127599.
Comment 4 Stefan Nikolaus 2007-08-01 17:46:43 UTC 
Fixed in the upcoming 2.x series.

I remember a difference with these large numbers between my 32-bit and my 64-bit machine though. Now, I have only access to my 64-bit machine. So, verify, please, and re-open, if necessary.