We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How many functions are implemented in libreoffice?

asked 2020-10-08 14:12:11 +0200

dartdront gravatar image

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

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2020-10-08 18:26:45 +0200

Lupp gravatar image

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.

edit flag offensive delete link more


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().

Lupp gravatar imageLupp ( 2020-10-08 18:42:11 +0200 )edit

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 gravatar imageerAck ( 2020-10-08 21:13:14 +0200 )edit

@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.

Lupp gravatar imageLupp ( 2020-10-08 22:35:24 +0200 )edit

answered 2020-10-08 14:36:10 +0200

dartdront gravatar image

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

edit flag offensive delete link more

answered 2020-10-08 14:33:11 +0200

erAck gravatar image

Open the Function Wizard and count ;-P

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

edit flag offensive delete link more

answered 2020-10-08 14:27:24 +0200

mgl gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-08 14:12:11 +0200

Seen: 69 times

Last updated: Oct 08 '20