[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#604773: [kspread] Time cells shown as 00:00 when ODS file is loaded, corrupted when saving as ODS

Package: kspread
Version: 1:2.2.1-3
Severity: grave
Tags: upstream fixed-upstream

2 days ago a new OOo migrated to squeeze and I decided to remove it, forgetting that I used Calc daily for my timesheet - ahem. So when I opened my timesheet yesterday, it didn't open with Calc, but with KSpread, which I also had installed. I thought I wouldn't bother to reinstall OOo just for that, so I added November 21's time, saved and closed. It's about time we started seeing the wonders of ODF, right?

Today, I opened again the spreadsheet and noticed the times were really wrong. I asked on #koffice and was informed by Marijn Kruisselbrink this was a bug he had fixed for KOffice 2.3 (so no fix released yet). The upstream report is https://bugs.kde.org/show_bug.cgi?id=253042 The precise details of this issue are not clear, but basically, when certain time values are saved in an ODS file, the time saved has some random data. When reopening the same file which looked OK, KSpread shows the time as 00:00:00. If you click the cell, you see the value in the top bar is the actual value - apparently. This does not work so well with other ODS programs, like Calc (and probably the fixed KSpread), which rather shows some more or less random values. What happened in my spreadsheet from Calc was that all durations of at least 1 hour were not corrupted, all others were corrupted. So the 25 minutes entries (00:25:00) were corrupted, but not 01:10:00.

To reproduce, just create a new sheet, put 5:00 in A1, save, and watch the displayed value change to 0:00 when reopening the document.

According to Marijn, there is no 2.2.3 planned. I don't think the fix was backported to branch 2.2, but Marijn doesn't think this would be hard. The fix is very short: http://websvn.kde.org/?revision=1183113&view=revision

Reply to: