libreoffice version 5.2.2.2 When designing query with librebase then average AVG function in query design view, produces a syntax error and one can not run query, save or go to SQL view. A work around is to use MAX function instead, go to SQL view, change by hand the MAX to AVG and save without going to design view again.
Using wizard for creating query the AVG function does not produce any errors and query is saved and running successfully. you can see it by opening it directly in SQL. But again if you opened the query in design view and try in there the SQL view the problem appears again.
To me it sounds like a bug in the software provided upstream. I will close this bug here, because I do not see a relation to the gentoo ebuild or the way gentoo handles this special software package. Please provide more information, if I am wrong.
Just for the shake of completion. The problem was that since I'm Greek I had user interface in greek language. As soon as I choosed from Tools/Options/Language Settings/User interface: English (USA) the problem disappeared both on debian and gentoo