[Libreoffice-bugs] [Bug 132582] New: SUM (in status bar) produces different result depending on first value (and selection direction), when counting times

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132582

            Bug ID: 132582
           Summary: SUM (in status bar) produces different result
                    depending on first value (and selection direction),
                    when counting times
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cno at nouenoff.nl

Will attach a spreadsheet

There are some ranges with times (HH:MM:SS)

1 – Select from D6 to D2 (bottom to top)
  > notice that the sum restarts counting at 24

2 – Select from H5 to H2 (bottom to top)
  > notice that the sum continues to count above 24

Interesting :)

= = = Note! 
I thought this could be related to the fact that counting columns of time cells
with SUM() sometimes restarts at 24, and sometimes just totals..
I've seen this effect for over 10 year now, but never fiddled out what made the
difference.
Alas I see no way how the now reported bug, influences that..
= = =

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200501/6836d0cc/attachment-0001.htm>