Bug#604773: marked as done ([kspread] Time cells shown as 00:00 when ODS file is loaded, corrupted when saving as ODS)
Your message dated Mon, 29 Nov 2010 01:03:28 +0000
with message-id <E1PMs9Q-0004lY-L1@franck.debian.org>
and subject line Bug#604773: fixed in koffice 1:2.2.1-4
has caused the Debian Bug report #604773,
regarding [kspread] Time cells shown as 00:00 when ODS file is loaded, corrupted when saving as ODS
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)
--
604773: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=604773
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Source: koffice
Source-Version: 1:2.2.1-4
We believe that the bug you reported is fixed in the latest version of
koffice, which is due to be installed in the Debian FTP archive:
karbon_2.2.1-4_amd64.deb
to main/k/koffice/karbon_2.2.1-4_amd64.deb
kchart_2.2.1-4_amd64.deb
to main/k/koffice/kchart_2.2.1-4_amd64.deb
kexi_2.2.1-4_amd64.deb
to main/k/koffice/kexi_2.2.1-4_amd64.deb
kformula_2.2.1-4_amd64.deb
to main/k/koffice/kformula_2.2.1-4_amd64.deb
koffice-data_2.2.1-4_all.deb
to main/k/koffice/koffice-data_2.2.1-4_all.deb
koffice-dbg_2.2.1-4_amd64.deb
to main/k/koffice/koffice-dbg_2.2.1-4_amd64.deb
koffice-dev_2.2.1-4_amd64.deb
to main/k/koffice/koffice-dev_2.2.1-4_amd64.deb
koffice-doc-html_2.2.1-4_all.deb
to main/k/koffice/koffice-doc-html_2.2.1-4_all.deb
koffice-libs_2.2.1-4_amd64.deb
to main/k/koffice/koffice-libs_2.2.1-4_amd64.deb
koffice_2.2.1-4.debian.tar.gz
to main/k/koffice/koffice_2.2.1-4.debian.tar.gz
koffice_2.2.1-4.dsc
to main/k/koffice/koffice_2.2.1-4.dsc
koffice_2.2.1-4_all.deb
to main/k/koffice/koffice_2.2.1-4_all.deb
kplato_2.2.1-4_amd64.deb
to main/k/koffice/kplato_2.2.1-4_amd64.deb
kpresenter_2.2.1-4_amd64.deb
to main/k/koffice/kpresenter_2.2.1-4_amd64.deb
krita-data_2.2.1-4_all.deb
to main/k/koffice/krita-data_2.2.1-4_all.deb
krita_2.2.1-4_amd64.deb
to main/k/koffice/krita_2.2.1-4_amd64.deb
kspread_2.2.1-4_amd64.deb
to main/k/koffice/kspread_2.2.1-4_amd64.deb
kthesaurus_2.2.1-4_amd64.deb
to main/k/koffice/kthesaurus_2.2.1-4_amd64.deb
kword-data_2.2.1-4_all.deb
to main/k/koffice/kword-data_2.2.1-4_all.deb
kword_2.2.1-4_amd64.deb
to main/k/koffice/kword_2.2.1-4_amd64.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 604773@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Debian Qt/KDE Maintainers <debian-qt-kde@lists.debian.org> (supplier of updated koffice package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Mon, 29 Nov 2010 02:01:30 +0200
Source: koffice
Binary: koffice koffice-doc-html karbon kchart kexi kformula kplato kpresenter krita krita-data kspread kword kword-data kthesaurus koffice-libs koffice-data koffice-dev koffice-dbg
Architecture: source all amd64
Version: 1:2.2.1-4
Distribution: unstable
Urgency: low
Maintainer: Debian Qt/KDE Maintainers <debian-qt-kde@lists.debian.org>
Changed-By: Debian Qt/KDE Maintainers <debian-qt-kde@lists.debian.org>
Description:
karbon - a vector graphics application for the KDE Office Suite
kchart - chart drawing components for the KDE Office Suite
kexi - integrated database environment for the KDE Office Suite
kformula - formula drawing component for the KDE Office Suite
koffice - KDE Office Suite
koffice-data - common shared data for the KDE Office Suite
koffice-dbg - debugging symbols for KOffice
koffice-dev - common libraries for KOffice (development files)
koffice-doc-html - KDE Office Suite documentation in HTML format
koffice-libs - common libraries and binaries for the KDE Office Suite
kplato - an integrated project management and planning tool
kpresenter - a presentation program for the KDE Office Suite
krita - a pixel-based image manipulation program for the KDE Office Suite
krita-data - data files for Krita painting program
kspread - a spreadsheet for the KDE Office Suite
kthesaurus - thesaurus for the KDE Office Suite
kword - a word processor for the KDE Office Suite
kword-data - data files for KWord word processor
Closes: 604773
Changes:
koffice (1:2.2.1-4) unstable; urgency=low
.
[ Modestas Vainius ]
* Add patch kspread_backport_fix_time_values_in_ods.diff to fix saving of
time values in ods files in kspread. (Closes: #604773)
* Remove quilt from Build-Depends. The package is 3.0 (quilt) and quilt build
dependency makes debian-qt-kde.mk automatically (un)apply patches as if
source format was 1.0. This is definitely wrong and might lead to weird
FTBFSes sometimes.
Checksums-Sha1:
6ebaa1a04e902552e28c244a5174dad5c8123b01 1962 koffice_2.2.1-4.dsc
b8895f515e93a854d6487d856c811e3b3c5ad458 48761 koffice_2.2.1-4.debian.tar.gz
dcbbe2fe36b912ab33a6b15bf80434f98983b631 11270 koffice_2.2.1-4_all.deb
3baf7fbdb19e39905c342a1508469cdd884a2e1a 2231236 koffice-doc-html_2.2.1-4_all.deb
7a33c8db6ea199b72949b11369a2ae2b11253dbb 3002814 krita-data_2.2.1-4_all.deb
7b4ccf2d704d00b266efe51f7414a4f5a9b0b879 160730 kword-data_2.2.1-4_all.deb
0c6b9fb06f4fc689a65ea14bc0dc65d749d0eb68 754890 koffice-data_2.2.1-4_all.deb
77d4048511de14b59d18ba8bccd5ca67b0949b08 870752 karbon_2.2.1-4_amd64.deb
db43aeca8c634b8d1015aab6c068801faa1b0317 1007492 kchart_2.2.1-4_amd64.deb
b11bd9580d28110a9cb8578f485b5b1433f33cae 2639074 kexi_2.2.1-4_amd64.deb
d8f46c4ded2159e8ed98d44cffa65d6e4435aea8 985746 kformula_2.2.1-4_amd64.deb
0c44adec3c7931b446e40506e45b8fab96dc20b3 1940910 kplato_2.2.1-4_amd64.deb
feb41e0103be68f71eacd43ede52432d65ee5821 969932 kpresenter_2.2.1-4_amd64.deb
86aca247457652ed1f6985d6083aef47488329bb 4136600 krita_2.2.1-4_amd64.deb
247f1f8dcc58836c1072cc6063e0c5c8f2f7af19 2854932 kspread_2.2.1-4_amd64.deb
43a10d6cec2103016a0af2d6ff9cc5ec30f23587 1907478 kword_2.2.1-4_amd64.deb
3b9a1afe595cf08c4df92e6ffc4cd42e6c6f65de 20084 kthesaurus_2.2.1-4_amd64.deb
5f6db439e7b4192e2af553f18ed32a74a290ccfd 3853772 koffice-libs_2.2.1-4_amd64.deb
101e538bef42fda8fc38d885ed569dbd9ef7eac7 331672 koffice-dev_2.2.1-4_amd64.deb
62f460e1dbba2e4dfde9d2e054aecd6ca64b59c2 187202662 koffice-dbg_2.2.1-4_amd64.deb
Checksums-Sha256:
7685bb4b7ed25e54b33797b4c5f5c3f824700ae208d099169b34d9af8412aa6a 1962 koffice_2.2.1-4.dsc
db2ed49486cb0baf6aa11d5d53fd664d06ef094aa7a90e1c0c67a29afb0eb94f 48761 koffice_2.2.1-4.debian.tar.gz
46995a9170747d9c819a395900e4e8737b88e0ccd71e6285c021a69cdfd6e980 11270 koffice_2.2.1-4_all.deb
6366851d41c89972329aef7bda571a205ee82d74ce95873453a1bd1221e22324 2231236 koffice-doc-html_2.2.1-4_all.deb
2c11d0a2fa267b5d0fdb7fe1b20df9ccef5a71395ad9290e44ae8aae399cfa2a 3002814 krita-data_2.2.1-4_all.deb
9ac5cc27ff3bebebe1439009f724e3915d3e7afb68b00a6b87fc14e180c25326 160730 kword-data_2.2.1-4_all.deb
5b6cb9c187024cee87fd14587d1ebd95f1b05fae05cb7d9bde615f8da4683b41 754890 koffice-data_2.2.1-4_all.deb
f15e1ec6c7807a5c39aa0be2ffafe05181627c8d4f5d73e2cb016061cead8cf6 870752 karbon_2.2.1-4_amd64.deb
b0bdbc5a5e22f723350c64f29f4cb456ea5e7808ec97c9d4c27f7925f0d7a157 1007492 kchart_2.2.1-4_amd64.deb
6ae03385a407f5e5e4035a64dc5512c57b85f2acb9e8233d79a28807257aa9e6 2639074 kexi_2.2.1-4_amd64.deb
8cac3071486006afa0a73c70aac99e32c4973ff6751108d313ea8514a2d377b9 985746 kformula_2.2.1-4_amd64.deb
751d2015d1c0dc54b49241171a6b44eff5aeb288107546943dd6141bead99d84 1940910 kplato_2.2.1-4_amd64.deb
df50fcbb6b77905138b398d55a203d7ccfcca3c2c9563f2de1751851f27110ae 969932 kpresenter_2.2.1-4_amd64.deb
ca83020a72977f7ded8bf2337415f8bcdc21ecba58f85a5beb295eb1c22c758d 4136600 krita_2.2.1-4_amd64.deb
30a2601fc5c75e714d2bd926599b8f4666a58455356340d6a5827875d8d2a454 2854932 kspread_2.2.1-4_amd64.deb
4453dd9f4f22e3f3ee65b4bcc031aaceeccb5c3dc39fd650987beb6cee772c23 1907478 kword_2.2.1-4_amd64.deb
9c15a0f8d1582f99a4fbe8828566d9e50a2c7af11320018d1e4c47bc576b4829 20084 kthesaurus_2.2.1-4_amd64.deb
0dc88499563d736c5dfb7b206c0d1a26468c2188e74a91feb7b2a62ac0e0017b 3853772 koffice-libs_2.2.1-4_amd64.deb
ee39de20d8dc81b54f239ab7ef6de03daeb39c485aae1565c59bd80b4f3dfc50 331672 koffice-dev_2.2.1-4_amd64.deb
a3ae74c536626f09e369f15b65fd949660cac4e482b5881e93b0391f056e997e 187202662 koffice-dbg_2.2.1-4_amd64.deb
Files:
ee76aa750650399642606a02ab2735fc 1962 kde optional koffice_2.2.1-4.dsc
0918113eca170f24066bb09531d798d6 48761 kde optional koffice_2.2.1-4.debian.tar.gz
f19acd2621ff661f4c8efbb44fb950b1 11270 kde optional koffice_2.2.1-4_all.deb
ac0b8b7a44400cb62d8c341ca6b2a19c 2231236 doc optional koffice-doc-html_2.2.1-4_all.deb
1fdd69c74645aa8c334f3ff63b7377e1 3002814 kde optional krita-data_2.2.1-4_all.deb
122eb44f76b46c97476035eb72084b35 160730 kde optional kword-data_2.2.1-4_all.deb
040cf363c22df832f2a2adecf6cc3d4d 754890 libs optional koffice-data_2.2.1-4_all.deb
c38706cc11a4504868951f8309072193 870752 graphics optional karbon_2.2.1-4_amd64.deb
05934b41744efe50d1fd772bd936b9be 1007492 kde optional kchart_2.2.1-4_amd64.deb
0ca8acaaffa49f20dd9ec0f7dd72257a 2639074 kde optional kexi_2.2.1-4_amd64.deb
29c0699fe101605eea59ad151ad011e1 985746 kde optional kformula_2.2.1-4_amd64.deb
f5de703a3b44da75f129c223d096425e 1940910 kde optional kplato_2.2.1-4_amd64.deb
17886af4e3f82be15059c6d8c65ac5fc 969932 kde optional kpresenter_2.2.1-4_amd64.deb
548ae8f791b16b88c48a5151d2c80877 4136600 kde optional krita_2.2.1-4_amd64.deb
7e75de0ef049a1827d1019305f08c9d6 2854932 kde optional kspread_2.2.1-4_amd64.deb
30e870f516f99a1bb96574e941f66ad0 1907478 kde optional kword_2.2.1-4_amd64.deb
0e16dc5d7596a01807c46f802b0b02bd 20084 kde optional kthesaurus_2.2.1-4_amd64.deb
8560196e3549da1735b9374b125b2714 3853772 libs optional koffice-libs_2.2.1-4_amd64.deb
65c215c895a09d899050be239ea29aec 331672 kde optional koffice-dev_2.2.1-4_amd64.deb
b36e5ee72c86cc2a0196a8dbda56453b 187202662 debug extra koffice-dbg_2.2.1-4_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAkzy+OUACgkQHO9JRnPq4hQN/wCglbQmyXTvu6T0MCrFgF9bAfm7
E/sAnApD1Ih3vc5nT0zx/mm7H+WIWuPr
=lBST
-----END PGP SIGNATURE-----
--- End Message ---
Reply to: