Bug 1961805 - functions are no longer available in the base (database tool) component
Summary: functions are no longer available in the base (database tool) component
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: libreoffice
Version: 34
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-05-18 18:04 UTC by Michael J. Chudobiak
Modified: 2021-05-29 01:04 UTC (History)
5 users (show)

Fixed In Version: libformula-1.1.3-30.fc34
Clone Of:
Environment:
Last Closed: 2021-05-29 01:04:15 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2 (304.12 KB, image/png)
2021-05-18 18:06 UTC, Michael J. Chudobiak
no flags Details
GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2 (131.10 KB, image/png)
2021-05-18 18:06 UTC, Michael J. Chudobiak
no flags Details
GOOD - fc34 calc function wizard. Works fine. (333.24 KB, image/png)
2021-05-18 18:07 UTC, Michael J. Chudobiak
no flags Details
GOOD - fc33 calc function wizard. Works fine. (145.12 KB, image/png)
2021-05-18 18:07 UTC, Michael J. Chudobiak
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Document Foundation 142360 0 None None None 2021-05-18 18:25:24 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.