Trying to copy data from calc to base

asked 2018-12-27 01:59:32 +0200

Exd31 gravatar image

In my attempts to do the above, It will not fill the primary key. When I created the table I selected it to auto. When I copy the data accross all the other field populate except that one. I am following this guys tut on youtube

youtube.com/watch?v=D_W-FAT3XE4&t=0s&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=4

My version is 4.3.2.2.0+ Linux os Thank you

edit retag flag offensive close merge delete

Comments

Hello,

That is a very old version. Why not upgrade to a newer one? Didn't watch the video since they can be outdated and to me a waste of time. In testing in Linux 18.3 using LO version 6.1.4.2 there was no problem in the primary key being populated.

Please provide all the steps you are using.

Ratslinger gravatar imageRatslinger ( 2018-12-27 02:42:57 +0200 )edit

Thank you Ratslinger I have base open and a calc open . In the calc I hold the mouse down on the page at the bottom and drag it into the base, where it asks some questions about data and setting the primary key then creates the table. It is possible that this method come from another of his vids.

Exd31 gravatar imageExd31 ( 2018-12-28 02:00:42 +0200 )edit

That is essentially the same process. Again I DON'T deal with videos. They are outdated quickly and can be confusing depending on the OS.

The danger with dragging a tab is that there may be many sections on a sheet therefore confusing the process as to what goes into a table.

Ratslinger gravatar imageRatslinger ( 2018-12-28 02:19:57 +0200 )edit