How many functions are implemented in libreoffice?

Hello!
I am writing an essay about opensource and i would like to know, How many functions (in Calc) are implemented in libreoffice?

As counting is kind of a matter of luck probably, and short descriptions may be of interest in addition to the names, I used the UnoService com.sun.star.sheet.FunctionDescriptions and got 508 functions with LibO V7.0.1.2.
The attached file contains the macro I used. The column headers and the formats were set manually.
showFunctionDescriptions.ods

AOO 4.1.7 has 398 functions. Just a few of the functions additionally listed for LibO will actually be of much use, among them TEXTJOIN() and mainly REGEX().

I omitted he …_ADD and …_EXCEL2003 suffixed ones on purpose. Specifically those that when saved as .ods and reloaded are equivalent to the internal ones and result in function names without the suffix.

Thanks for the macro!

@erAck: Yes. I assumed so.
Anyway I wanted to have an updatable list including the prvoided descriptions myself, and therefore I took the opportunity to finally write the needed code. How to exlude the special duplicates, I didn’t know.

Hello @dartdront

It’s easy to count : just open a Calc spreadsheet and hit Ctrl+F2. As the category shows something like All, you have the whole list of functions under your astonished eyes. Take a good breath and count them !

Kind regards, Michel

Open the Function Wizard and count :stuck_out_tongue_winking_eye:

Nah, 497 (plus a few identical ones with suffixed duplicated names for interoperability).

5 mins of my life i count.
Its really 497!