Note: This is a public test instance of Red Hat Bugzilla. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback at bugzilla.redhat.com.
Bug 1720589
Summary: | Pivot table fails to refresh or create from mariadb database table | ||||||
---|---|---|---|---|---|---|---|
Product: | [Fedora] Fedora | Reporter: | Anil Seth <seth.anil> | ||||
Component: | libreoffice | Assignee: | Caolan McNamara <caolanm> | ||||
Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||
Severity: | high | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | 30 | CC: | caolanm, dtardon, erack, sbergman | ||||
Target Milestone: | --- | ||||||
Target Release: | --- | ||||||
Hardware: | Unspecified | ||||||
OS: | Linux | ||||||
Whiteboard: | |||||||
Fixed In Version: | libreoffice-6.2.4.2-4.fc30 | Doc Type: | If docs needed, set a value | ||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2019-06-18 18:14:35 UTC | Type: | Bug | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Attachments: |
|
This looks a lot like https://bugs.documentfoundation.org/show_bug.cgi?id=125808 which I fixed upstream during the week FEDORA-2019-65570a4e9e has been submitted as an update to Fedora 30. https://bodhi.fedoraproject.org/updates/FEDORA-2019-65570a4e9e libreoffice-6.2.4.2-4.fc30 has been pushed to the Fedora 30 testing repository. If problems still persist, please make note of it in this bug report. See https://fedoraproject.org/wiki/QA:Updates_Testing for instructions on how to install test updates. You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2019-65570a4e9e libreoffice-6.2.4.2-4.fc30 has been pushed to the Fedora 30 stable repository. If problems still persist, please make note of it in this bug report. |
Created attachment 1580636 [details] Screenshots of the current and previous version pop-up screens Description of problem: Libreoffice calc chosing the option Data/Pivot Table/Refresh clears the existing data. If I try to create a pivot table, it shows no columns available. The problem showed up with the upgrade to 6.2.4.2-1.fc30.x86_64. Reverting to version 6.2.3.2-1.fc30.x86_64 makes the problem go away. Version-Release number of selected component (if applicable): 6.2.4.2-1.fc30.x86_64 and 6.2.4.2-2.fc30.x86_64 How reproducible: Consistent Steps to Reproduce: 1.Using Mariadb, Create a table NAV in testdb, with columns id, value 2.Install libreoffice-base if not already present 3.Use base to connect to a mysql database. testdb using jdbc connection and register the database as NAVDB. 4.Create a new spreadsheet. 5.Create a Pivot Table(Data/Pivot option) using Data Source registered in LibreOffice 6. Select NAVDB Table dbname.nav Actual results: The pop-up page shows up with an empty list of Available Fields. Expected results: The pop-up page should show 2 available fields - id and value Additional info: