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 <[email protected]> ha scritto: > 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 > it auto increments then try the import again. > > On Wed, Jul 22, 2020 at 11:35 PM zed <[email protected]> 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 > > 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 - First (Format as DD MMM YYYY) > > E = Date - Last (Format as DD MMM YYYY) > > > > Base: > > Created a database named Reactors and created fields: > > ID Interger [INTEGER] > > Name Text [VARCHAR] > > Location Text [VARCHAR] > > Gender Text [VARCHAR] > > No. Number [NUMERIC] > > Date - First Date [DATE] > > Date - Last Date [DATE] > > > > Opened spreadsheet and highlighted columns (as listed above) > > (as a test I chose only Rows 1-6) > > > > Chose Copy and navigated to Database and clicked to Paste > > > > From Menu presented, chose Append data (the default option) > > clicked Next and unticked ID > > clicked Create and following error message was displayed > > > > Warning. Wrong data type:java.lang.IllegalArgumentException. > > > > Searched both Internet (in general) and LibreOffice website (in > > particular) but found nothing to help. > > > > Obviously I am doing something wrong but I am unable to find the > > error.All help will be very welcome. > > > > Zed > > > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > -- > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
