Skip to content
Formula ExecuteFunction
The JS Runber pack for Code provides the Formula ExecuteFunction. ExecuteFunction requires at least two parameters:
The simplest possible example (and rather useless):
ExecuteFunction("function sumOfTwo() { return 1+2;}", "sumOfTwo")
The result is:
3
Additionally parameters can be passed to ExecuteFunction. Each of these parameters are provided to the function with functionName.
A simple example to calculate the sum of two values is:
ExecuteFunction("function sum(v1, v2) { return v1+v2;}", "sum", 1, 2)
And the result is:
3
Now you can calculate the sum of any two numbers!
A more complex example
ExecuteFunction("
function fibonacci(num) {
if(num < 2) {
return num;
} else {
return fibonacci(num-1) + fibonacci(num - 2);
}
}", "fibonacci", 10)
The result is:
55
Please note that this is a very inefficient algorithm to calculate the fibonacci number, it only serves as a simple example here.
Reference code from a formula
You can "store" your code in a formula, name the formula and then reference the code later to reuse it:
function fibonacci(num) {
if(num < 2) {
return num;
}
else {
return fibonacci(num-1) + fibonacci(num - 2);
}
}
Use it like this:
ExecuteFunction(thisDocument.fibonacci, "fibonacci", 10)
And the result is again:
55
Reuse code from a formula in a table
Once you have the code reusable, you can use a table to calculate a set of values:
The first n fibonacci numbers
N
Fibonacci(N)
1
1
2
1
3
2
4
3
5
5
6
8
7
13
8
21
9
34
10
55
There are no rows in this table
And see how it grows:
Chart of The first n fibonacci numbers
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.