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

Ask Your Question

Problem pasting dates into Base

asked 2020-05-26 23:15:07 +0200

Futures38 gravatar image

updated 2021-05-27 13:52:46 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive close merge delete


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 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, ...)

Please use edit to provide additional information.

Opaque gravatar imageOpaque ( 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)

Opaque gravatar imageOpaque ( 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 ?

Alex Thurgood gravatar imageAlex Thurgood ( 2020-06-02 18:09:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-02 18:35:55 +0200

Futures38 gravatar image

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.

edit flag offensive delete link more


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.

Opaque gravatar imageOpaque ( 2020-06-03 10:57:38 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-26 23:15:07 +0200

Seen: 84 times

Last updated: Jun 02 '20