Copying data in Base changes Field Types to VARCHAR

edit

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.