Custom Formula Functions

Spreadsheet allows developers to implement their own custom formulas and use these formulas like built-in ones. You can just enter your custom formula like =MYFORMULA(A1) and it works like other formulas. To implement such a custom method is easy: just create a static method and declare it in a ZUL page with EL method or tag library.

1. simple formula. Spreadsheet evaluate arguments for you. Evaluate each argument as a single value, so only the first cell of a range of cells is evaluated. argument number is fixed.

2. multiple arguments numeric formula

3. multiple arguments formula