Flexible argument list in LibreOffice Calc Macro

Posted by Patru on Stack Overflow See other posts from Stack Overflow or by Patru
Published on 2014-06-01T03:20:57Z Indexed on 2014/06/01 3:24 UTC
Read the original article Hit count: 356

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?

© Stack Overflow or respective owner

Related posts about libreoffice-calc

Related posts about libreoffice-basic