I've read here that we can use a pretty complicated syntax in order to have access to LibreOffice functions in the Basic macro editor, rather than writing functions in a sheet and get the data back.
Are there current best practices related to this problem, i.e. obtain a result without writing a formula to a sheet ?