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)
I discovered the bug of Calc of LibreOffice. My personal computer and the version of Libre are as follows. PC:WindowsXP SP3 LibreOffice:3.5.5.3 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.
@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 @LibreFun 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