Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 08 Oct 2020 22:35:24 +0200How many functions are implemented in libreoffice?https://ask.libreoffice.org/en/question/270143/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?Thu, 08 Oct 2020 14:12:11 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/Answer by Lupp for <p>Hello!
I am writing an essay about opensource and i would like to know, How many functions (in Calc) are implemented in libreoffice?</p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270175#post-id-270175As 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.
[C:\fakepath\showFunctionDescriptions.ods](/upfiles/16021743152003656.ods)Thu, 08 Oct 2020 18:26:45 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270175#post-id-270175Comment by Lupp for <p>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 <code>com.sun.star.sheet.FunctionDescriptions</code> and got <em>508</em> functions with LibO V7.0.1.2. <br>
The attached file contains the macro I used. The column headers and the formats were set manually. <br>
<a href="/upfiles/16021743152003656.ods">C:\fakepath\showFunctionDescriptions.ods</a></p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270239#post-id-270239@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.Thu, 08 Oct 2020 22:35:24 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270239#post-id-270239Comment by erAck for <p>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 <code>com.sun.star.sheet.FunctionDescriptions</code> and got <em>508</em> functions with LibO V7.0.1.2. <br>
The attached file contains the macro I used. The column headers and the formats were set manually. <br>
<a href="/upfiles/16021743152003656.ods">C:\fakepath\showFunctionDescriptions.ods</a></p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270221#post-id-270221I 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!Thu, 08 Oct 2020 21:13:14 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270221#post-id-270221Comment by Lupp for <p>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 <code>com.sun.star.sheet.FunctionDescriptions</code> and got <em>508</em> functions with LibO V7.0.1.2. <br>
The attached file contains the macro I used. The column headers and the formats were set manually. <br>
<a href="/upfiles/16021743152003656.ods">C:\fakepath\showFunctionDescriptions.ods</a></p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270178#post-id-270178AOO 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().Thu, 08 Oct 2020 18:42:11 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?comment=270178#post-id-270178Answer by dartdront for <p>Hello!
I am writing an essay about opensource and i would like to know, How many functions (in Calc) are implemented in libreoffice?</p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270148#post-id-2701485 mins of my life i count.
Its really 497!Thu, 08 Oct 2020 14:36:10 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270148#post-id-270148Answer by erAck for <p>Hello!
I am writing an essay about opensource and i would like to know, How many functions (in Calc) are implemented in libreoffice?</p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270147#post-id-270147Open the Function Wizard and count ;-P
Nah, 497 (plus a few identical ones with suffixed duplicated names for interoperability).
Thu, 08 Oct 2020 14:33:11 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270147#post-id-270147Answer by mgl for <p>Hello!
I am writing an essay about opensource and i would like to know, How many functions (in Calc) are implemented in libreoffice?</p>
https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270146#post-id-270146Hello @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, MichelThu, 08 Oct 2020 14:27:24 +0200https://ask.libreoffice.org/en/question/270143/how-many-functions-are-implemented-in-libreoffice/?answer=270146#post-id-270146