After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 138182 - [h]:mm is displayed wrong
[h]:mm is displayed wrong
Product: Gnumeric
Classification: Applications
Component: Analytics
Other All
: Urgent blocker
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Reported: 2004-03-26 09:43 UTC by Markus Bertheau
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---

Spreadsheet that exposes the bug. (1.67 KB, application/x-gnumeric)
2004-03-26 09:44 UTC, Markus Bertheau
A similar case (1.72 KB, application/x-gnumeric)
2004-05-24 00:34 UTC, Markus Bertheau

Description Markus Bertheau 2004-03-26 09:43:24 UTC
19:00-10:40-0:45 = 7:34

should be 7:35

I'll attach a simple spreadsheet.
Comment 1 Markus Bertheau 2004-03-26 09:44:16 UTC
Created attachment 25969 [details]
Spreadsheet that exposes the bug.
Comment 2 Markus Bertheau 2004-03-26 12:24:42 UTC
I can't even enter 81:04 in a [hh]:mm field, it shows as 81:03
Comment 3 Jody Goldberg 2004-03-26 15:33:15 UTC
I can not replicate this with 1.2.8

What version are you using ?  A patch went in for something similar around 1.2.2
Comment 4 Markus Bertheau 2004-03-29 11:22:42 UTC
1.2.1 from Fedora Core 1, So I guess this is resolved fixed. Strangely I can
close the bug but not set the resolution.
Comment 5 Markus Bertheau 2004-04-01 13:28:22 UTC
1.2.6 still has the error for me. There's no newer version to test for Fedora.
Comment 6 Jody Goldberg 2004-04-01 14:17:27 UTC
Damn.  I looked at your example in the bug and not the spreadsheet.
The order of operations makes a difference.

We'll delay 1.2.9 until this is fixed.
Comment 7 Morten Welinder 2004-04-01 17:01:44 UTC
This is somehow related to the format in D1.    It's [h]:mm.
If you just type =b1-a1-c1 in another cell you get h:mm which shows as 7:35.

D1's value is such that D1*3600*24 is 27300.000...001, i.e., *more* that what
it's exact value would be.
Comment 8 Markus Bertheau 2004-04-01 17:13:32 UTC
Also try just entering 81:04 in a new spreadsheet. Gives me 81:03 in 1.2.6.
Comment 9 Morten Welinder 2004-04-01 20:31:56 UTC
Fixed in cvs.
Comment 10 Markus Bertheau 2004-05-24 00:34:23 UTC
Created attachment 27949 [details]
A similar case

I haven't got 1.2.9 around to test and wanted to save that file here in case.

1.2.8 displays

76:10	76:00	-0:09

Comment 11 Jody Goldberg 2004-05-24 03:51:10 UTC
1.2.12 and cvs head report -0:10 as expected.