Apache OpenOffice (AOO) Bugzilla – Issue 107443
When copying table columns, a default value is entered
Last modified: 2017-05-20 10:47:29 UTC
When copying DATE columns from one table to another (using Copy and Paste), the inserted column definition has a default value, even if the original column that was copied had none. This is an undesired change of content between copy and paste. (Found in StarOffice 9.1 on Windows/XP SP3)
Please describe your problems more elaborated, step-by-step. Under what OS that happens? You tried on other versions of OOo? Follow the issue tracker rules: http://qa.openoffice.org/issue_handling/basic_rules.html Upload an example file where you find this copy-paste issue, without sensitive data.
The OS was Windows/XP. I have a database with multiple tables. Some table columns (i.e. entity types) are present in many tables (e.g. valid_from, valid_until). So I thought it would save me time to copy and paste those common entities. Procedure: Mark the desired entities in the table design, then copy them. Switch to the target table and paste them. Now in the target table the new date entities have a default value like "01.01.1980", while the original entities do not have them. I have not tried other versions of OOo.
I tested in OOO320_m7, on winXP, Hungarian local settings, the default value which was inserted: 1901-01-01, same as you can find in "Format example" field, below the "Default value" in table design view. May be the value depend on local settings. I created example file, the date field was copied from Table1 to Table2. windl You can remove the default value in design view, and save table design.
Created attachment 66530 [details] example database
confirming, targeting, grabbing
I had made a mistake: The default is actually "01.01.01" (as indicated). Yes, I found out the work-around, but I thought I'll report it, because you'll have to be careful not to overlook that new default. Also, other data types (like INTEGER) also get a default value (0 in the case of INTEGER).
Reset assigne to the default "issues@openoffice.apache.org".