Ask Your Question
0

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.

Edit:
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
0

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
0

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

pierre-yves samyn gravatar image

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

Hi

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.

screenshot

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

[EDIT]

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.

Regards

edit flag offensive delete link more

Comments

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

Hallo

search here

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

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

Stats

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

Seen: 146 times

Last updated: Aug 29 '15