https://bugs.documentfoundation.org/show_bug.cgi?id=168285
Bug ID: 168285
Summary: Averages of time-formatted values incorrect
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Computing averages of times, formatted as time (HH:MM), often is incorrect. The
sum of the same times is correct, but dividing by the number of elements
returns an incorrect value.
Not all instances of such averages are incorrect; I've been unable to find a
"tipping point" of values, either in the individual values or in the SUM at
which the average begins to fail. Further investigation will be ongoing here.
Steps to Reproduce:
1.enter above values into spreadsheet (I had them in columns E through M)
2.enter suitable formulae in next columns (columns N and O)
3.observe erroneous results
Actual Results:
values: 00:02 00:05 00:08 00:13 00:18 00:06 00:17 00:12 13:28
SUM(): 14:49 [correct]
SUM()/9: 22:58 [incorrect]
AVERAGE(): 22:58 [incorrect, though identical to SUM()/9]
Expected Results:
values: 00:02 00:05 00:08 00:13 00:18 00:06 00:17 00:12 13:28
SUM(): 14:49
SUM()/9: 01:38
AVERAGE(): 01:38
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: fb4792146257752f54eab576deb869869b108571
CPU threads: 32; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
