
There are bugs with the copy/paste using these types. Do not use numeric or decimal field types in the definition. Personally would not use an embedded DB but if doing so use Firebird. How do I quickly export the data from my LibreOffice Calc spreadsheet into a proper (non dBase) LibreOffice Base database? I am using Ubuntu 18.04.2 with LibreOffice ‘fresh’ version 6.2.4.2. Again, CPU usage remains high only during the first seconds. If I create a second LibreOffice Base database with the default “Firebird Embedded” format, and try to drag the table from the first dBase database into this second database, both instances of Base hang. This is apparently a limitation of the underlying dBase format. If I save the spreadsheet from Calc in the dBase format, I can create a dBase database in LibreOffice Base, but then I cannot join the table with itself, because a query can only use one table. If I import the data from Calc to Base using the “copy and paste” method, my Ubuntu Linux 18.04 uses 100 % CPU for a few seconds, and then LibreOffice hangs. So I tried to import all the data into LibreOffice Base, in order to use an SQL query. I could not find an easy way to achieve this in LibreOffice Calc.

In the example above, that would be products A and C. I want to filter for products that contain components 1 and 2.

Product B is made of components 1, 2 and 5.Įven though the Microsoft Excel file (.xlsx) weighs 6 MB and has so many rows, LibreOffice Calc manages to open it pretty quickly. Product B is made of components 1 and 4. In the example above: - Product A is made of components 1, 2 and 3 I have a huge spreadsheet with 280,000 rows like this (somewhat simplified): Product Component
