We will be migrating from Ask to Discourse on the first week of August, read the details here

# Problem pasting dates into Base

I have several Calc files that I want to import into one Base table. Each Calc file has three fields: Date (formatted as DATE) and two text fields. The fields in the Base table are formatted the same as in the Calc files and the column names match. The ID field populates itself fine. The problem is that when I paste a new file, Base pastes the dates from the previous file into the table.

For instance, the first Calc file had 5-May as the date on all the records. This went over fine. The second Calc file had 6-May on all the records. These all showed up as 5-May in the table. I've tried it about six times by now, but still get the same results.

Any ideas?

edit retag close merge delete

I'm using a PC

But you don't tell, which operating system

Latest is quite subjective, taking into account that e.g. Linux PPAs for Ubuntu systems might consider something different as latestthan what TDF (libreoffice.org) considers their latest of "fresh" or latest of "still" release. Hence please provide the info given in Help -> About LibreOffice

Since your question is related to Base, don't forget to mention your database (HSQLDB, Firebird, ...)

( 2020-05-26 23:26:16 +0200 )edit

If your are on Ubuntu based system: Check https://bugs.launchpad.net/ubuntu/+source/mutter/+bug/1879968 (and if I remember right using Wayland will circumvent that problem)

( 2020-05-26 23:46:39 +0200 )edit

Please also indicate your locale / language and timezone setup, as this can have an influence on the Calc copy maneuver. For example, you mention that you copy 5-May and try copying 6-May - how are these dates actually represented in your Calc sheet, which language is applicable to the sheet, and which to the cells containing the dates ?

( 2020-06-02 18:09:58 +0200 )edit

Sort by » oldest newest most voted

I'm sorry to say this, but I find your response to be full of assumptions, and it's making my question look far more complicated than it was. I'm using Win 7 on a PC. I used (and coded in) dBase III and IV for years, along with FoxPro and Access, and never had a problem like this: correctly-formatted dates and numbers always copied correctly the first time.

In my 69 years of experience on Planet Earth, I have repeatedly found that simple problems generally have simple solutions. I will try again a couple of times, and, if it still doesn't work, I'll try a different system.

more