(From the start, sorry for my english ect.)
When i create a table and select it, I cant unselect it and becouse of that libraoffice force me to add anything to that table. Everything would be okay cuz u can create table anyway but without ability to set type of data in columns it ends up with me pasting the data from calc, creating a table and clicking right mouse to get into “Edit” so i could change the type of columns. When i try to change type in that way i get an warning which say that there was some error and do i want to delate it and add again but after that the columns that i change are blank. Im really curious why there is no such a thing like clicking outside the “tables” Window to unselect.
There is the bug in import wizard (Bug 147174 - description).
If you will paste a table from Calc to Base and do not mark the background of Base table pane you will get the option Append Data to one of the existing tables. If you will switch to Definition and Data only the button Create could be chosen - not “Next”. Change the table name and press Create. A warning will appear:
A unique index or primary key is required for data record identification in this database.
You can only enter data into this table when one of these two structural conditions has been met.
Should a primary key be created now?
Now you have to press Cancel and get the step to define field types. If you haven’t done this before: Primary key could be created by right mouse click on the field, which is shown left on the dialog.