Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

CF_TIMEADD

Add or subtract a value from an existing time value.

CF_TIMEDIFF

Calculate the difference between two time values.

CF_TIMECONV

Convert one time value to another time value.

CF_GETTABLE

Insert data tables in the template workbook. Should be used in combination with the CF_GETDESCR function.

CF_GETDESCR

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.

CF_INFO

Return logged in client, user, active worksheet name or if template is generated or in design mode.

CF_GETPANEVALUE

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.

CF_RELATIVE

Return a cell value with relative row and column references.

CF_MONTHNAME

Returns the month name in text instead of a month number. For example, 01 will be returned as Jan.

CF_ISFORMULA

Available from Bizview 7.2

Evaluates if a cell contains a formula or not.

CF_STATICEvaluates formulas or nested functions and replaces them with the static value.

Published:

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

CF_TIMEADD

Add or subtract a value from an existing time value.

CF_TIMEDIFF

Calculate the difference between two time values.

CF_TIMECONV

Convert one time value to another time value.

CF_GETTABLE

Insert data tables in the template workbook. Should be used in combination with the CF_GETDESCR function.

CF_GETDESCR

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.

CF_INFO

Return logged in client, user, active worksheet name or if template is generated or in design mode.

CF_GETPANEVALUE

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.

CF_RELATIVE

Return a cell value with relative row and column references.

CF_MONTHNAME

Returns the month name in text instead of a month number. For example, 01 will be returned as Jan.

CF_ISFORMULA

Available from Bizview 7.2

Evaluates if a cell contains a formula or not.

CF_STATICEvaluates formulas or nested functions and replaces them with the static value.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk