When in Calc, be sure the date fields are actually defined as DATE type
and -MM-DD format before copy/paste.
Hope this helps.
On 7/22/20 11:33 PM, zed wrote:
Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate
I am trying to copy and paste a LibreOffice Calc file from that
program
Zed,
Le 23/07/2020 à 05:33, zed a écrit :
Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate
I am trying to copy and paste a LibreOffice Calc file from that program
to Base. Here is what I have done so far.
Calc - created spreadsheet
A = ID (Default format)
B = Name (Default format)
Hi Zed,
>
> Warning. Wrong data type:java.lang.IllegalArgumentException.
This only says: You will input, for example, a text in a field for dates.
Are there field-descriptions in the first row you wanted to import? Then
you have to chose "First row with fieldnames".
I see the fields in the
But in that case, I think it won't let you fill (or paste) ID field anymore.
I'm not sure, just memory recall, hope to be wrong.
Il gio 23 lug 2020, 05:59 Alan B ha scritto:
> Hello Zed,
>
> I haven't used 6.4 much yet except with already existing databases. With
> 6.0 (on Ubuntu) it was
Hello Zed,
I haven't used 6.4 much yet except with already existing databases. With
6.0 (on Ubuntu) it was required that there be an auto incrementing index
field or the import would fail with messages like you describe.
If your ID field is not set to auto increment modify the field property so
Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate
I am trying to copy and paste a LibreOffice Calc file from that program
to Base. Here is what I have done so far.
Calc - created spreadsheet
A = ID (Default format)
B = Name (Default format)
C = Location (Default format)
D = Date -