Radians Function not defined in LO Calc 24.2.7.2?

[edgreenberg]

I wrote this line in a user defined function in the above LO version and got an error that a sub-function was not defined.

RADIUS = C/(2*SIN(RADIANS(dc/2)))

When I replaced it with:

RADIUS = C/(2*SIN((dc/2)*(pi()/180)))

My function works fine.

RADIANS() is mentioned in the “latest” help which is 24.8, but Ubuntu 24.04 is giving me 24.7. I can’t believe that RADIANS() is that new a function, so I’m confused. FOrtunately, my multiplying by pi()/180 works.

Anybody know what’s up withe the RADIANS() function?

[mikekaganski]

When you write user-defined functions, you are not in Calc, but in Basic. The spreadsheet functions are unavailable to you there (unless you create a special objects in Basic, and use them to call Calc).

Sometimes people get confused, because some functions in Spreadsheets have same-name counterparts in Basic (e.g., SIN vs. Sin), and sometimes not (the RADIANS); and sometimes the functions that people confuse are even considerably different, so confusing them, people get unexpected results (tdf#147366). That’s why we filed tdf#131382, and added clear labels for the scope of the functions.

Yes, Basic has no “Radians” function.