https://bugs.freedesktop.org/show_bug.cgi?id=88032
Bug ID: 88032
Summary: EDITING: Anomalies when copying field definition rows
between tables in design view
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
Assignee: [email protected]
Reporter: [email protected]
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.
--
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
