Bug 142360

Summary: functions are no longer available in the base (database tool) component
Product: LibreOffice Reporter: Michael Chudobiak <mjc>
Component: BaseAssignee: Caolán McNamara <caolan.mcnamara>
Status: CLOSED NOTOURBUG    
Severity: normal CC: mjc, robert
Priority: medium    
Version: 7.1.3.2 release   
Hardware: All   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2
GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2
GOOD - fc34 calc function wizard. Works fine.
GOOD - fc33 calc function wizard. Works fine.

Description Michael Chudobiak 2021-05-18 18:19:39 UTC 
Description:
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 seen on Fedora 34, libreoffice-base-1:7.1.3.2-1.fc34.x86_64

I have also attached two screenshots showing the situation in Fedora 33 with libreoffice-base-7.0.5.2-1.fc33.x86_64. In both the base and calc function wizards, a full range of functions is available.


Steps to Reproduce:
1. Create a report in design view
2. add a text field in the detail area
3. F4 to show the right sidebar
4. Click "data" tab
5. Set data field type to "Field or Formula"
6. Click "..." in the "Data field" entry
7. Observe the launched Function Wizard

Actual Results:
Only "AUTHOR" and "TITLE" are shown as available functions.

Expected Results:
Many functions should be listed, starting with ABS, ACOS, ACOSH, AND ...


Reproducible: Always


User Profile Reset: No



Additional Info:
Works on Fedora 33. Does not work on Fedora 34.
Comment 1 Michael Chudobiak 2021-05-18 18:20:28 UTC 
Created attachment 172144 [details]
PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2
Comment 2 Michael Chudobiak 2021-05-18 18:20:52 UTC 
Created attachment 172145 [details]
GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2
Comment 3 Michael Chudobiak 2021-05-18 18:21:13 UTC 
Created attachment 172146 [details]
GOOD - fc34 calc function wizard. Works fine.
Comment 4 Michael Chudobiak 2021-05-18 18:21:33 UTC 
Created attachment 172147 [details]
GOOD - fc33 calc function wizard. Works fine.
Comment 5 Robert Großkopf 2021-05-18 19:00:20 UTC 
No problem to see all the functions here with LO 7.1.3.2 on OpenSUSE 15.2 64bit rpm Linux.
I'm using the original packages of LO. Which packages did you install?
Comment 6 Michael Chudobiak 2021-05-18 19:09:24 UTC 
Well, it wouldn't be a big surprise if it was a distro packaging issue. (This is seen across multiple desktops and users.)

Personally, I have:

[mjc@daisy ~]$ rpm -qa | grep libreoffice | sort
libreoffice-base-7.1.3.2-1.fc34.x86_64
libreoffice-calc-7.1.3.2-1.fc34.x86_64
libreoffice-core-7.1.3.2-1.fc34.x86_64
libreoffice-data-7.1.3.2-1.fc34.noarch
libreoffice-draw-7.1.3.2-1.fc34.x86_64
libreoffice-emailmerge-7.1.3.2-1.fc34.x86_64
libreoffice-filters-7.1.3.2-1.fc34.x86_64
libreoffice-graphicfilter-7.1.3.2-1.fc34.x86_64
libreoffice-gtk3-7.1.3.2-1.fc34.x86_64
libreoffice-help-en-7.1.3.2-1.fc34.x86_64
libreoffice-impress-7.1.3.2-1.fc34.x86_64
libreoffice-langpack-en-7.1.3.2-1.fc34.x86_64
libreoffice-math-7.1.3.2-1.fc34.x86_64
libreoffice-ogltrans-7.1.3.2-1.fc34.x86_64
libreoffice-opensymbol-fonts-7.1.3.2-1.fc34.noarch
libreoffice-pdfimport-7.1.3.2-1.fc34.x86_64
libreoffice-pyuno-7.1.3.2-1.fc34.x86_64
libreoffice-ure-7.1.3.2-1.fc34.x86_64
libreoffice-ure-common-7.1.3.2-1.fc34.noarch
libreoffice-writer-7.1.3.2-1.fc34.x86_64
libreoffice-x11-7.1.3.2-1.fc34.x86_64
libreoffice-xsltfilter-7.1.3.2-1.fc34.x86_64
Comment 7 Michael Chudobiak 2021-05-18 19:12:17 UTC 
Also reported at https://bugzilla.redhat.com/show_bug.cgi?id=1961805
Comment 8 Robert Großkopf 2021-05-18 19:23:49 UTC 
Have tested it also with the package of my distribution OpenSUSE 15.2 (LO 7.1.3.2). All functions will be shown there also.
Comment 9 Michael Chudobiak 2021-05-18 19:29:50 UTC 
Huh. I guess it is a Fedora problem. Deleting .config/libreoffice didn't help.
Comment 10 Eike Rathke 2021-05-19 09:51:30 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 11 Caolán McNamara 2021-05-19 12:09:35 UTC 
a problem with the system libformula in Fedora, fix submitted to fedora-updates