https://bugs.documentfoundation.org/show_bug.cgi?id=161043
Bug ID: 161043
Summary: CALC Error in SUBTOTAL(9;range) when the source values
are minutes and seconds exceeding 60 minutes
Product: LibreOffice
Version: 7.5.9.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Time values which individually are only a few minutes and seconds but
accumulate to many hours are being presented as just the "mantissa" portion of
the the total time ie. the cumulative total of 547:12:52 in the attached sample
only returns 12:52:00.
Steps to Reproduce:
The seconds in column C have been converted to minutes and seconds by the use
of =TIME(;;Cn) in the adjacent column D.
The mask has been set to just present MM:SS.
The individual calculations are correct unless the seconds (3600) are equal to
or exceed 60 minutes whereby it just presents the "mantissa" minutes and
seconds.
One could argue that an incorrect mask is the culprit but there is no
indication that the number has overflowed into hours and I would argue that
when it does overflow but doesn't indicate perhaps 65:25 it is incorrect.
The SUBTOTAL() function at the top has not been limited by a mask and still
only presents the "mantissa" for the correct total of 547:12:52.
Actual Results:
Hours are dropped/discarded from all "masked" calculations
Expected Results:
1. Accumulate and display any excess minutes within the confines of the mask
ie. 65:25
or
2. Indicate an error condition to permit reassessment of the mask
or
3. Force a more appropriate mask
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
