Flexible argument list in LibreOffice Calc Macro
- by Patru
I want to write a function that geometrically links performance data which is usually provided as percentages, so the function will basically return
(1+a)*(1+b)*(1+c)* … *(1+x)-1
This should be done using LibreOffice-calc and it should behave similarly to the regular sum function. As you may throw any number of arguments at sum I would like to be able to do the same with my alternative geoSum function but I am unable to find suitable documentation on handling a variable number of arguments with variable types (i.e. an arbitrary mix of numbers, cells and ranges).
How would I have to specify the arguments to my LibreOffice-Basic function and how would I have to interpret it?