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