Ask Your Question

Copying data in Base changes Field Types to VARCHAR

asked 2021-01-08 17:10:28 +0100

Hampers gravatar image

I'm new to LO and setting up a db previously in Access which was run on a Mac through Parallels, LO on same machine and s/w.. Have set up db, forms and reports but am having a problem as when pasted data into Base from Calc its resetting defined Field Types from Date or Decimal to Text (VARCHAR). I am obviously doing something wrong but its driving me mad and have tried many variations to try and sort it! My problem is that am unable to total a column on a report as not Decimal, important report as well. Apologies if a repeat question and many thanks. Phil Even with this issue have to say am very impressed with the SW and enjoyable using it.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-08 17:54:32 +0100

Ratslinger gravatar image


In creating a table from Calc data, you need to use the Next button to step through the process & insure the field types are correct. Here is a quick example.

Data in Calc copied. Pasted in Base table section. Used Next button to get to :

image description

You can see amount field is set as varchar.

Make appropriate changes:

image description

When finished:

image description

Note. In this example I let the system generate a primary key field - ID.

edit flag offensive delete link more


Not sure where to answer and thank you! The simplest solution, I was looking too deeply. Thanks very much, Phil

Hampers gravatar imageHampers ( 2021-01-08 18:35:48 +0100 )edit


What you did is fine. Glad all has worked out for you.

Ratslinger gravatar imageRatslinger ( 2021-01-08 18:49:17 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-08 17:10:28 +0100

Seen: 19 times

Last updated: Jan 08