If one copies one or more table fields from a table design view and pastes them into a new table in design view then the comments are lost. If the source field definitions have a custom date format then that format appears in the default value field in the destination table definition. For example: Source table Field Name Field Type Description * date_effective_from Date/Time[TIMESTAMP] Date before which . . . date_effective_from Date/Time[TIMESTAMP] Date after which . . . Entry required No Decimal places 0 Default value Format example 1900-01-01 00:00 Destination table after copy and paste before save Field Name Field Type Description * date_effective_from Date/Time[TIMESTAMP] date_effective_from Date/Time[TIMESTAMP] Entry required No Decimal places 0 Default value 1900-01-01 00:00 Format example 1900-01-01 00:0000 Destination table after save, exit, open and edit Field Name Field Type Description * date_effective_from Date/Time[TIMESTAMP] date_effective_from Date/Time[TIMESTAMP] Entry required No Decimal places 0 Default value 1900-01-05 00:00 Format example 1900-01-05 00:00 Note that in the design view of the new table each time that I click on the field type for either of these field the Default value and the Format example changes. It apparently increments the day by 2 and the month will roll over if one repeats selecting and deselecting the Field Type a sufficient number of times.
Created attachment 111780 [details] LOBASE: simple base file showing results of table design cut and paste This simple database design contains two tables, tbl_bugs and tbl_new_bugs. tbl_bugs was created in design view and the manually entered design rows given descriptions. tbl_new_bugs was also created in the design view but all of the design elements, other than the the primary key were copied from tbl_bugs and pasted in. The results are that all of the descriptions are lost and the DATE/TIME[TIMESTAMP] fields are given default values that do not exist in the original table. This particular database was created and modified entirely on a CentOS-6.6 Linux host. It exhibits precisely the same behaviour as noted on OSX-10.9.5.
I can confirm with LO 4.3.5, win7. In my case is Destination table after save, exit, open and edit Field Name Field Type Description * date_effective_from Date/Time[TIMESTAMP] date_effective_from Date/Time[TIMESTAMP] Entry required No Decimal places 0 Default value 1900-01-03 00:00 Format example 1900-01-03 00:00
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.