Bug 57552

Summary:	excel import filter treats text cells as dates
Product:	[Applications] calligrasheets	Reporter:	Tilman Keskinöz <tilman>
Component:	filters	Assignee:	Laurent Montel <montel>
Status:	RESOLVED FIXED
Severity:	normal	CC:	keerthi.reddyb, mecirt
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	Compiled Sources
OS:	FreeBSD
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	This is the file which is imported correctly with koffice 1.2 and OOo. but not with 1.2.90

Description Tilman Keskinöz 2003-04-22 13:11:45 UTC

Version:           1.2.90 (using KDE Devel)
Installed from:    Compiled sources
Compiler:          gcc 2.95.4 FreeBSD System Compiler
OS:          FreeBSD

a) If the first line in a column is a date,
kspread parses the whole column as dates..

1 is displayes 31/12/99
2 is displayes as 01/01/00

and so on.

in another column the number 308 is classified as: 03/11/00

Comment 1 Tilman Keskinöz 2003-04-22 13:13:57 UTC

Created attachment 1410 [details]
This is the file which is imported correctly with koffice 1.2 and OOo. but not with 1.2.90

Comment 2 Tilman Keskinöz 2004-02-07 15:09:50 UTC

This Bug is still present in Kspread 1.3 in KDE 3.2.0

Comment 3 Michael Nottebrock 2005-01-05 21:54:57 UTC

This bug regressed further, in KSpread 1.3.5 importing the attachment crashes kspread.

Comment 4 Tomas Mecir 2005-01-28 10:55:32 UTC

No crash with KSpread-CVS.
This bug seems to only affect the Excel import filter, not KSpread as a whole - updating bug info accordingly.

It looks like the Excel import filter incorrectly treats cells with Text formatting as cells with Date formatting - changing bug description accordingly.

For the record, old bug summary was:
kspread: format guessing parses numbers as date (1.2 did parse it correctly)

Comment 5 Bram Schoenmakers 2005-04-18 16:46:33 UTC

FYI:
The attachment doesn't make KSpread crash for me in KOffice 1.3.5.
In CVS (18 April 2005) I can see the same problem as Tomas mentioned.

Comment 6 Bram Schoenmakers 2005-04-20 12:13:51 UTC

Bug 46898 has many common with this one.

Comment 7 Ariya Hidayat 2005-05-23 18:30:14 UTC

This is fixed for KOffice 1.4 RC.

Comment 8 keerthi 2011-06-28 11:41:11 UTC

Verified in c7da761cd2cf245608e1498198a81cee6994f46e.