Bug 123365 - Calculation of time values of by one with custom formating
Summary: Calculation of time values of by one with custom formating
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) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-02-11 16:28 UTC by maximilian.j.walter+libre
Modified: 2019-02-11 17:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 maximilian.j.walter+libre 2019-02-11 16:28:46 UTC 
Description:
The calculation with time value with a custom formating are off by one minute. It happens mostly for negative value calculations. 

Steps to Reproduce:
1.Format Cells with custom formater [HH]:MM
2. Enter 40:00 in Cell A1
3. Enter 3:29 in Cell B1
4. Enter 45:29 in Cell C1
5. Enter =A1-C1+B1 in D1

Actual Results:
-1:59

Expected Results:
-2:00


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Linux 4.20; UI render: default; VCL: gtk3; 
Flatpak
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 1 Oliver Brinzing 2019-02-11 17:36:41 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 ***