This is a double question and a report of a bug, maybe, I do not exactly about the latter one.
I have a table in Calc that I copy (with labels in first column). All data in each column is coherent (no text as dates, nor text as numbers, etc.). Just copy the cells that I am interested in. Then open my ODB file in Base and go to Tables panel and paste it. The Tables Wizard opens.
In the first step, I choose Definition (not Data and Definition), and follow the next steps. I also choose to add a new primary key. All remaining steps with no frills. When I hit the Create button, nothing happens. No new table is added.
I assume the Definition option will create the structure of a table with such and such definitions. Maybe I am wrong. I skimmed thru the LibOBase 6.4 Guide and I couldn’t find anything about creating tables from Calc spreadsheets using the pasting feature.
Instead, when I do the same procedure, except that I choose Data and Definition in step 1 of Tables Wizard, everything is OK. I get my new table. Of curse I can erase all the pasted records and I get my definition… but that not the point. I believe this is not the way to go.
- My first question is how can I paste the definition only of a Calc sheet into a new table in Base (using the
pasting feature), so I can enter data later?
- My second question is what is the Definition option (in step 1 of Tables Wizard) intended for?
If this is an irregular/buggy behavior, I’ll post a bug report, of course.
I have tested this behavior in LibO 6.2 and 6.4 in Lubuntu 20.04.