Bug 127498 - possible regression in TIMEVALUE formula sometime with one second less than expected
Summary: possible regression in TIMEVALUE formula sometime with one second less than e...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2019-09-11 13:24 UTC by mag4
Modified: 2020-05-03 18:10 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file for bug 127498 (18.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-09-11 13:26 UTC, mag4
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mag4 2019-09-11 13:24:51 UTC
Description:
Opening attached Test.ods file with version 6.1.5.2 (Debian Stable) TIMEVALUE formula works as expected, but opening with version 6.3.0.4 (Debian Testing) TIMEVALUE formula resolves with one second less than expected cells B3, B6, B9, B12, B15 (yellow highlighted). Inspecting content.xml it seems a rounding error.
Maybe it is related to bug 127334 ...
Regards!

Guido

Steps to Reproduce:
1. Open Test.ods file with version 6.3.0.4
2. Verify cells B3, B6, B9, B12, B15


Actual Results:
Sometime (but regularly) one second less than the time value of the text cells 

Expected Results:
Ever the time value of the text cells 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Versione: 6.3.0.4
Build ID: 1:6.3.0-2
Thread CPU: 4; SO: Linux 5.2; Resa interfaccia: predefinito; VCL: kde5; 
Versione locale: it-IT (it_IT.UTF-8); Lingua interfaccia: it-IT
Calc: threaded
Comment 1 mag4 2019-09-11 13:26:38 UTC
Created attachment 154104 [details]
Test file for bug 127498
Comment 2 Oliver Brinzing 2019-09-11 17:08:02 UTC
reproducible with:

Version: 6.2.7.1 (x64)
Build-ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

Version: 6.3.1.2 (x64)
Build-ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

this issue *seems* to be a duplicate of:

Bug 125099 - Rounding of durations displayed as wall clock time.
Bug 127143 - Time addition short of one second in calc

@erack: shouldn't we add a [META] issue ?
Comment 3 Xisco Faulí 2019-09-17 14:18:13 UTC
Regression introduced by:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=e2e47898180e547cad7ccde1e5890385d573e551

author	Eike Rathke <erack@redhat.com>	2018-08-31 11:21:03 +0200
committer	Eike Rathke <erack@redhat.com>	2018-08-31 12:50:52 +0200
commit	e2e47898180e547cad7ccde1e5890385d573e551 (patch)
tree	c91b4e1e053c69bbf0906953fe1bba276977ef2c
parent	370d4c9ba34913076f7a73a2912eb2e0e48ca73c (diff)
Use tools::Time::GetClock() in number formatter for wall clock time

Bisected with: bibisect-linux64-6.2 

Adding Cc: to Eike Rathke