Considerations for changing binding values

If a graph is configured to display information for n number of tags and the tag binding range is programmatically edited to include more tags than that number, the graph does not include the additional tags. The data in the function, however, is updated to include all the tags.

When you develop the report layout, be sure to allow adequate space for additional rows or columns that might appear as the result of changing the binding values or how the add-in RunReport method resizes the functions.

The resizing logic is:

• Check each filled cell in the sheet and determine if the cell contains a AVEVA Historian Client function.

• If a cell contains a function, determine if it is an array function.

• If so, determine if the cell is the first cell in the array.

• If so, determine how many rows the array formula occupies and how many it needs to occupy as the result of the resizing.

• Add additional rows as needed.

If the add-in cannot add rows or additional columns, the function is not updated. The function occupies single cell, indicated by red background as unable to be resized.