https://bugs.freedesktop.org/show_bug.cgi?id=51523
--- Comment #8 from Cocky Cwiek <[email protected]> 2012-06-28 12:04:04 PDT --- I mostly use Spreadsheets to collect data and plan the deviation in tables. Now the goal is to insert the specific duration of a event. Attached i have a CALC-sheet called Example Sheet.ods. In the Netherlands we don't work with AM/PM but i made a few collumns with differend variations of the format TIME. I did set the language of the format to English(VS). Take note of the following collumns: In the first collumn (DUR_[HH]) you see the display of the duration to be expected. It has the format TIME [HH]:MM:SS and it keeps counting the Houres even if the duration is longer than 24 houres. In the second collumn (DUR_HH) The format is TIME HH:MM;SS. The difference here is that this format only displays time between 00:00:00 and 23:59:59. In the last collumn (DUR_DEC) The format is NUMMERIC 0.000000 Now I create a new Database called Example Base.odb (attached) and let Libreoffice registrate the database. In the sheet i select the range A1:E5 and choose Copy In the base i choose Paste defenitions and data using the first row as header and letting Base make a primary Key. Then i add all the fields and set the fieldtype as TIME exept the last field wich is NUMMERIC with 6 decimals and saving the table as TabelTIME Now i get a warning "Wrong data type: java.lang.IlligalArgumentExeption". Do you wish to continue? Yes! If you look at the table now, you see that the field (DUR_[HH]) acts as format HH:MM:SS Importing the fields with AM/PM time does not work correctly because it fails to take over the language-setting (not importand to me i suppose but worth mentioning). Next step is creating a Form (FormTIME) based on the table. I used the form wizzard with default settings. And then i made a change in the format of the last field. I changed it in [HH]:MM:SS. The result is that it displays the duration now correctly. But the problem is that i can't change the value of the field in the form because than it starts acting as HH:MM:SS and i get a failure message "java.lang.NumberFormatExeption". -- 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
