Description: When loading a pivot table from a database, there is a 5-10 minute lag before getting the pop up that allows you to move the columns to the appropriate places. The table in question has around 25 data points and about 900 entries. It is being loaded over a LAN connection with a computer on the local network. The actual loading and refreshing of the table, however, only takes seconds. Steps to Reproduce: 1. Create and load a table in base. 2. Put in any substantial amount of data points and entries. 20+ data points and 500+ entries. 3. Select to add a pivot table. 4. Select the table from the database. 5. Click okay. Actual Results: Very long delay which causes LibreOffice to freeze up. After waiting 5-10 minutes, it finally loads. Expected Results: Relatively quick load time, given it should only be getting the table columns at that point. Again, the actual table loading once all of the columns are dropped into the pivot table happens in seconds. Reproducible: Always User Profile Reset: No Additional Info: Only happens with large tables. Small tables from the same database load the columns quickly, near instantaneous.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
@Duyn - I see only one file is allowed to be uploaded at a time. However, this bug requires both a calc file and a database file. But the uploader only allows 1 file to be uploaded at a time. Should I upload each separately? Also, there will be some assembly required to get the database file to show up in the data sources.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to J Johnson from comment #2) > @Duyn - I see only one file is allowed to be uploaded at a time. However, > this bug requires both a calc file and a database file. But the uploader > only allows 1 file to be uploaded at a time. Should I upload each > separately? Also, there will be some assembly required to get the database > file to show up in the data sources. Yes, each separately.