Bug 137569

Summary:	Import text file; large numbers appears as -2,147,483,648
Product:	[Applications] calligrasheets	Reporter:	Nick Warne <nick>
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version First Reported In:	1.6
Target Milestone:	---
Platform:	Compiled Sources
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:
Attachments:	Case study example file

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.