Writing macros that act like built-in functions
Although Calc finds and calls macros as normal functions, they do not really behave as built-in functions. For example, macros do not appear in the function lists. It is possible to write functions that behave as regular functions by writing an Add-In. However, this is an advanced topic that is not covered here; see
https://wiki.services.openoffice.org/wiki/SimpleCalcAddIn.