Description: ik gebruik libreoffice base Versie: 6.0.3.2 Build ID: 1:6.0.3-0ubuntu1 de import ook geprobeerd in libreoffice versie 5 daar geen probleem. Actual Results: niets Expected Results: niets Reproducible: Always User Profile Reset: No Additional Info:
Language for bugreports should be English - not many persons will understand Netherlands. What is the content of the error you get when trying to Import a Calc-table to Base? Which internal database do you use? (HSQLDB or Firebird?) Did you activate the experimental features? (Firebird and Firebird-migration will be activated with this, too. Migration isn't working well at this moment!) You are using the Ubuntu-version of LO. Note: There are appearing special bugs for versions, which are packed separately from other distributors. Build-version from LibreOffice directly will be something like this: Version: 6.1.0.3 Build-ID: efb621ed25068d70781dc026f7e9c5187a4decd1
@René : we need more information. Please answer Robert's questions. We also need a step by step list of instructions in order to try and reproduce the issue, and a sample spreadsheet and database from which to attempt the import. Please bear in mind that you should not post any confidential data here or attach a file to the bug report which contains any such confidential data.
1e calc-table select rows copy 2e open libreoffice base select table then past rows in table then error . ik use libreoffice versie 6.0.3.2 on ubuntu studio 18.04 have now update to libreoffice versie 6.0.6.2 buil ID 1:6.0.6-0ubuntu0.18.04.1 error is er nog steeds.
Created attachment 144167 [details] error copy calc too base
Comment on attachment 144167 [details] error copy calc too base The error says: There is one value in the Calc-table, which is to long for the field in the table "Postcode". For example: In Germany we have postcode '45321' - five numbers. So I will set "Postcode"."Postcode" to a string with 5 characters (Postcode could begin with '0'). And when I take a table from calc where a "Postcode" with more than 5 characters exist it couldn't save this row. An error appears. Have a look at the length of the fields of your tables and then at the length of the content in Calc-table.
@René: As Robert has pointed out, the error message indicates that one of the values in the cells you are trying to copy/paste into the Base table is too long for the length of field you have defined in your Postcode table. Only you can find that out, as we don't know the structure of your postcode table, nor do we know the cell values that you are trying to copy. This doesn't appear to be a valid bug report, unless you can show us that the postcode table has field definitions which should not raise such an error when compared to the data that you are trying to paste in from the Calc sheet.
Thanks, Thanks, problem found in base was postcode field length of 7, in calc was inhoud of field postcode 8 length "3161 GH " Thanks, Groet René Buis
(In reply to René Buis from comment #7) > Thanks, Thanks, > problem found in base was postcode field length of 7, in calc was inhoud of > field postcode 8 length "3161 GH " Good to read this. I will set this bug to RESOLVED and NOTABUG.