![]() ![]() 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |