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 V126.96.36.199.
The attached file contains the macro I used. The column headers and the formats were set manually.
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.
It’s easy to count : just open a Calc spreadsheet and hit
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
Nah, 497 (plus a few identical ones with suffixed duplicated names for interoperability).
5 mins of my life i count.
Its really 497!