The OpenDef worksheet is located
as the last worksheet in the workbook. It is probably needed in very rare cases
only. The worksheet contains on the left hand side the actual used mapping for the columns. The
default value is 1 which means that Excel interprets the value on its own. On
the right hand side
the pre-defined values for the respective
report type are listed. If you need to define your own mapping please only
enter a 2 for each column which should be interpreted as a string value in the “By
Definition”
row of the table. In the example shown below
the 2s are the same as for the “LPAR Activity Report”.