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
libreoffice-calc
|libreoffice-basic
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