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.
Created attachment 172144 [details] PROBLEM - fc34 base function wizard. Where are all the functions? LO 7.1.3.2
Created attachment 172145 [details] GOOD - fc33 base function wizard. Lots of functions. LO 7.0.5.2
Created attachment 172146 [details] GOOD - fc34 calc function wizard. Works fine.
Created attachment 172147 [details] GOOD - fc33 calc function wizard. Works fine.
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?
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
Also reported at https://bugzilla.redhat.com/show_bug.cgi?id=1961805
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.
Huh. I guess it is a Fedora problem. Deleting .config/libreoffice didn't help.
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.
a problem with the system libformula in Fedora, fix submitted to fedora-updates