Custom Functions
In addition to the usual spreadsheet functions that Bizview supports, there are also some custom functions that can be very useful in template design.
Below is a list of custom functions: (select the parameter for more information)
Parameter |
Comment |
|---|---|
Add or subtract a value from an existing time value. |
|
Calculate the difference between two time values. |
|
Convert one time value to another time value. |
|
Insert data tables in the template workbook. Should be used in combination with the CF_GETDESCR function. |
|
Instead of running SQL queries to fetch object value descriptions, descriptive texts can be fetched with the help of this function. Should be used in combination with the CF_GETTABLE function. |
|
Return logged in client, user, active worksheet name or if template is generated or in design mode. |
|
Insert values in the template and/or PARAM sheet from the PANE worksheet. The PANE worksheet is automatically filled with the values that the end-user selects in the Selection Pane when generating the document. |
|
Return a cell value with relative row and column references. |
|
Returns the month name in text instead of a month number. For example, 01 will be returned as Jan. |
|
|
Available from Bizview 7.2 |
Evaluates if a cell contains a formula or not. |
|
CF_STATIC |
Evaluates formulas or nested functions and replaces them with the static value. |