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

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.)