Bug 1961805

Summary: functions are no longer available in the base (database tool) component
Product: [Fedora] Fedora Reporter: Michael J. Chudobiak <mjc>
Component: libreofficeAssignee: Caolan McNamara <caolanm>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 34CC: caolanm, dtardon, erack, mjc, sbergman
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: libformula-1.1.3-30.fc34 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-05-29 01:04:15 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:
Description Flags
PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2
none
GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2
none
GOOD - fc34 calc function wizard. Works fine.
none
GOOD - fc33 calc function wizard. Works fine. none

Description Michael J. Chudobiak 2021-05-18 18:04:17 UTC
If I open a report in libreoffice base (database reporting), I no longer have access almost all of the built-in functions that the function wizard would normally show. A screenshot of the mostly empty base function wizard is attached.

The calc (spreadsheet) function wizard does show many available functions. A screenshot of the full calc function wizard is attached.

The above problem is for fc34, libreoffice-base-1:7.1.3.2-1.fc34.x86_64

I have also attached two screenshots showing the situation in fc33 (libreoffice 7.0.5.2). In both the base and calc function wizards, a full range of functions is available.

Comment 1 Michael J. Chudobiak 2021-05-18 18:06:09 UTC
Created attachment 1784547 [details]
PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2

Comment 2 Michael J. Chudobiak 2021-05-18 18:06:58 UTC
Created attachment 1784548 [details]
GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2

Comment 3 Michael J. Chudobiak 2021-05-18 18:07:28 UTC
Created attachment 1784549 [details]
GOOD - fc34 calc function wizard. Works fine.

Comment 4 Michael J. Chudobiak 2021-05-18 18:07:47 UTC
Created attachment 1784550 [details]
GOOD - fc33 calc function wizard. Works fine.

Comment 5 Eike Rathke 2021-05-19 09:52:21 UTC
The Base report builder is a Java component, make sure you have Java installed and it is recognized by LibreOffice (Tools -> Options -> LibreOffice -> Advanced) and activated.

Comment 6 Caolan McNamara 2021-05-19 10:53:02 UTC
I can certainly see only the two functions of the METADATA group in F34

Comment 7 Caolan McNamara 2021-05-19 11:42:35 UTC
I bet its...

commit a9382edd5c0a924e2f4abad7eded14bd2baa17d9
Author: Nicolas Lécureuil <neoclust>
Date:   Fri Jan 15 23:05:11 2021 +0100

    Remove ant-contrib support

* Fri Jan 15 2021 Nicolas Lécureuil <neoclust> - 1.1.3-27
- Remove ant-contrib support

there was a similar problem in libloader by a similar commit

Comment 8 Michael J. Chudobiak 2021-05-19 11:47:43 UTC
(In reply to Eike Rathke from comment #5)
> The Base report builder is a Java component, make sure you have Java
> installed and it is recognized by LibreOffice (Tools -> Options ->
> LibreOffice -> Advanced) and activated.

I can confirm that Java is activated.

Comment 9 Michael J. Chudobiak 2021-05-19 11:49:56 UTC
As a side note, this also prevents the use of the Accumulation/Minimum/Maximum scoped functions in footers.

Comment 10 Caolan McNamara 2021-05-19 11:59:21 UTC
yeah, guess in comment #7 is the problem

Comment 11 Fedora Update System 2021-05-19 12:01:06 UTC
FEDORA-2021-296701e093 has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2021-296701e093

Comment 12 Fedora Update System 2021-05-19 12:02:48 UTC
FEDORA-2021-296701e093 has been pushed to the Fedora 35 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 13 Fedora Update System 2021-05-19 12:07:25 UTC
FEDORA-2021-e300ac2fa8 has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2021-e300ac2fa8

Comment 14 Michael J. Chudobiak 2021-05-19 12:12:41 UTC
Thank you! libformula-1.1.3-30.fc34.noarch does fix the issue.

Comment 15 Fedora Update System 2021-05-21 01:35:03 UTC
FEDORA-2021-e300ac2fa8 has been pushed to the Fedora 34 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-e300ac2fa8`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-e300ac2fa8

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 16 Fedora Update System 2021-05-29 01:04:15 UTC
FEDORA-2021-e300ac2fa8 has been pushed to the Fedora 34 stable repository.
If problem still persists, please make note of it in this bug report.