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: [email protected]
ReportedBy: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
