CF_GETPANEVALUE
A report or form workbook is most often connected to a selection pane, in which the end-user makes necessary selections before the document is generated. The selected values are then inserted by the program in the PANE worksheet in the template workbook. The values selected by a user should be taken into account when generating the document, and therefore, the designer should link the values in the PANE worksheet to either the PARAM sheet or to the actual template.
Instead of designing a template with references to the PANE worksheet (for example, = PANE!C9), the function CF_GETPANEVALUE should be used. By using this function, the designer does not need to consider which cell the value should be fetched from, and thereby, the designer can avoid future design errors.
CF_GETPANEVALUE Function
=CF_GETPANEVALUE("<control tag in PANE>") where the parameter that needs to be defined is the control tag that exists in column A in the PANE worksheet.
The function will search the tag in the PANE worksheet and then return the value that exists in column C. The program will automatically insert the selected values from the Selection Pane in column B in the PANE worksheet in the template worksheet. In column C, the program will automatically insert the selected values from the Selection Pane in combination with any existing authorizations that may exist for the particular object.
In this example, the selected unit values should be inserted in the PARAM sheets as a global value, and therefore, the function CF_GETPANEVALUE is used to fetch the UNIT values from the PANE worksheet. However, this function can also be used in the actual template worksheet to get values from the PANE worksheet.