Custom Formula Functions"
From Documentation
Line 4: | Line 4: | ||
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 <tt>=MYFORMULA(A1)</tt> 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. | 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 <tt>=MYFORMULA(A1)</tt> 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 |
Revision as of 07:12, 17 July 2013
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