Re: [libreoffice-users] Copying data from Calc to Base...
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 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 ) E = Date - Last (Format as DD MMM ) 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: users+unsubscr...@global.libreoffice.org 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
Re: [libreoffice-users] Copying data from Calc to Base...
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) C = Location (Default format) D = Date - First (Format as DD MMM ) E = Date - Last (Format as DD MMM ) Base: Created a database named Reactors and created fields: ID Interger [INTEGER] As you didn't specify it, and just in case : the ID column (or any column you wish since its contents is unique to the table) must be set as the Primary Key. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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