Bug 57552

Summary: excel import filter treats text cells as dates
Product: calligrasheets Reporter: Tilman Keskinöz <tilman>
Component: filtersAssignee: 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:
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.