https://bugs.freedesktop.org/show_bug.cgi?id=51523
Bug #: 51523 Summary: EDITING: Database Format TIME [HH]:MM:SS not working Classification: Unclassified Product: LibreOffice Version: unspecified Platform: All OS/Version: All Status: UNCONFIRMED Severity: major Priority: medium Component: Database AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: cw...@home.nl In order to give the duration of a event in total houres, I made a list in Calc where one collumn has the format [HH]:MM:SS. The format in Calc works correctly. However by importing the data in Base, I get the message that this format is not supported in Base. Trying to make the tablefield by hand, the fieldformat TIME [HH]:MM:SS is accepted but it acts as HH:MM:SS. E.g. it shows only houres between 00:00:00 and 23:59:59. Input of a value larger than 23:59:59 results in starting to count from 00:00:00. The funny thing is if I make the fieldformat NUMMERIC (length 10 with 6 decimals), entering the nummeric timevalue (1,615278 = 38:46:00) and I use in a form this field with the format [HH]:MM:SS it displays the duration correctly. But using the form I can't make any changes in the field because then it returns to act as HH:MM:SS. Calculating and displaying correct time-events is a feature that a database should support. That is why i see this problem as major. Searching the internet I discovered that the problem exists in Libreoffice and Openoffice. There are lots of questions but no answers. And i cann't find the report of this problem. As OS I use Windows (Vista and XP) and Linux (Xubuntu) I use Libreoffice 3.5.4.2 but i think the problem is not version-specific. Greetings from a Dutch user. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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