https://bugs.freedesktop.org/show_bug.cgi?id=67235
Katrina Adams <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #11 from Katrina Adams <[email protected]> --- Hello, I may have another manifestation of the same bug. The LO version is 4.1.0.4 running on Ubuntu 12.04. We have a database, HSQLDB 2.3, which is used to store employee work time. We use Base as the front end. We use a split configuration db which is stored in a shared Dropbox folder. Two computers access the DropBox files, one is running Windows 8/LO 4.0.3.3 and the other is running Ubuntu 12.04/LO 4.1.04. All the tables, etc have been developed on the Windows machine. One table has 3 timestamp fields, two are set to default to current_timestamp when the record is created and the 3rd field is set to current_timestamp after a triggering event occurs. When you open the table in the Ubuntu LO the displayed dates are correct, however all times are set to 12:00 am. Although the display is incorrect, the correct system time is being recorded in the database. This is verified when the table is opened in the Windows LO, where all the records are correctly displayed. All formats in the table, forms and reports are set correctly. As a test I copied data from the table as displayed on the Ubuntu machine and pasted it into a Calc spreadsheet. The times were incorrectly displayed. I repeated the test on the Windows machine (accessing the same database), pasted the records into a spreadsheet, saved the spreadsheet and opened it on the Ubuntu machine. This time the time display was correct. I have also created a new table with a field default set to current_timestamp using the Ubuntu LO. This new table records the correct time in the db, but displays the incorrect time. I tried a query using datediff and the hours were calculated correctly, so the problem seems limited to the display. If this is posted in the wrong place, please let me know so I can repost correctly. Cheers, Katrina -- 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
