Ask Your Question

Syntax name Calc's functions [closed]

asked 2015-08-28 22:10:23 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to know more about syntax of clac functions. It's name? and Is it global syntax?. as you know it's used also in MS.Excell too. It seems to be a independent programming language.

I mean the global name of programming language. Something like (Python, C and etc.)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-23 21:32:57.329246

3 Answers

Sort by » oldest newest most voted

answered 2015-08-28 23:27:15 +0100

m.a.riosv gravatar image

The easy way is through the function wizard Fx on the formula bar, all are there and clicking on their name you can see a breve description. Selecting one of them you can see their parameters and positioning in one their specific description.

edit flag offensive delete link more

answered 2015-08-29 09:58:49 +0100

pierre-yves samyn gravatar image

updated 2015-08-29 16:54:44 +0100


There is also the Function List (menu Insert or directly in the sidebar). Functions can be sorted by category and the list displays the syntax and a brief description.


The functions are also described in Help (F1) with examples of use.


It is possible to program with LibreOffice Basic, Python, JavaScript, BeanShell... and the API can be used by any other language such as C. This documentation page provides access to various examples.


edit flag offensive delete link more


I know how to access functions. My question is about the global name of the whole programming language. and not just name of functions. for example something like (Python, C and etc.)

Mohammad Etemaddar gravatar imageMohammad Etemaddar ( 2015-08-29 16:11:46 +0100 )edit


search here

karolus gravatar imagekarolus ( 2015-08-29 22:28:20 +0100 )edit

answered 2015-08-29 18:24:07 +0100

horst gravatar image

The functions are defined in the OASIS Document and referenced as OpenFormula. This documents was written by many software companies including MS. That is why you find the same names in Calc, Excel and other spreadsheets. Many names (SUM) date back to the first spreadsheet VisiCalc which is now owned by IBM/Lotus.

I think you can not refer to it as an "indepentent programmimg language".

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-08-28 22:10:23 +0100

Seen: 146 times

Last updated: Aug 29 '15