Bug 57840 - FORMATTING Status Bar SUM Field: Unexpected result for time values
Summary: FORMATTING Status Bar SUM Field: Unexpected result for time values
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2012-12-03 13:40 UTC by Juraj Kiaba
Modified: 2020-05-01 10:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Juraj Kiaba 2012-12-03 13:40:03 UTC
Problem description: When you select more cells with time it counts only to 24 hours in lowest row on the right side. It should show something like 27:30 or 145:00 or 1 day 4:00.

Steps to reproduce:
1. ....
2. ....
3. ....

Current behavior:

Expected behavior: Show days if count is more then 24 hours, or right number of hours like 48:30 (48 hours 30 minutes).

Operating System: Windows (other)
Comment 1 LibreFun 2013-01-25 12:58:20 UTC
I discovered the bug of Calc of LibreOffice. 
My personal computer and the version of Libre are as follows. 
PC:WindowsXP SP3
It is not displayed correctly that I input the date into Cell of Calc. 
1904-12-01  -> 1904-11-30 
1932-01-01  -> 1931-12-31 
1961-08-10  -> 1961-08-09 
1968-10-01  -> 1968-09-30 
Another is a bug of [Data]-[Text to Column] of a menu bar. 
Although I inputted 19600515 into Cell, I was not able to change into 1960-05-15. 
I was able to change 19600514 correctly.
Comment 2 Rainer Bielefeld Retired 2013-02-25 08:53:49 UTC
@Juraj Kiaba
The formatting in the Status Bar Sum Field is identical with the first in the SUM range. So the change of day is not visible. 
And the formatting is a day time, not "NumberOfHours:NumberOfMinutes". So your wish can not be fulfilled.
Please feel free to open a separate enhancement request if you can contribute a comprehensible reasoning with a conclusive real life example what shows that your enhancement would be useful for many users.
So, for example, it might be useful to show always a YYYY-DD-MM hh:mm:ss formatting for time related SUM in status bar or whatever, I don't know.

Currently NOTABUG

I can not see what your problem(s) have to do with the original report. Please read <http://wiki.documentfoundation.org/BugReport>
<http://wiki.documentfoundation.org/BugReport#General_information> item 4