Problem pasting dates into Base

[Futures38]

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.

I’m using a PC with the latest version of LibreOffice.

Any ideas?

[anon73440385]

I’m using a PC

But you don’t tell, which operating system

> latest version of LibreOffice.

Latest is quite subjective, taking into account that e.g. Linux PPAs for Ubuntu systems might consider something different as latest than 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, …)

Please use **[edit](https://ask.libreoffice.org/t/problem-pasting-dates-into-base/53164)** to provide additional information.

[anon73440385]

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)

[iplaw67]

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 ?

[Futures38]

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.

[anon73440385]

Besides the fact that this post isn’t an answer to your question, this is one of the most ignorant responses to willing helpers, I’ve read on the ask site. You absolutely didn’t provide any information about your system and then start complaining about assumption, which you forced to be made due to lack of information. I suggest you try a different system or find that simple solution to your simple problem and stop wasting time of volunteers here.