Errors Cause Missing Data
I copy data from a LibreOffice Spreadsheet and paste it to LibreOffice Base. After selecting the column data type, I get a Java exception error. Data is missing in three columns of the created table. Two of them have the date data type and the other one has the varchar data type. Is it a bug? Also, when I try to repeat the process, I can't get the create table part work. It seems to be another bug.
For a request, I attach a screenshot of a part of the spreadsheet file to this post.
We need a little more information to try to help you. What kind of database setup/connection do you have - HSQLDB embedded, Firebird embedded, etc. What is your computer setup (computer type & operating system), what version of LibreOffice are you using? Please give a step by step list of your data importing procedure - including whether (or not) you you are creating the empty database table first before you are importing your data. Are the columns in your Cal sheet formatted property? Dates should be formatted as DATE type and YYYY-MM-DD. See the GUIDELINES for importing data from Calc into Base HERE.