CF_STATIC
The CF_STATIC function can be used to evaluate formulas or nested functions and replace them with the static value so that the formulas don't need to be re-evaluated every time they are used in the template. This function applies to both FORM and REPORT template types.
Important: The CF_STATIC function should be the outermost function to be evaluated. It cannot be used in the middle of the function, as it must be a root function.
Below is an example of how to use CF_STATIC with custom functions:
In this case, if the CF_GETPANEVALUE (VERSION) function returns a value (e.g. 2021), that value will be the result of the CF_STATIC function.
Below is an example of how to use CF_STATIC with formulas:
In this case, if the value in cell G6 is "MONTH", the result of the CF_STATIC function will be "MONT" (the first four characters).
When a cell contains a formula or function the CF_STATIC function is accessible in the right-click cell context menu, as shown below:
Once the CF_STATIC function is added to the cell, you can remove the function by right-clicking in the cell again and selecting Remove CF_STATIC, as demonstrated below:
When removing CF_STATIC, the following applies:
If the argument of CF_STATIC is a function (e.g. =CF_STATIC(CF_GETPANEVALUE(UNIT)), then the inner function will remain in the cell (e.g. CF_GETPANEVALUE(UNIT)) and only CF_STATIC will be removed.
If the argument of CF_STATIC is a formula, then the formula will remain in the cell and only CF_STATIC will be removed.