https://bugs.freedesktop.org/show_bug.cgi?id=83414
--- Comment #10 from penttila <pentt...@freemail.hu> --- Sorry but something is not OK for me! I would like to add the following two time(!) values and get the result in such a format which also displays the number of days. 11:11:11 22:22:22 ----------- 33:33:33 (should be like 01:09:33:33) If I change the result cell format to custom 'DD:HH:MM:SS' the cell format category is automatically changed from 'time' to 'date' and the result is 31:09:33:33! This is the root of the problem, the cell category should always remain 'time' as I am working with time values and not with dates! The 'time' cell category itself should contain this required 'day-time' format (not date-time) which is missing at the moment. (May be it could be marked different from DD:HH:MM:SS.) Some other notes: 1) Comment #9 should not be relevant in this case as we are speaking about times and not dates! 2) Is this automatic cell category conversion feature OK? It leads to such dangerous situations! 3) I am not an expert of Calc but maybe there should be an error message/sign when the result doesn't fit in the specified HH:MM:SS format! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs