Bug 123247 - Sum of cells containing time values incorrect
Summary: Sum of cells containing time values incorrect
Status: RESOLVED DUPLICATE of bug 122991
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2019-02-08 04:17 UTC by testgallery24
Modified: 2019-02-08 21:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample Calc spreadsheet to demonstrate bug. (8.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-08 04:19 UTC, testgallery24 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description testgallery24 2019-02-08 04:17:14 UTC 
Description:
Using Time format [HH]:SS the sum of several cells containing time values is incorrect (one minute below correct value).


Steps to Reproduce:
1. Create a few cells with Time format code [HH]:MM
2. In one cell, enter 0:35 (for 35 minutes), in another enter 1:05 (for 1 hour, 5 minutes) and in another enter 0:10 (for 10 minutes).
3. Sum total of cells above in a new cell and result is 1:49 (should be 1:50).

If sum looks OK (1:50), try Ctrl+Shift+F9 (which I do occasionally to update input fields). Sum will then change to 1:49.

Actual Results:
Sum total of cells in example above gives 1:49 (for 1 hour, 49 minutes).


Expected Results:
Sum total of cells in example above should be 1:50 (for 1 hour, 50 minutes).


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Comment 1 testgallery24 2019-02-08 04:19:48 UTC 
Created attachment 149002 [details]
Sample Calc spreadsheet to demonstrate bug.

Open sample Calc spreadsheet.
Use Ctrl+Shift+F9 (I use this to update input fields but there are none in this sample).
Sum of time values is incorrect (off by 1 minute).
Comment 2 Oliver Brinzing 2019-02-08 12:00:07 UTC 
reproducible with:

Version: 6.1.5.2 (x64)
Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: 


but *not* reproducible with:

Version: 6.1.5.2 (x64)
Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: 

btw: i am not sure if the Change was intended
Comment 3 Oliver Brinzing 2019-02-08 12:05:51 UTC 
please ignore Comment 2


reproducible with:

Version: 6.2.0.3 (x64)
Build-ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

but *not* reproducible with:

Version: 6.1.5.2 (x64)
Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: 

btw: i am not sure if the change was intended
Comment 4 Oliver Brinzing 2019-02-08 17:47:45 UTC 
it's a bug, and will be fixed in LO 6.2.1

*** This bug has been marked as a duplicate of bug 122991 ***
Comment 5 testgallery24 2019-02-08 21:42:18 UTC 
Thank you.

(I searched before posting but did not see bug 122991.)